ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,644 rows where deaths = 188 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 134
- Texas 126
- Indiana 96
- Alabama 82
- North Carolina 78
- Illinois 76
- South Carolina 74
- Virginia 73
- Ohio 65
- Louisiana 64
- Pennsylvania 55
- Missouri 47
- Tennessee 45
- Mississippi 44
- Connecticut 38
- New Jersey 35
- Arkansas 34
- Michigan 34
- New York 34
- Nebraska 30
- Montana 26
- Washington 26
- New Mexico 25
- Oregon 25
- Wisconsin 25
- California 24
- Florida 24
- Oklahoma 24
- Arizona 20
- Idaho 18
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500070 | 2500070 | 2022-05-13 | Murray | Georgia | 13213 | 11548 | 188 |
2500141 | 2500141 | 2022-05-13 | Bonner | Idaho | 16017 | 8941 | 188 |
2500748 | 2500748 | 2022-05-13 | St. Martin | Louisiana | 22099 | 12985 | 188 |
2501718 | 2501718 | 2022-05-13 | Shelby | Ohio | 39149 | 11102 | 188 |
2501788 | 2501788 | 2022-05-13 | Okmulgee | Oklahoma | 40111 | 9686 | 188 |
2502512 | 2502512 | 2022-05-13 | Alexandria city | Virginia | 51510 | 32647 | 188 |
2496812 | 2496812 | 2022-05-12 | Murray | Georgia | 13213 | 11548 | 188 |
2496883 | 2496883 | 2022-05-12 | Bonner | Idaho | 16017 | 8934 | 188 |
2497490 | 2497490 | 2022-05-12 | St. Martin | Louisiana | 22099 | 12977 | 188 |
2498460 | 2498460 | 2022-05-12 | Shelby | Ohio | 39149 | 11102 | 188 |
2498530 | 2498530 | 2022-05-12 | Okmulgee | Oklahoma | 40111 | 9686 | 188 |
2499254 | 2499254 | 2022-05-12 | Alexandria city | Virginia | 51510 | 32528 | 188 |
2493554 | 2493554 | 2022-05-11 | Murray | Georgia | 13213 | 11548 | 188 |
2493625 | 2493625 | 2022-05-11 | Bonner | Idaho | 16017 | 8934 | 188 |
2494232 | 2494232 | 2022-05-11 | St. Martin | Louisiana | 22099 | 12976 | 188 |
2495272 | 2495272 | 2022-05-11 | Okmulgee | Oklahoma | 40111 | 9679 | 188 |
2495996 | 2495996 | 2022-05-11 | Alexandria city | Virginia | 51510 | 32395 | 188 |
2490296 | 2490296 | 2022-05-10 | Murray | Georgia | 13213 | 11534 | 188 |
2490367 | 2490367 | 2022-05-10 | Bonner | Idaho | 16017 | 8919 | 188 |
2490974 | 2490974 | 2022-05-10 | St. Martin | Louisiana | 22099 | 12970 | 188 |
2491623 | 2491623 | 2022-05-10 | Cibola | New Mexico | 35006 | 8017 | 188 |
2492014 | 2492014 | 2022-05-10 | Okmulgee | Oklahoma | 40111 | 9679 | 188 |
2492738 | 2492738 | 2022-05-10 | Alexandria city | Virginia | 51510 | 32310 | 188 |
2487039 | 2487039 | 2022-05-09 | Murray | Georgia | 13213 | 11534 | 188 |
2487110 | 2487110 | 2022-05-09 | Bonner | Idaho | 16017 | 8919 | 188 |
2487717 | 2487717 | 2022-05-09 | St. Martin | Louisiana | 22099 | 12969 | 188 |
2488365 | 2488365 | 2022-05-09 | Cibola | New Mexico | 35006 | 8014 | 188 |
2488756 | 2488756 | 2022-05-09 | Okmulgee | Oklahoma | 40111 | 9679 | 188 |
2489480 | 2489480 | 2022-05-09 | Alexandria city | Virginia | 51510 | 32237 | 188 |
2489741 | 2489741 | 2022-05-09 | Manitowoc | Wisconsin | 55071 | 20718 | 188 |
2483781 | 2483781 | 2022-05-08 | Murray | Georgia | 13213 | 11535 | 188 |
2483852 | 2483852 | 2022-05-08 | Bonner | Idaho | 16017 | 8913 | 188 |
2484459 | 2484459 | 2022-05-08 | St. Martin | Louisiana | 22099 | 12966 | 188 |
2485108 | 2485108 | 2022-05-08 | Cibola | New Mexico | 35006 | 8006 | 188 |
2485499 | 2485499 | 2022-05-08 | Okmulgee | Oklahoma | 40111 | 9679 | 188 |
2486223 | 2486223 | 2022-05-08 | Alexandria city | Virginia | 51510 | 32001 | 188 |
2486484 | 2486484 | 2022-05-08 | Manitowoc | Wisconsin | 55071 | 20677 | 188 |
2480523 | 2480523 | 2022-05-07 | Murray | Georgia | 13213 | 11535 | 188 |
2480594 | 2480594 | 2022-05-07 | Bonner | Idaho | 16017 | 8913 | 188 |
2481201 | 2481201 | 2022-05-07 | St. Martin | Louisiana | 22099 | 12966 | 188 |
2481850 | 2481850 | 2022-05-07 | Cibola | New Mexico | 35006 | 8006 | 188 |
2482241 | 2482241 | 2022-05-07 | Okmulgee | Oklahoma | 40111 | 9679 | 188 |
2482965 | 2482965 | 2022-05-07 | Alexandria city | Virginia | 51510 | 32001 | 188 |
2483226 | 2483226 | 2022-05-07 | Manitowoc | Wisconsin | 55071 | 20677 | 188 |
2477265 | 2477265 | 2022-05-06 | Murray | Georgia | 13213 | 11535 | 188 |
2477336 | 2477336 | 2022-05-06 | Bonner | Idaho | 16017 | 8913 | 188 |
2477943 | 2477943 | 2022-05-06 | St. Martin | Louisiana | 22099 | 12966 | 188 |
2478592 | 2478592 | 2022-05-06 | Cibola | New Mexico | 35006 | 8006 | 188 |
2478983 | 2478983 | 2022-05-06 | Okmulgee | Oklahoma | 40111 | 9679 | 188 |
2479707 | 2479707 | 2022-05-06 | Alexandria city | Virginia | 51510 | 32001 | 188 |
2479968 | 2479968 | 2022-05-06 | Manitowoc | Wisconsin | 55071 | 20677 | 188 |
2474007 | 2474007 | 2022-05-05 | Murray | Georgia | 13213 | 11535 | 188 |
2474078 | 2474078 | 2022-05-05 | Bonner | Idaho | 16017 | 8901 | 188 |
2474685 | 2474685 | 2022-05-05 | St. Martin | Louisiana | 22099 | 12966 | 188 |
2475334 | 2475334 | 2022-05-05 | Cibola | New Mexico | 35006 | 7996 | 188 |
2475725 | 2475725 | 2022-05-05 | Okmulgee | Oklahoma | 40111 | 9679 | 188 |
2476449 | 2476449 | 2022-05-05 | Alexandria city | Virginia | 51510 | 31922 | 188 |
2476710 | 2476710 | 2022-05-05 | Manitowoc | Wisconsin | 55071 | 20654 | 188 |
2470750 | 2470750 | 2022-05-04 | Murray | Georgia | 13213 | 11535 | 188 |
2470821 | 2470821 | 2022-05-04 | Bonner | Idaho | 16017 | 8901 | 188 |
2471428 | 2471428 | 2022-05-04 | St. Martin | Louisiana | 22099 | 12963 | 188 |
2473191 | 2473191 | 2022-05-04 | Alexandria city | Virginia | 51510 | 31840 | 188 |
2467494 | 2467494 | 2022-05-03 | Murray | Georgia | 13213 | 11533 | 188 |
2467565 | 2467565 | 2022-05-03 | Bonner | Idaho | 16017 | 8889 | 188 |
2468172 | 2468172 | 2022-05-03 | St. Martin | Louisiana | 22099 | 12961 | 188 |
2469935 | 2469935 | 2022-05-03 | Alexandria city | Virginia | 51510 | 31734 | 188 |
2464239 | 2464239 | 2022-05-02 | Murray | Georgia | 13213 | 11533 | 188 |
2464310 | 2464310 | 2022-05-02 | Bonner | Idaho | 16017 | 8889 | 188 |
2464917 | 2464917 | 2022-05-02 | St. Martin | Louisiana | 22099 | 12960 | 188 |
2466679 | 2466679 | 2022-05-02 | Alexandria city | Virginia | 51510 | 31687 | 188 |
2460983 | 2460983 | 2022-05-01 | Murray | Georgia | 13213 | 11534 | 188 |
2461054 | 2461054 | 2022-05-01 | Bonner | Idaho | 16017 | 8886 | 188 |
2463424 | 2463424 | 2022-05-01 | Alexandria city | Virginia | 51510 | 31509 | 188 |
2457727 | 2457727 | 2022-04-30 | Murray | Georgia | 13213 | 11534 | 188 |
2457798 | 2457798 | 2022-04-30 | Bonner | Idaho | 16017 | 8886 | 188 |
2460168 | 2460168 | 2022-04-30 | Alexandria city | Virginia | 51510 | 31509 | 188 |
2454471 | 2454471 | 2022-04-29 | Murray | Georgia | 13213 | 11534 | 188 |
2454542 | 2454542 | 2022-04-29 | Bonner | Idaho | 16017 | 8886 | 188 |
2456912 | 2456912 | 2022-04-29 | Alexandria city | Virginia | 51510 | 31509 | 188 |
2451215 | 2451215 | 2022-04-28 | Murray | Georgia | 13213 | 11534 | 188 |
2453656 | 2453656 | 2022-04-28 | Alexandria city | Virginia | 51510 | 31441 | 188 |
2447959 | 2447959 | 2022-04-27 | Murray | Georgia | 13213 | 11534 | 188 |
2449362 | 2449362 | 2022-04-27 | St. Lawrence | New York | 36089 | 22017 | 188 |
2446105 | 2446105 | 2022-04-26 | St. Lawrence | New York | 36089 | 21970 | 188 |
2442840 | 2442840 | 2022-04-25 | Oswego | New York | 36075 | 27903 | 188 |
2442850 | 2442850 | 2022-04-25 | St. Lawrence | New York | 36089 | 21942 | 188 |
2439584 | 2439584 | 2022-04-24 | Oswego | New York | 36075 | 27864 | 188 |
2439594 | 2439594 | 2022-04-24 | St. Lawrence | New York | 36089 | 21922 | 188 |
2436328 | 2436328 | 2022-04-23 | Oswego | New York | 36075 | 27807 | 188 |
2436338 | 2436338 | 2022-04-23 | St. Lawrence | New York | 36089 | 21890 | 188 |
2433072 | 2433072 | 2022-04-22 | Oswego | New York | 36075 | 27733 | 188 |
2429816 | 2429816 | 2022-04-21 | Oswego | New York | 36075 | 27640 | 188 |
2426560 | 2426560 | 2022-04-20 | Oswego | New York | 36075 | 27550 | 188 |
2423304 | 2423304 | 2022-04-19 | Oswego | New York | 36075 | 27447 | 188 |
2420596 | 2420596 | 2022-04-18 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2417340 | 2417340 | 2022-04-17 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2414084 | 2414084 | 2022-04-16 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2410828 | 2410828 | 2022-04-15 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
2406960 | 2406960 | 2022-04-14 | Curry | New Mexico | 35009 | 12626 | 188 |
2407572 | 2407572 | 2022-04-14 | Chesterfield | South Carolina | 45025 | 11800 | 188 |
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);