ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 31,136
- Georgia 22,489
- Virginia 18,000
- Kentucky 15,772
- Missouri 14,719
- North Carolina 13,808
- Illinois 13,666
- Tennessee 13,299
- Iowa 13,071
- Indiana 13,006
- Ohio 12,346
- Kansas 11,888
- Mississippi 11,609
- Minnesota 11,563
- Michigan 11,442
- Arkansas 10,355
- Oklahoma 10,007
- Florida 9,842
- Wisconsin 9,841
- Pennsylvania 9,561
- Nebraska 9,467
- Alabama 9,365
- Louisiana 9,303
- Colorado 8,610
- New York 8,572
- California 8,565
- Puerto Rico 7,837
- South Dakota 7,311
- West Virginia 7,036
- South Carolina 6,650
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
421487 | 421487 | 2020-08-11 | Lawrence | Arkansas | 5075 | 217 | 9 |
421488 | 421488 | 2020-08-11 | Lee | Arkansas | 5077 | 896 | 8 |
421489 | 421489 | 2020-08-11 | Lincoln | Arkansas | 5079 | 1224 | 12 |
421490 | 421490 | 2020-08-11 | Little River | Arkansas | 5081 | 185 | 1 |
421491 | 421491 | 2020-08-11 | Logan | Arkansas | 5083 | 277 | 1 |
421492 | 421492 | 2020-08-11 | Lonoke | Arkansas | 5085 | 531 | 2 |
421493 | 421493 | 2020-08-11 | Madison | Arkansas | 5087 | 270 | 2 |
421494 | 421494 | 2020-08-11 | Marion | Arkansas | 5089 | 29 | 0 |
421495 | 421495 | 2020-08-11 | Miller | Arkansas | 5091 | 518 | 5 |
421496 | 421496 | 2020-08-11 | Mississippi | Arkansas | 5093 | 1044 | 14 |
421497 | 421497 | 2020-08-11 | Monroe | Arkansas | 5095 | 64 | 0 |
421498 | 421498 | 2020-08-11 | Montgomery | Arkansas | 5097 | 38 | 1 |
421499 | 421499 | 2020-08-11 | Nevada | Arkansas | 5099 | 143 | 9 |
421500 | 421500 | 2020-08-11 | Newton | Arkansas | 5101 | 106 | 10 |
421501 | 421501 | 2020-08-11 | Ouachita | Arkansas | 5103 | 105 | 2 |
421502 | 421502 | 2020-08-11 | Perry | Arkansas | 5105 | 55 | 0 |
421503 | 421503 | 2020-08-11 | Phillips | Arkansas | 5107 | 329 | 9 |
421504 | 421504 | 2020-08-11 | Pike | Arkansas | 5109 | 111 | 1 |
421505 | 421505 | 2020-08-11 | Poinsett | Arkansas | 5111 | 292 | 3 |
421506 | 421506 | 2020-08-11 | Polk | Arkansas | 5113 | 150 | 1 |
421507 | 421507 | 2020-08-11 | Pope | Arkansas | 5115 | 1333 | 10 |
421508 | 421508 | 2020-08-11 | Prairie | Arkansas | 5117 | 100 | 0 |
421509 | 421509 | 2020-08-11 | Pulaski | Arkansas | 5119 | 5706 | 86 |
421510 | 421510 | 2020-08-11 | Randolph | Arkansas | 5121 | 222 | 4 |
421511 | 421511 | 2020-08-11 | Saline | Arkansas | 5125 | 1113 | 7 |
421512 | 421512 | 2020-08-11 | Scott | Arkansas | 5127 | 66 | 0 |
421513 | 421513 | 2020-08-11 | Searcy | Arkansas | 5129 | 33 | 0 |
421514 | 421514 | 2020-08-11 | Sebastian | Arkansas | 5131 | 2250 | 20 |
421515 | 421515 | 2020-08-11 | Sevier | Arkansas | 5133 | 996 | 10 |
421516 | 421516 | 2020-08-11 | Sharp | Arkansas | 5135 | 114 | 5 |
421517 | 421517 | 2020-08-11 | St. Francis | Arkansas | 5123 | 1226 | 3 |
421518 | 421518 | 2020-08-11 | Stone | Arkansas | 5137 | 69 | 1 |
421519 | 421519 | 2020-08-11 | Union | Arkansas | 5139 | 508 | 18 |
421520 | 421520 | 2020-08-11 | Unknown | Arkansas | 1811 | 0 | |
421521 | 421521 | 2020-08-11 | Van Buren | Arkansas | 5141 | 53 | 2 |
421522 | 421522 | 2020-08-11 | Washington | Arkansas | 5143 | 6321 | 52 |
421523 | 421523 | 2020-08-11 | White | Arkansas | 5145 | 328 | 2 |
421524 | 421524 | 2020-08-11 | Woodruff | Arkansas | 5147 | 22 | 0 |
421525 | 421525 | 2020-08-11 | Yell | Arkansas | 5149 | 1069 | 17 |
421526 | 421526 | 2020-08-11 | Alameda | California | 6001 | 13685 | 205 |
421527 | 421527 | 2020-08-11 | Alpine | California | 6003 | 2 | 0 |
421528 | 421528 | 2020-08-11 | Amador | California | 6005 | 193 | 10 |
421529 | 421529 | 2020-08-11 | Butte | California | 6007 | 1280 | 8 |
421530 | 421530 | 2020-08-11 | Calaveras | California | 6009 | 161 | 1 |
421531 | 421531 | 2020-08-11 | Colusa | California | 6011 | 396 | 5 |
421532 | 421532 | 2020-08-11 | Contra Costa | California | 6013 | 9787 | 146 |
421533 | 421533 | 2020-08-11 | Del Norte | California | 6015 | 104 | 0 |
421534 | 421534 | 2020-08-11 | El Dorado | California | 6017 | 785 | 2 |
421535 | 421535 | 2020-08-11 | Fresno | California | 6019 | 17978 | 191 |
421536 | 421536 | 2020-08-11 | Glenn | California | 6021 | 381 | 3 |
421537 | 421537 | 2020-08-11 | Humboldt | California | 6023 | 293 | 4 |
421538 | 421538 | 2020-08-11 | Imperial | California | 6025 | 9867 | 243 |
421539 | 421539 | 2020-08-11 | Inyo | California | 6027 | 97 | 3 |
421540 | 421540 | 2020-08-11 | Kern | California | 6029 | 24995 | 183 |
421541 | 421541 | 2020-08-11 | Kings | California | 6031 | 5067 | 62 |
421542 | 421542 | 2020-08-11 | Lake | California | 6033 | 239 | 2 |
421543 | 421543 | 2020-08-11 | Lassen | California | 6035 | 683 | 0 |
421544 | 421544 | 2020-08-11 | Los Angeles | California | 6037 | 211808 | 5057 |
421545 | 421545 | 2020-08-11 | Madera | California | 6039 | 2463 | 39 |
421546 | 421546 | 2020-08-11 | Marin | California | 6041 | 5471 | 81 |
421547 | 421547 | 2020-08-11 | Mariposa | California | 6043 | 63 | 2 |
421548 | 421548 | 2020-08-11 | Mendocino | California | 6045 | 478 | 10 |
421549 | 421549 | 2020-08-11 | Merced | California | 6047 | 6102 | 74 |
421550 | 421550 | 2020-08-11 | Modoc | California | 6049 | 5 | 0 |
421551 | 421551 | 2020-08-11 | Mono | California | 6051 | 158 | 1 |
421552 | 421552 | 2020-08-11 | Monterey | California | 6053 | 5494 | 37 |
421553 | 421553 | 2020-08-11 | Napa | California | 6055 | 1130 | 11 |
421554 | 421554 | 2020-08-11 | Nevada | California | 6057 | 357 | 1 |
421555 | 421555 | 2020-08-11 | Orange | California | 6059 | 41578 | 734 |
421556 | 421556 | 2020-08-11 | Placer | California | 6061 | 2377 | 24 |
421557 | 421557 | 2020-08-11 | Plumas | California | 6063 | 27 | 0 |
421558 | 421558 | 2020-08-11 | Riverside | California | 6065 | 43376 | 824 |
421559 | 421559 | 2020-08-11 | Sacramento | California | 6067 | 12273 | 179 |
421560 | 421560 | 2020-08-11 | San Benito | California | 6069 | 767 | 4 |
421561 | 421561 | 2020-08-11 | San Bernardino | California | 6071 | 37367 | 549 |
421562 | 421562 | 2020-08-11 | San Diego | California | 6073 | 33220 | 602 |
421563 | 421563 | 2020-08-11 | San Francisco | California | 6075 | 7626 | 67 |
421564 | 421564 | 2020-08-11 | San Joaquin | California | 6077 | 13870 | 235 |
421565 | 421565 | 2020-08-11 | San Luis Obispo | California | 6079 | 2278 | 17 |
421566 | 421566 | 2020-08-11 | San Mateo | California | 6081 | 6431 | 122 |
421567 | 421567 | 2020-08-11 | Santa Barbara | California | 6083 | 7074 | 73 |
421568 | 421568 | 2020-08-11 | Santa Clara | California | 6085 | 12962 | 208 |
421569 | 421569 | 2020-08-11 | Santa Cruz | California | 6087 | 1287 | 6 |
421570 | 421570 | 2020-08-11 | Shasta | California | 6089 | 469 | 10 |
421571 | 421571 | 2020-08-11 | Sierra | California | 6091 | 3 | 0 |
421572 | 421572 | 2020-08-11 | Siskiyou | California | 6093 | 106 | 0 |
421573 | 421573 | 2020-08-11 | Solano | California | 6095 | 4343 | 41 |
421574 | 421574 | 2020-08-11 | Sonoma | California | 6097 | 3825 | 51 |
421575 | 421575 | 2020-08-11 | Stanislaus | California | 6099 | 10855 | 177 |
421576 | 421576 | 2020-08-11 | Sutter | California | 6101 | 1019 | 7 |
421577 | 421577 | 2020-08-11 | Tehama | California | 6103 | 282 | 1 |
421578 | 421578 | 2020-08-11 | Trinity | California | 6105 | 6 | 0 |
421579 | 421579 | 2020-08-11 | Tulare | California | 6107 | 11549 | 198 |
421580 | 421580 | 2020-08-11 | Tuolumne | California | 6109 | 159 | 2 |
421581 | 421581 | 2020-08-11 | Ventura | California | 6111 | 8851 | 93 |
421582 | 421582 | 2020-08-11 | Yolo | California | 6113 | 1898 | 45 |
421583 | 421583 | 2020-08-11 | Yuba | California | 6115 | 678 | 4 |
421584 | 421584 | 2020-08-11 | Adams | Colorado | 8001 | 6581 | 177 |
421585 | 421585 | 2020-08-11 | Alamosa | Colorado | 8003 | 231 | 9 |
421586 | 421586 | 2020-08-11 | Arapahoe | Colorado | 8005 | 7377 | 362 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);