{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["Table 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Table 2","index":0,"n_rows":89,"n_cols":24,"rows_kept":89,"cut":false,"hidden":false,"merged":[[84,0,84,23],[85,0,85,23],[87,0,87,23],[88,0,88,23],[86,0,86,23],[58,1,59,1],[1,0,1,23],[3,1,4,1],[2,1,2,23],[57,1,57,23],[3,5,3,20],[58,5,58,20]],"flags":["formulas_cached_only"]}
["National Center for Education Statistics"]
["Table 2.—Current expenditures for public elementary and secondary education, by function, subfunction, and state or jurisdiction: Fiscal year 2007"]
[null,"Current expenditures1 [in thousands of dollars]"]
[null,"Total",null,null,null,"Support services2"]
["State or jurisdiction",null,null,"Instruction",null,"Total",null,"Student support services3",null,"Instructional\nstaff\nsupport",null,"General \nadministration",null,"School \nadministration",null,"Operation \nand maintenance",null,"Student \ntransportation",null,"Other \nsupport \nservices",null,"Food\n services",null,"Enterprise operations"]
["United States4",476825865.5870001,5,290710402.11,5,166881037.56400004,5,25200234.141,5,23152420.704000007,5,9337239.150999999,5,26875251.925000004,5,46824903.93699999,5,19979044.184000004,5,15511943.522,5,18149847.424999997,5,1084578.4880000001]
[]
["Alabama",6245031.142,null,3655693.99,null,2177596.317,null,330676.76,null,304553.819,null,163763.839,null,386391.692,null,565368.338,null,298362.872,null,128478.997,null,411740.835,null,0]
["Alaska",1634316.198,null,931067.886,null,649395.092,null,105338.999,null,91130.314,null,23733.223,null,97485.442,null,216326.027,null,55387.548,null,59993.539,null,47233.643,null,6619.577]
["Arizona",7815720.283,null,4751054.559,5,2719231.764,5,554492.491,5,185912.133,5,124069.978,5,382067.351,5,858695.267,5,293162.76,5,320831.784,5,345433.96,null,0]
["Arkansas",3997700.616,null,2365794.205,5,1422035.15,5,189032.879,5,286026.61,5,103452.54,5,214948.761,5,382273.735,5,145777.987,5,100522.638,5,208158.775,5,1712.486]
["California",57352599.016,null,34461563.477,5,20713553.215,5,2731324.254,5,3815115.059,5,551573.551,5,3854644.221,5,5867942.997,5,1406157.043,5,2486796.09,5,2055897.503,null,121584.821]
[]
["Colorado",6579052.978,null,3805178.925,null,2532061.579,null,297655.505,null,350384.821,null,112911.581,null,446154.017,null,662342.751,null,195041.288,null,467571.616,null,211914.804,null,29897.67]
["Connecticut",7855458.525,null,4934291.981,5,2654232.679,5,476949.856,5,256306.354,5,156887.956,5,441701.031,5,759692.815,5,381894.207,5,180800.46,5,198102.222,5,68831.643]
["Delaware",1437706.882,null,861627.042,null,513581.069,null,72978.859,null,19824.149,null,17710.535,null,80565.021,null,143368.64,null,90899.9,null,88233.965,null,62498.771,null,0]
["District of Columbia6",1130005.861,null,586075.921,null,520716.349,5,62725.63,5,77706.511,5,26199.38,5,61518.952,5,150810.577,5,84513.466,5,57241.833,5,23213.591,null,0]
["Florida",22887023.787,null,13646302.417,5,8239301.228,null,1061830.972,5,1533846.082,5,221441.735,5,1298583.674,5,2529738.47,5,953467.639,5,640392.656,5,1001420.142,null,0]
[]
["Georgia",14828714.988,null,9357131.563,5,4716438.111,5,695559.155,5,776178.75,5,191376.217,5,884478.883,5,1071342.318,5,593437.699,5,504065.089,5,713136.269,null,42009.045]
["Hawaii6",1998912.686,null,1177781.055,null,732535.592,null,240925.022,null,68882.774,null,19978.994,null,136602.002,null,179079.162,null,36263.859,null,50803.779,null,88596.039,null,0]
["Idaho",1777491.117,null,1091113.361,5,603196.845,5,99814.766,5,79857.193,5,40927.043,5,99321.416,5,164263.177,5,84942.314,5,34070.936,5,83102.39,5,78.521]
["Illinois",20326590.816,null,11970049.536,5,7699013.603,5,1322640.103,5,936584.23,5,671353.64,5,1050243.304,5,2016805.098,5,999555.531,5,701831.697,5,657527.677,null,0]
["Indiana",9497077.437,null,5695474.088,5,3392703.531,5,421863.096,5,294478.097,5,181103.593,5,545142.515,5,1038664.178,5,538166.098,5,373285.954,5,408899.818,null,0]
[]
["Iowa",4231932.496,null,2546474.804,null,1486916.09,null,242161.566,null,195895.978,null,114780.51,null,255076.639,null,388177.012,null,153011.048,null,137813.337,null,193065.148,null,5476.454]
["Kansas",4339477.193,null,2632372.59,null,1512389.978,null,244480.491,null,197802.077,null,135041.353,null,251410.124,null,411569.107,null,167225.34,null,104861.486,null,194714.625,null,0]
["Kentucky",5424620.88,null,3223881.143,null,1880490.92,null,232617.08,null,295213.945,null,117991.781,null,297284.197,null,502287.277,null,311953.606,null,123143.034,null,308030.785,null,12218.032]
["Louisiana",6040368.476,null,3506624.267,5,2190037.609,5,260297.03,5,313161.592,5,145060.065,5,325955.016,5,635210.617,5,338660.568,5,171692.721,5,343604.551,null,102.049]
["Maine",2258764.007,null,1476962.018,5,708212.769,5,89733.984,5,84861.33,5,45140.155,5,119222.693,5,232016.021,null,100192.251,null,37046.335,null,73589.22,null,0]
[]
["Maryland",10198083.671,null,6258240.014,5,3490319.464,5,427815.077,5,550493.842,5,76161.523,null,672028.083,5,960469.955,null,515059.685,null,288291.299,5,281726.857,null,167797.336]
["Massachusetts",12453610.975,null,8029461.966,5,4050678.402,5,698997.654,5,587974.077,5,226247.72,null,528582.997,null,1135609.413,null,531815.021,null,341451.52,null,373470.607,null,0]
["Michigan",17013258.869,null,9654939.384,null,6828410.687,null,1264115.977,null,840233.699,null,351001.286,null,1005596.496,null,1821303.712,null,737960.532,null,808198.985,null,529908.798,null,0]
["Minnesota",8060410.478,null,5204263.644,5,2491713.171,5,218943.814,5,370136.005,5,253087.433,5,341880.481,5,621939.782,5,445371.035,5,240354.621,5,339449.47,null,24984.193]
["Mississippi",3692358.49,null,2170683.239,5,1303265.394,5,169540.915,5,176462.946,5,106759.74,5,210155.313,5,395792.931,5,166108.896,5,78444.653,5,218063.012,null,346.845]
[]
["Missouri",7957704.658,null,4810937.749,null,2790190.06,null,380342.35,null,364015.417,null,249544.364,null,439403.25,null,793260.24,null,402797.071,null,160827.368,null,356576.849,null,0]
["Montana",1320112.159,null,799471.443,null,466006.083,null,73699.934,null,50515.641,null,39455.261,null,72094.378,null,137672.499,null,61070.192,null,31498.178,null,52709.395,null,1925.238]
["Nebraska",2825607.566,null,1796901.836,null,838065.819,null,121838.127,null,92147.288,null,97859.625,null,143788.536,null,247601.952,null,70084.489,null,64745.802,null,110938.69,null,79701.221]
["Nevada",3311470.962,null,2007844.589,null,1189274.087,null,120116.722,null,97209.439,null,63759.02,null,221817.033,null,336714.705,null,126549.01,null,223108.158,null,114352.286,null,0]
["New Hampshire",2246691.697,null,1447805.729,null,733979.614,null,153968.914,null,69586.99,null,75799.62,null,122699.125,null,195303.257,null,95517.206,null,21104.502,null,64906.354,null,0]
[]
["New Jersey",22448261.925,null,13348606.144,5,8412743.366,5,2053895.138,5,739435.929,5,529341.73,5,1505887.296,5,2269591.421,5,1210610.605,5,103981.247,5,501335.027,null,185577.388]
["New Mexico",2904473.637,null,1644674.331,null,1137815.429,null,283957.16,null,90002.85,null,66446.978,null,215910.788,null,300456.884,null,105601.004,null,75439.765,null,120529.466,null,1454.411]
["New York",43679907.987,null,30174472.499,5,12541874.601,5,1405183.93,5,1217594.301,5,847173.537,5,1774186.86,5,3795200.979,5,2325859.437,5,1176675.557,5,963560.887,null,0]
["North Carolina",11248336.069,null,6978064.822,null,3669577.002,null,633899.354,null,457863.074,null,202862.52,null,739365.083,null,898025.899,null,439950.34,null,297610.732,null,600694.245,null,0]
["North Dakota",838221.129,null,485804.883,null,281662.045,null,35789.632,null,27308.496,null,39558.995,null,41384.335,null,80691.086,null,36798.403,null,20131.098,null,44499.784,null,26254.417]
[]
["Ohio",18251360.694,null,10469978.103,null,7180598.38,null,1094606.12,null,1158781.276,null,535318.391,null,1058825.159,null,1690144.738,null,842722.272,null,800200.424,null,599288.548,null,1495.663]
["Oklahoma",4750535.868,null,2754019.648,null,1683419.255,null,305355.295,null,177921.686,null,133380.506,null,254496.385,null,533008.298,null,149162.751,null,130094.334,null,268530.383,null,44566.582]
["Oregon",5039632.424,null,2955718.217,null,1904408.678,null,352399.175,null,208073.045,null,70180.366,null,320777.705,null,423680.817,null,219730.348,null,309567.222,null,177492.235,null,2013.294]
["Pennsylvania",20404303.575,null,12476671.837,null,7138482.249,null,1000132.623,null,785629.756,null,628454.866,null,892492.348,null,2126329.865,null,991896.085,null,713546.706,null,696475.011,null,92674.478]
["Rhode Island",2039632.928,null,1228525.305,5,758763.166,5,236532.412,5,95162.46,5,25392.523,5,103123.321,5,173748.024,5,76609.824,5,48194.602,5,52344.457,5,0]
["See notes at end of table."]
["National Center for Education Statistics"]
["Table 2.—Current expenditures for public elementary and secondary education, by function, subfunction, and state or jurisdiction: Fiscal year 2007—Continued"]
[null,"Current expenditures1 [in thousands of dollars]"]
[null,"Total",null,null,null,"Support services2"]
["State or jurisdiction",null,null,"Instruction",null,"Total",null,"Student support services3",null,"Instructional\nstaff\nsupport",null,"General \nadministration",null,"School \nadministration",null,"Operation \nand maintenance",null,"Student \ntransportation",null,"Other \nsupport \nservices",null,"Food\n services",null,"Enterprise operations"]
["South Carolina",6023043.312,null,3472986.819,null,2227381.576,null,426341.337,null,412178.8,null,80349.473,null,344810.298,null,562750.381,null,216846.454,null,184104.833,null,303125.171,null,19549.746]
["South Dakota",977006.121,null,567277.103,null,354660.313,null,53780.024,null,41802.399,null,34996.023,null,48876.402,null,104955.12,null,34544.956,null,35705.389,null,50519.193,null,4549.512]
["Tennessee",6975098.915,5,4448730.15,5,2177242.493,null,242799.708,null,389290.681,null,142214.366,null,394436.912,null,636443.764,null,253407.668,null,118649.394,null,349126.272,null,0]
["Texas",36105783.504,null,21492697.848,5,12744570.766,5,1759203.568,5,1959752.141,5,555737.885,5,2010683.555,5,4142758.473,5,991584.251,5,1324850.893,5,1868514.89,5,0]
["Utah",2987809.567,null,1887342.996,null,922879.783,null,111388.807,null,133296.945,null,37487.069,null,184974.121,null,291652.642,null,98646.55,null,65433.649,null,160674.516,null,16912.272]
[]
["Vermont",1300148.938,null,822122.326,null,443623.901,null,95756.02,null,50706.055,null,30531.961,null,88161.778,null,106617.915,null,42028.169,null,29822.003,null,33918.844,null,483.867]
["Virginia",12465858.3,null,7631015.864,null,4338035.708,null,597727.031,null,822763.557,null,179060.027,null,730020.485,null,1194197.571,null,617847.039,null,196419.998,null,494762.886,null,2043.842]
["Washington",8752007.481,5,5196113.775,5,3137088.155,null,569081.385,null,399391.854,null,169590.117,null,513166.316,null,810732.611,null,357227.046,null,317898.826,null,295883.46,null,122922.091]
["West Virginia",2742343.949,null,1628022.133,5,960129.036,5,98081.147,5,110776.147,5,69944.255,5,145928.164,5,291827.74,5,198240.205,5,45331.378,5,154192.78,5,0]
["Wisconsin",9029660.485,null,5528117.103,null,3191924.57,null,415956.465,null,437152.951,null,232350.142,null,458809.489,null,858993.363,null,339342.13,null,449320.03,null,309527.218,null,91.594]
["Wyoming",1124563.87,null,662375.783,null,428614.821,null,65889.828,null,75039.139,null,22694.16,null,62092.482,null,111454.316,null,49982.486,null,41462.41,null,32869.066,null,704.2]
[]
["Other jurisdictions"]
["American Samoa                ",57093.12,null,28615.114,null,15551.681,null,1518.887,null,3321.271,null,981.094,null,6198.144,null,1482.807,null,1046.512,null,1002.966,null,12926.325,null,0]
["Guam                          ",219881.335,null,128234.343,5,80129.465,null,24316.744,null,6702.245,null,4051.369,null,11678.372,null,26575.222,null,1244.693,null,5560.82,null,10723.115,null,794.412]
["Commonwealth of the"]
["   Northern Mariana Islands",55047.521,null,43179.953,5,5590.394,5,842.987,5,562.007,5,1530.233,5,98.074,5,1337.148,5,1086.092,5,133.853,5,546.745,null,5730.429]
["Puerto Rico                   ",3268199.947,null,2220788.872,null,767147.163,null,252423.761,null,54345.184,null,15999.366,null,0,null,314214.669,null,86055.298,null,44108.885,null,280263.912,null,0]
["U.S. Virgin Islands                ",157446.14,null,95815.983,null,56908.364,5,10022.338,null,5006.291,null,7348.081,null,9303.925,null,10405.308,null,11438.649,5,3383.772,null,3965.354,null,756.439]
["1Include instruction, instruction-related, support services, and other elementary/secondary current expenditures, but exclude expenditures on capital outlay, other programs, and interest on long-term debt."]
["2An expenditure function divided into seven subfunctions: student support services, instructional staff support, general administration, school administration, operations and maintenance, student transportation, and other "]
["support services."]
["3Include attendance and social work, guidance, health, psychological services, speech pathology, audiology, and other student support services."]
["4U.S. totals include the 50 states and the District of Columbia."]
["5Value affected by redistribution of reported values to correct for missing data items, and/or to distribute state direct support expenditures."]
["6Both the District of Columbia and Hawaii have only one school district each; therefore, neither is comparable to other states."]
["NOTE: Detail may not sum to totals because of rounding. "]
["SOURCE: U.S. Department of Education, National Center for Education Statistics, Common Core of Data (CCD), \"National Public Education Financial Survey (NPEFS),\" fiscal year 2007, Version 1a."]