ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
341 rows where deaths = 497 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Texas 63
- Georgia 48
- New York 26
- Virginia 22
- Ohio 21
- Delaware 19
- New Mexico 19
- Pennsylvania 16
- Louisiana 13
- Illinois 12
- California 10
- Idaho 8
- Florida 7
- Maryland 7
- Alabama 6
- Arizona 6
- Michigan 6
- Indiana 5
- Minnesota 5
- Wisconsin 5
- Missouri 4
- North Carolina 3
- New Jersey 2
- Oregon 2
- South Carolina 2
- Oklahoma 1
- South Dakota 1
- Tennessee 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502534 | 2502534 | 2022-05-13 | Chesapeake city | Virginia | 51550 | 51025 | 497 |
2499276 | 2499276 | 2022-05-12 | Chesapeake city | Virginia | 51550 | 50960 | 497 |
2496018 | 2496018 | 2022-05-11 | Chesapeake city | Virginia | 51550 | 50898 | 497 |
2492760 | 2492760 | 2022-05-10 | Chesapeake city | Virginia | 51550 | 50836 | 497 |
2489502 | 2489502 | 2022-05-09 | Chesapeake city | Virginia | 51550 | 50793 | 497 |
2486245 | 2486245 | 2022-05-08 | Chesapeake city | Virginia | 51550 | 50663 | 497 |
2482987 | 2482987 | 2022-05-07 | Chesapeake city | Virginia | 51550 | 50663 | 497 |
2479729 | 2479729 | 2022-05-06 | Chesapeake city | Virginia | 51550 | 50663 | 497 |
2476248 | 2476248 | 2022-05-05 | Hays | Texas | 48209 | 60622 | 497 |
2476471 | 2476471 | 2022-05-05 | Chesapeake city | Virginia | 51550 | 50602 | 497 |
2472991 | 2472991 | 2022-05-04 | Hays | Texas | 48209 | 60592 | 497 |
2473213 | 2473213 | 2022-05-04 | Chesapeake city | Virginia | 51550 | 50557 | 497 |
2467436 | 2467436 | 2022-05-03 | Dougherty | Georgia | 13095 | 19748 | 497 |
2467465 | 2467465 | 2022-05-03 | Houston | Georgia | 13153 | 39489 | 497 |
2469735 | 2469735 | 2022-05-03 | Hays | Texas | 48209 | 60556 | 497 |
2469957 | 2469957 | 2022-05-03 | Chesapeake city | Virginia | 51550 | 50516 | 497 |
2464181 | 2464181 | 2022-05-02 | Dougherty | Georgia | 13095 | 19748 | 497 |
2464210 | 2464210 | 2022-05-02 | Houston | Georgia | 13153 | 39489 | 497 |
2466479 | 2466479 | 2022-05-02 | Hays | Texas | 48209 | 60539 | 497 |
2466701 | 2466701 | 2022-05-02 | Chesapeake city | Virginia | 51550 | 50489 | 497 |
2460925 | 2460925 | 2022-05-01 | Dougherty | Georgia | 13095 | 19739 | 497 |
2460954 | 2460954 | 2022-05-01 | Houston | Georgia | 13153 | 39490 | 497 |
2462802 | 2462802 | 2022-05-01 | Mercer | Pennsylvania | 42085 | 23470 | 497 |
2463224 | 2463224 | 2022-05-01 | Hays | Texas | 48209 | 60479 | 497 |
2463446 | 2463446 | 2022-05-01 | Chesapeake city | Virginia | 51550 | 50406 | 497 |
2457669 | 2457669 | 2022-04-30 | Dougherty | Georgia | 13095 | 19739 | 497 |
2457698 | 2457698 | 2022-04-30 | Houston | Georgia | 13153 | 39490 | 497 |
2459546 | 2459546 | 2022-04-30 | Mercer | Pennsylvania | 42085 | 23459 | 497 |
2459968 | 2459968 | 2022-04-30 | Hays | Texas | 48209 | 60479 | 497 |
2460190 | 2460190 | 2022-04-30 | Chesapeake city | Virginia | 51550 | 50406 | 497 |
2454413 | 2454413 | 2022-04-29 | Dougherty | Georgia | 13095 | 19739 | 497 |
2454442 | 2454442 | 2022-04-29 | Houston | Georgia | 13153 | 39490 | 497 |
2456712 | 2456712 | 2022-04-29 | Hays | Texas | 48209 | 60479 | 497 |
2456934 | 2456934 | 2022-04-29 | Chesapeake city | Virginia | 51550 | 50406 | 497 |
2451157 | 2451157 | 2022-04-28 | Dougherty | Georgia | 13095 | 19739 | 497 |
2451186 | 2451186 | 2022-04-28 | Houston | Georgia | 13153 | 39490 | 497 |
2453456 | 2453456 | 2022-04-28 | Hays | Texas | 48209 | 60453 | 497 |
2453678 | 2453678 | 2022-04-28 | Chesapeake city | Virginia | 51550 | 50372 | 497 |
2447901 | 2447901 | 2022-04-27 | Dougherty | Georgia | 13095 | 19739 | 497 |
2447930 | 2447930 | 2022-04-27 | Houston | Georgia | 13153 | 39490 | 497 |
2450200 | 2450200 | 2022-04-27 | Hays | Texas | 48209 | 60422 | 497 |
2444674 | 2444674 | 2022-04-26 | Houston | Georgia | 13153 | 39398 | 497 |
2446943 | 2446943 | 2022-04-26 | Hays | Texas | 48209 | 60393 | 497 |
2441418 | 2441418 | 2022-04-25 | Houston | Georgia | 13153 | 39398 | 497 |
2443688 | 2443688 | 2022-04-25 | Hays | Texas | 48209 | 60380 | 497 |
2438162 | 2438162 | 2022-04-24 | Houston | Georgia | 13153 | 39401 | 497 |
2440432 | 2440432 | 2022-04-24 | Hays | Texas | 48209 | 60331 | 497 |
2434906 | 2434906 | 2022-04-23 | Houston | Georgia | 13153 | 39401 | 497 |
2437176 | 2437176 | 2022-04-23 | Hays | Texas | 48209 | 60331 | 497 |
2431650 | 2431650 | 2022-04-22 | Houston | Georgia | 13153 | 39401 | 497 |
2433920 | 2433920 | 2022-04-22 | Hays | Texas | 48209 | 60331 | 497 |
2428394 | 2428394 | 2022-04-21 | Houston | Georgia | 13153 | 39401 | 497 |
2430664 | 2430664 | 2022-04-21 | Hays | Texas | 48209 | 60301 | 497 |
2425138 | 2425138 | 2022-04-20 | Houston | Georgia | 13153 | 39401 | 497 |
2427408 | 2427408 | 2022-04-20 | Hays | Texas | 48209 | 60275 | 497 |
2424152 | 2424152 | 2022-04-19 | Hays | Texas | 48209 | 60256 | 497 |
2420896 | 2420896 | 2022-04-18 | Hays | Texas | 48209 | 60216 | 497 |
2417640 | 2417640 | 2022-04-17 | Hays | Texas | 48209 | 60164 | 497 |
2414384 | 2414384 | 2022-04-16 | Hays | Texas | 48209 | 60164 | 497 |
2411128 | 2411128 | 2022-04-15 | Hays | Texas | 48209 | 60164 | 497 |
2407872 | 2407872 | 2022-04-14 | Hays | Texas | 48209 | 60164 | 497 |
2404616 | 2404616 | 2022-04-13 | Hays | Texas | 48209 | 60149 | 497 |
2401361 | 2401361 | 2022-04-12 | Hays | Texas | 48209 | 60127 | 497 |
2396062 | 2396062 | 2022-04-11 | Tazewell | Illinois | 17179 | 36649 | 497 |
2398106 | 2398106 | 2022-04-11 | Hays | Texas | 48209 | 60107 | 497 |
2394851 | 2394851 | 2022-04-10 | Hays | Texas | 48209 | 60081 | 497 |
2394937 | 2394937 | 2022-04-10 | Randall | Texas | 48381 | 38147 | 497 |
2391595 | 2391595 | 2022-04-09 | Hays | Texas | 48209 | 60081 | 497 |
2391681 | 2391681 | 2022-04-09 | Randall | Texas | 48381 | 38147 | 497 |
2388339 | 2388339 | 2022-04-08 | Hays | Texas | 48209 | 60081 | 497 |
2388425 | 2388425 | 2022-04-08 | Randall | Texas | 48381 | 38147 | 497 |
2385084 | 2385084 | 2022-04-07 | Hays | Texas | 48209 | 60065 | 497 |
2385170 | 2385170 | 2022-04-07 | Randall | Texas | 48381 | 38142 | 497 |
2381829 | 2381829 | 2022-04-06 | Hays | Texas | 48209 | 60044 | 497 |
2381915 | 2381915 | 2022-04-06 | Randall | Texas | 48381 | 38136 | 497 |
2382132 | 2382132 | 2022-04-06 | Richmond city | Virginia | 51760 | 44371 | 497 |
2378574 | 2378574 | 2022-04-05 | Hays | Texas | 48209 | 60033 | 497 |
2378660 | 2378660 | 2022-04-05 | Randall | Texas | 48381 | 38134 | 497 |
2378877 | 2378877 | 2022-04-05 | Richmond city | Virginia | 51760 | 44350 | 497 |
2373738 | 2373738 | 2022-04-04 | Lafayette | Louisiana | 22055 | 62299 | 497 |
2375320 | 2375320 | 2022-04-04 | Hays | Texas | 48209 | 60018 | 497 |
2370485 | 2370485 | 2022-04-03 | Lafayette | Louisiana | 22055 | 62287 | 497 |
2372068 | 2372068 | 2022-04-03 | Hays | Texas | 48209 | 59967 | 497 |
2367232 | 2367232 | 2022-04-02 | Lafayette | Louisiana | 22055 | 62287 | 497 |
2368815 | 2368815 | 2022-04-02 | Hays | Texas | 48209 | 59967 | 497 |
2363979 | 2363979 | 2022-04-01 | Lafayette | Louisiana | 22055 | 62287 | 497 |
2365562 | 2365562 | 2022-04-01 | Hays | Texas | 48209 | 59967 | 497 |
2362309 | 2362309 | 2022-03-31 | Hays | Texas | 48209 | 59952 | 497 |
2359055 | 2359055 | 2022-03-30 | Hays | Texas | 48209 | 59916 | 497 |
2355801 | 2355801 | 2022-03-29 | Hays | Texas | 48209 | 59904 | 497 |
2349850 | 2349850 | 2022-03-28 | Houston | Alabama | 1069 | 25641 | 497 |
2352548 | 2352548 | 2022-03-28 | Hays | Texas | 48209 | 59904 | 497 |
2326961 | 2326961 | 2022-03-20 | Dane | Wisconsin | 55025 | 123244 | 497 |
2323708 | 2323708 | 2022-03-19 | Dane | Wisconsin | 55025 | 123244 | 497 |
2320454 | 2320454 | 2022-03-18 | Dane | Wisconsin | 55025 | 123244 | 497 |
2317200 | 2317200 | 2022-03-17 | Dane | Wisconsin | 55025 | 123175 | 497 |
2293399 | 2293399 | 2022-03-10 | Richland | Ohio | 39139 | 31404 | 497 |
2290147 | 2290147 | 2022-03-09 | Richland | Ohio | 39139 | 31397 | 497 |
2285209 | 2285209 | 2022-03-08 | Floyd | Georgia | 13115 | 27089 | 497 |
2286895 | 2286895 | 2022-03-08 | Richland | Ohio | 39139 | 31391 | 497 |
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);