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
- California 892
- Georgia 743
- Texas 610
- Florida 585
- New York 572
- Washington 515
- North Carolina 436
- Indiana 432
- Mississippi 432
- Virginia 423
- Ohio 413
- Colorado 408
- Tennessee 405
- Pennsylvania 391
- Louisiana 389
- Illinois 369
- Michigan 369
- Wisconsin 342
- South Carolina 331
- Minnesota 321
- New Jersey 301
- Kentucky 280
- Oregon 266
- Arkansas 249
- Iowa 244
- Massachusetts 244
- Missouri 239
- Maryland 223
- Alabama 217
- Oklahoma 194
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
12487 | 12487 | 2020-03-26 | Imperial | California | 6025 | 17 | 0 |
12488 | 12488 | 2020-03-26 | Inyo | California | 6027 | 2 | 0 |
12489 | 12489 | 2020-03-26 | Kern | California | 6029 | 33 | 0 |
12490 | 12490 | 2020-03-26 | Los Angeles | California | 6037 | 1216 | 21 |
12491 | 12491 | 2020-03-26 | Madera | California | 6039 | 7 | 0 |
12492 | 12492 | 2020-03-26 | Marin | California | 6041 | 65 | 0 |
12493 | 12493 | 2020-03-26 | Mendocino | California | 6045 | 2 | 0 |
12494 | 12494 | 2020-03-26 | Merced | California | 6047 | 4 | 0 |
12495 | 12495 | 2020-03-26 | Mono | California | 6051 | 6 | 0 |
12496 | 12496 | 2020-03-26 | Monterey | California | 6053 | 24 | 1 |
12497 | 12497 | 2020-03-26 | Napa | California | 6055 | 7 | 0 |
12498 | 12498 | 2020-03-26 | Nevada | California | 6057 | 8 | 0 |
12499 | 12499 | 2020-03-26 | Orange | California | 6059 | 256 | 1 |
12500 | 12500 | 2020-03-26 | Placer | California | 6061 | 30 | 1 |
12501 | 12501 | 2020-03-26 | Riverside | California | 6065 | 107 | 8 |
12502 | 12502 | 2020-03-26 | Sacramento | California | 6067 | 112 | 5 |
12503 | 12503 | 2020-03-26 | San Benito | California | 6069 | 9 | 1 |
12504 | 12504 | 2020-03-26 | San Bernardino | California | 6071 | 55 | 3 |
12505 | 12505 | 2020-03-26 | San Diego | California | 6073 | 341 | 3 |
12506 | 12506 | 2020-03-26 | San Francisco | California | 6075 | 226 | 2 |
12507 | 12507 | 2020-03-26 | San Joaquin | California | 6077 | 83 | 3 |
12508 | 12508 | 2020-03-26 | San Luis Obispo | California | 6079 | 54 | 0 |
12509 | 12509 | 2020-03-26 | San Mateo | California | 6081 | 195 | 5 |
12510 | 12510 | 2020-03-26 | Santa Barbara | California | 6083 | 32 | 0 |
12511 | 12511 | 2020-03-26 | Santa Clara | California | 6085 | 542 | 20 |
12512 | 12512 | 2020-03-26 | Santa Cruz | California | 6087 | 32 | 0 |
12513 | 12513 | 2020-03-26 | Shasta | California | 6089 | 3 | 1 |
12514 | 12514 | 2020-03-26 | Siskiyou | California | 6093 | 3 | 0 |
12515 | 12515 | 2020-03-26 | Solano | California | 6095 | 39 | 0 |
12516 | 12516 | 2020-03-26 | Sonoma | California | 6097 | 49 | 1 |
12517 | 12517 | 2020-03-26 | Stanislaus | California | 6099 | 17 | 0 |
12518 | 12518 | 2020-03-26 | Sutter | California | 6101 | 2 | 0 |
12519 | 12519 | 2020-03-26 | Tulare | California | 6107 | 20 | 0 |
12520 | 12520 | 2020-03-26 | Ventura | California | 6111 | 61 | 1 |
12521 | 12521 | 2020-03-26 | Yolo | California | 6113 | 11 | 1 |
12522 | 12522 | 2020-03-26 | Yuba | California | 6115 | 3 | 0 |
12523 | 12523 | 2020-03-26 | Adams | Colorado | 8001 | 50 | 0 |
12524 | 12524 | 2020-03-26 | Arapahoe | Colorado | 8005 | 119 | 1 |
12525 | 12525 | 2020-03-26 | Boulder | Colorado | 8013 | 66 | 0 |
12526 | 12526 | 2020-03-26 | Broomfield | Colorado | 8014 | 10 | 0 |
12527 | 12527 | 2020-03-26 | Chaffee | Colorado | 8015 | 5 | 1 |
12528 | 12528 | 2020-03-26 | Clear Creek | Colorado | 8019 | 3 | 0 |
12529 | 12529 | 2020-03-26 | Crowley | Colorado | 8025 | 1 | 1 |
12530 | 12530 | 2020-03-26 | Delta | Colorado | 8029 | 1 | 0 |
12531 | 12531 | 2020-03-26 | Denver | Colorado | 8031 | 262 | 3 |
12532 | 12532 | 2020-03-26 | Douglas | Colorado | 8035 | 67 | 0 |
12533 | 12533 | 2020-03-26 | Eagle | Colorado | 8037 | 147 | 1 |
12534 | 12534 | 2020-03-26 | El Paso | Colorado | 8041 | 137 | 7 |
12535 | 12535 | 2020-03-26 | Elbert | Colorado | 8039 | 3 | 0 |
12536 | 12536 | 2020-03-26 | Fremont | Colorado | 8043 | 1 | 0 |
12537 | 12537 | 2020-03-26 | Garfield | Colorado | 8045 | 16 | 0 |
12538 | 12538 | 2020-03-26 | Grand | Colorado | 8049 | 2 | 0 |
12539 | 12539 | 2020-03-26 | Gunnison | Colorado | 8051 | 57 | 1 |
12540 | 12540 | 2020-03-26 | Hinsdale | Colorado | 8053 | 1 | 0 |
12541 | 12541 | 2020-03-26 | Huerfano | Colorado | 8055 | 1 | 0 |
12542 | 12542 | 2020-03-26 | Jefferson | Colorado | 8059 | 131 | 3 |
12543 | 12543 | 2020-03-26 | Kit Carson | Colorado | 8063 | 1 | 0 |
12544 | 12544 | 2020-03-26 | La Plata | Colorado | 8067 | 5 | 0 |
12545 | 12545 | 2020-03-26 | Larimer | Colorado | 8069 | 61 | 1 |
12546 | 12546 | 2020-03-26 | Logan | Colorado | 8075 | 2 | 0 |
12547 | 12547 | 2020-03-26 | Mesa | Colorado | 8077 | 6 | 0 |
12548 | 12548 | 2020-03-26 | Montrose | Colorado | 8085 | 4 | 0 |
12549 | 12549 | 2020-03-26 | Morgan | Colorado | 8087 | 3 | 0 |
12550 | 12550 | 2020-03-26 | Otero | Colorado | 8089 | 1 | 0 |
12551 | 12551 | 2020-03-26 | Park | Colorado | 8093 | 1 | 0 |
12552 | 12552 | 2020-03-26 | Pitkin | Colorado | 8097 | 23 | 0 |
12553 | 12553 | 2020-03-26 | Pueblo | Colorado | 8101 | 5 | 0 |
12554 | 12554 | 2020-03-26 | Rio Grande | Colorado | 8105 | 2 | 0 |
12555 | 12555 | 2020-03-26 | Routt | Colorado | 8107 | 9 | 0 |
12556 | 12556 | 2020-03-26 | San Miguel | Colorado | 8113 | 1 | 0 |
12557 | 12557 | 2020-03-26 | Summit | Colorado | 8117 | 9 | 0 |
12558 | 12558 | 2020-03-26 | Teller | Colorado | 8119 | 7 | 1 |
12559 | 12559 | 2020-03-26 | Unknown | Colorado | 102 | 0 | |
12560 | 12560 | 2020-03-26 | Washington | Colorado | 8121 | 1 | 0 |
12561 | 12561 | 2020-03-26 | Weld | Colorado | 8123 | 107 | 4 |
12562 | 12562 | 2020-03-26 | Yuma | Colorado | 8125 | 2 | 0 |
12563 | 12563 | 2020-03-26 | Fairfield | Connecticut | 9001 | 607 | 13 |
12564 | 12564 | 2020-03-26 | Hartford | Connecticut | 9003 | 138 | 2 |
12565 | 12565 | 2020-03-26 | Litchfield | Connecticut | 9005 | 44 | 0 |
12566 | 12566 | 2020-03-26 | Middlesex | Connecticut | 9007 | 18 | 1 |
12567 | 12567 | 2020-03-26 | New Haven | Connecticut | 9009 | 156 | 2 |
12568 | 12568 | 2020-03-26 | New London | Connecticut | 9011 | 13 | 0 |
12569 | 12569 | 2020-03-26 | Tolland | Connecticut | 9013 | 33 | 3 |
12570 | 12570 | 2020-03-26 | Windham | Connecticut | 9015 | 3 | 0 |
12571 | 12571 | 2020-03-26 | Kent | Delaware | 10001 | 19 | 0 |
12572 | 12572 | 2020-03-26 | New Castle | Delaware | 10003 | 91 | 0 |
12573 | 12573 | 2020-03-26 | Sussex | Delaware | 10005 | 33 | 1 |
12574 | 12574 | 2020-03-26 | District of Columbia | District of Columbia | 11001 | 231 | 3 |
12575 | 12575 | 2020-03-26 | Alachua | Florida | 12001 | 53 | 0 |
12576 | 12576 | 2020-03-26 | Baker | Florida | 12003 | 5 | 0 |
12577 | 12577 | 2020-03-26 | Bay | Florida | 12005 | 3 | 0 |
12578 | 12578 | 2020-03-26 | Bradford | Florida | 12007 | 1 | 0 |
12579 | 12579 | 2020-03-26 | Brevard | Florida | 12009 | 14 | 0 |
12580 | 12580 | 2020-03-26 | Broward | Florida | 12011 | 505 | 3 |
12581 | 12581 | 2020-03-26 | Charlotte | Florida | 12015 | 4 | 0 |
12582 | 12582 | 2020-03-26 | Citrus | Florida | 12017 | 11 | 1 |
12583 | 12583 | 2020-03-26 | Clay | Florida | 12019 | 20 | 4 |
12584 | 12584 | 2020-03-26 | Collier | Florida | 12021 | 67 | 0 |
12585 | 12585 | 2020-03-26 | Columbia | Florida | 12023 | 3 | 0 |
12586 | 12586 | 2020-03-26 | DeSoto | Florida | 12027 | 5 | 0 |
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);