ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,355 rows where date = "2020-03-24" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state >30
- Georgia 87
- Mississippi 58
- Texas 55
- Indiana 52
- New York 51
- Ohio 49
- Tennessee 49
- North Carolina 47
- Florida 46
- Louisiana 44
- Virginia 43
- California 42
- Michigan 42
- Pennsylvania 40
- Arkansas 38
- Colorado 36
- South Carolina 36
- Illinois 33
- Kentucky 32
- Minnesota 32
- Missouri 32
- Washington 32
- Iowa 30
- Wisconsin 30
- Alabama 26
- New Jersey 22
- Maryland 21
- Kansas 20
- Oklahoma 19
- Oregon 19
- …
fips >30
county >30
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9481 | 9481 | 2020-03-24 | Autauga | Alabama | 1001 | 1 | 0 |
9482 | 9482 | 2020-03-24 | Baldwin | Alabama | 1003 | 4 | 0 |
9483 | 9483 | 2020-03-24 | Calhoun | Alabama | 1015 | 2 | 0 |
9484 | 9484 | 2020-03-24 | Chambers | Alabama | 1017 | 5 | 0 |
9485 | 9485 | 2020-03-24 | Cullman | Alabama | 1043 | 3 | 0 |
9486 | 9486 | 2020-03-24 | Elmore | Alabama | 1051 | 8 | 0 |
9487 | 9487 | 2020-03-24 | Franklin | Alabama | 1059 | 1 | 0 |
9488 | 9488 | 2020-03-24 | Houston | Alabama | 1069 | 1 | 0 |
9489 | 9489 | 2020-03-24 | Jackson | Alabama | 1071 | 2 | 0 |
9490 | 9490 | 2020-03-24 | Jefferson | Alabama | 1073 | 91 | 0 |
9491 | 9491 | 2020-03-24 | Lamar | Alabama | 1075 | 1 | 0 |
9492 | 9492 | 2020-03-24 | Lauderdale | Alabama | 1077 | 3 | 0 |
9493 | 9493 | 2020-03-24 | Lee | Alabama | 1081 | 26 | 0 |
9494 | 9494 | 2020-03-24 | Limestone | Alabama | 1083 | 4 | 0 |
9495 | 9495 | 2020-03-24 | Madison | Alabama | 1089 | 21 | 0 |
9496 | 9496 | 2020-03-24 | Marion | Alabama | 1093 | 1 | 0 |
9497 | 9497 | 2020-03-24 | Mobile | Alabama | 1097 | 6 | 0 |
9498 | 9498 | 2020-03-24 | Montgomery | Alabama | 1101 | 9 | 0 |
9499 | 9499 | 2020-03-24 | Morgan | Alabama | 1103 | 2 | 0 |
9500 | 9500 | 2020-03-24 | Shelby | Alabama | 1117 | 27 | 0 |
9501 | 9501 | 2020-03-24 | St. Clair | Alabama | 1115 | 4 | 0 |
9502 | 9502 | 2020-03-24 | Talladega | Alabama | 1121 | 2 | 0 |
9503 | 9503 | 2020-03-24 | Tallapoosa | Alabama | 1123 | 2 | 0 |
9504 | 9504 | 2020-03-24 | Tuscaloosa | Alabama | 1125 | 10 | 0 |
9505 | 9505 | 2020-03-24 | Walker | Alabama | 1127 | 5 | 0 |
9506 | 9506 | 2020-03-24 | Washington | Alabama | 1129 | 1 | 0 |
9507 | 9507 | 2020-03-24 | Anchorage | Alaska | 2020 | 17 | 0 |
9508 | 9508 | 2020-03-24 | Fairbanks North Star Borough | Alaska | 2090 | 9 | 0 |
9509 | 9509 | 2020-03-24 | Juneau City and Borough | Alaska | 2110 | 2 | 0 |
9510 | 9510 | 2020-03-24 | Kenai Peninsula Borough | Alaska | 2122 | 4 | 0 |
9511 | 9511 | 2020-03-24 | Ketchikan Gateway Borough | Alaska | 2130 | 8 | 0 |
9512 | 9512 | 2020-03-24 | Matanuska-Susitna Borough | Alaska | 2170 | 2 | 0 |
9513 | 9513 | 2020-03-24 | Apache | Arizona | 4001 | 4 | 0 |
9514 | 9514 | 2020-03-24 | Cochise | Arizona | 4003 | 1 | 0 |
9515 | 9515 | 2020-03-24 | Coconino | Arizona | 4005 | 18 | 1 |
9516 | 9516 | 2020-03-24 | Graham | Arizona | 4009 | 2 | 0 |
9517 | 9517 | 2020-03-24 | Maricopa | Arizona | 4013 | 199 | 2 |
9518 | 9518 | 2020-03-24 | Navajo | Arizona | 4017 | 32 | 0 |
9519 | 9519 | 2020-03-24 | Pima | Arizona | 4019 | 42 | 0 |
9520 | 9520 | 2020-03-24 | Pinal | Arizona | 4021 | 22 | 0 |
9521 | 9521 | 2020-03-24 | Santa Cruz | Arizona | 4023 | 1 | 0 |
9522 | 9522 | 2020-03-24 | Unknown | Arizona | 0 | 3 | |
9523 | 9523 | 2020-03-24 | Yavapai | Arizona | 4025 | 3 | 0 |
9524 | 9524 | 2020-03-24 | Yuma | Arizona | 4027 | 2 | 0 |
9525 | 9525 | 2020-03-24 | Benton | Arkansas | 5007 | 3 | 0 |
9526 | 9526 | 2020-03-24 | Boone | Arkansas | 5009 | 1 | 0 |
9527 | 9527 | 2020-03-24 | Bradley | Arkansas | 5011 | 4 | 0 |
9528 | 9528 | 2020-03-24 | Clark | Arkansas | 5019 | 6 | 0 |
9529 | 9529 | 2020-03-24 | Cleburne | Arkansas | 5023 | 34 | 1 |
9530 | 9530 | 2020-03-24 | Cleveland | Arkansas | 5025 | 3 | 0 |
9531 | 9531 | 2020-03-24 | Columbia | Arkansas | 5027 | 1 | 0 |
9532 | 9532 | 2020-03-24 | Conway | Arkansas | 5029 | 1 | 0 |
9533 | 9533 | 2020-03-24 | Craighead | Arkansas | 5031 | 4 | 0 |
9534 | 9534 | 2020-03-24 | Crawford | Arkansas | 5033 | 1 | 0 |
9535 | 9535 | 2020-03-24 | Crittenden | Arkansas | 5035 | 3 | 0 |
9536 | 9536 | 2020-03-24 | Cross | Arkansas | 5037 | 1 | 0 |
9537 | 9537 | 2020-03-24 | Desha | Arkansas | 5041 | 2 | 0 |
9538 | 9538 | 2020-03-24 | Faulkner | Arkansas | 5045 | 17 | 0 |
9539 | 9539 | 2020-03-24 | Garland | Arkansas | 5051 | 11 | 0 |
9540 | 9540 | 2020-03-24 | Grant | Arkansas | 5053 | 3 | 0 |
9541 | 9541 | 2020-03-24 | Greene | Arkansas | 5055 | 3 | 0 |
9542 | 9542 | 2020-03-24 | Hot Spring | Arkansas | 5059 | 1 | 0 |
9543 | 9543 | 2020-03-24 | Independence | Arkansas | 5063 | 3 | 0 |
9544 | 9544 | 2020-03-24 | Jefferson | Arkansas | 5069 | 22 | 0 |
9545 | 9545 | 2020-03-24 | Lawrence | Arkansas | 5075 | 1 | 0 |
9546 | 9546 | 2020-03-24 | Lincoln | Arkansas | 5079 | 3 | 0 |
9547 | 9547 | 2020-03-24 | Pike | Arkansas | 5109 | 1 | 0 |
9548 | 9548 | 2020-03-24 | Poinsett | Arkansas | 5111 | 3 | 0 |
9549 | 9549 | 2020-03-24 | Polk | Arkansas | 5113 | 2 | 0 |
9550 | 9550 | 2020-03-24 | Pope | Arkansas | 5115 | 2 | 0 |
9551 | 9551 | 2020-03-24 | Pulaski | Arkansas | 5119 | 64 | 1 |
9552 | 9552 | 2020-03-24 | Saline | Arkansas | 5125 | 4 | 0 |
9553 | 9553 | 2020-03-24 | Searcy | Arkansas | 5129 | 2 | 0 |
9554 | 9554 | 2020-03-24 | Sebastian | Arkansas | 5131 | 1 | 0 |
9555 | 9555 | 2020-03-24 | Sevier | Arkansas | 5133 | 1 | 0 |
9556 | 9556 | 2020-03-24 | Stone | Arkansas | 5137 | 2 | 0 |
9557 | 9557 | 2020-03-24 | Union | Arkansas | 5139 | 1 | 0 |
9558 | 9558 | 2020-03-24 | Unknown | Arkansas | 2 | 0 | |
9559 | 9559 | 2020-03-24 | Van Buren | Arkansas | 5141 | 7 | 0 |
9560 | 9560 | 2020-03-24 | Washington | Arkansas | 5143 | 6 | 0 |
9561 | 9561 | 2020-03-24 | White | Arkansas | 5145 | 4 | 0 |
9562 | 9562 | 2020-03-24 | Woodruff | Arkansas | 5147 | 1 | 0 |
9563 | 9563 | 2020-03-24 | Alameda | California | 6001 | 151 | 2 |
9564 | 9564 | 2020-03-24 | Amador | California | 6005 | 1 | 0 |
9565 | 9565 | 2020-03-24 | Butte | California | 6007 | 4 | 0 |
9566 | 9566 | 2020-03-24 | Calaveras | California | 6009 | 2 | 0 |
9567 | 9567 | 2020-03-24 | Contra Costa | California | 6013 | 86 | 1 |
9568 | 9568 | 2020-03-24 | El Dorado | California | 6017 | 3 | 0 |
9569 | 9569 | 2020-03-24 | Fresno | California | 6019 | 18 | 0 |
9570 | 9570 | 2020-03-24 | Humboldt | California | 6023 | 5 | 0 |
9571 | 9571 | 2020-03-24 | Imperial | California | 6025 | 9 | 0 |
9572 | 9572 | 2020-03-24 | Kern | California | 6029 | 14 | 0 |
9573 | 9573 | 2020-03-24 | Los Angeles | California | 6037 | 662 | 11 |
9574 | 9574 | 2020-03-24 | Madera | California | 6039 | 6 | 0 |
9575 | 9575 | 2020-03-24 | Marin | California | 6041 | 53 | 0 |
9576 | 9576 | 2020-03-24 | Mendocino | California | 6045 | 2 | 0 |
9577 | 9577 | 2020-03-24 | Merced | California | 6047 | 1 | 0 |
9578 | 9578 | 2020-03-24 | Mono | California | 6051 | 2 | 0 |
9579 | 9579 | 2020-03-24 | Monterey | California | 6053 | 20 | 1 |
9580 | 9580 | 2020-03-24 | Napa | California | 6055 | 3 | 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);