ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,191 rows where deaths = 247 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 125
- California 100
- Georgia 98
- Ohio 79
- Arkansas 74
- North Carolina 67
- Idaho 52
- Louisiana 47
- Tennessee 38
- Indiana 35
- Virginia 34
- New York 33
- South Carolina 30
- Alabama 28
- Michigan 28
- Washington 26
- Florida 24
- Kentucky 24
- New Jersey 23
- Pennsylvania 23
- Mississippi 21
- Missouri 20
- Illinois 19
- New Mexico 16
- Wisconsin 16
- Colorado 13
- Maryland 10
- Minnesota 10
- West Virginia 10
- Oklahoma 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499688 | 2499688 | 2022-05-13 | Baxter | Arkansas | 5005 | 8848 | 247 |
2500135 | 2500135 | 2022-05-13 | Bannock | Idaho | 16005 | 20914 | 247 |
2502394 | 2502394 | 2022-05-13 | Polk | Texas | 48373 | 7896 | 247 |
2496430 | 2496430 | 2022-05-12 | Baxter | Arkansas | 5005 | 8847 | 247 |
2496877 | 2496877 | 2022-05-12 | Bannock | Idaho | 16005 | 20906 | 247 |
2499136 | 2499136 | 2022-05-12 | Polk | Texas | 48373 | 7895 | 247 |
2493172 | 2493172 | 2022-05-11 | Baxter | Arkansas | 5005 | 8840 | 247 |
2493619 | 2493619 | 2022-05-11 | Bannock | Idaho | 16005 | 20906 | 247 |
2495878 | 2495878 | 2022-05-11 | Polk | Texas | 48373 | 7893 | 247 |
2489914 | 2489914 | 2022-05-10 | Baxter | Arkansas | 5005 | 8839 | 247 |
2490361 | 2490361 | 2022-05-10 | Bannock | Idaho | 16005 | 20893 | 247 |
2492103 | 2492103 | 2022-05-10 | Huntingdon | Pennsylvania | 42061 | 11568 | 247 |
2492620 | 2492620 | 2022-05-10 | Polk | Texas | 48373 | 7893 | 247 |
2492781 | 2492781 | 2022-05-10 | Frederick | Virginia | 51069 | 20839 | 247 |
2486657 | 2486657 | 2022-05-09 | Baxter | Arkansas | 5005 | 8834 | 247 |
2487104 | 2487104 | 2022-05-09 | Bannock | Idaho | 16005 | 20893 | 247 |
2488845 | 2488845 | 2022-05-09 | Huntingdon | Pennsylvania | 42061 | 11568 | 247 |
2489362 | 2489362 | 2022-05-09 | Polk | Texas | 48373 | 7892 | 247 |
2489523 | 2489523 | 2022-05-09 | Frederick | Virginia | 51069 | 20815 | 247 |
2483399 | 2483399 | 2022-05-08 | Baxter | Arkansas | 5005 | 8834 | 247 |
2483846 | 2483846 | 2022-05-08 | Bannock | Idaho | 16005 | 20886 | 247 |
2485588 | 2485588 | 2022-05-08 | Huntingdon | Pennsylvania | 42061 | 11568 | 247 |
2486104 | 2486104 | 2022-05-08 | Polk | Texas | 48373 | 7889 | 247 |
2486266 | 2486266 | 2022-05-08 | Frederick | Virginia | 51069 | 20765 | 247 |
2480141 | 2480141 | 2022-05-07 | Baxter | Arkansas | 5005 | 8830 | 247 |
2480588 | 2480588 | 2022-05-07 | Bannock | Idaho | 16005 | 20886 | 247 |
2482330 | 2482330 | 2022-05-07 | Huntingdon | Pennsylvania | 42061 | 11568 | 247 |
2482846 | 2482846 | 2022-05-07 | Polk | Texas | 48373 | 7888 | 247 |
2483008 | 2483008 | 2022-05-07 | Frederick | Virginia | 51069 | 20765 | 247 |
2476883 | 2476883 | 2022-05-06 | Baxter | Arkansas | 5005 | 8826 | 247 |
2477330 | 2477330 | 2022-05-06 | Bannock | Idaho | 16005 | 20886 | 247 |
2479072 | 2479072 | 2022-05-06 | Huntingdon | Pennsylvania | 42061 | 11568 | 247 |
2479588 | 2479588 | 2022-05-06 | Polk | Texas | 48373 | 7888 | 247 |
2479750 | 2479750 | 2022-05-06 | Frederick | Virginia | 51069 | 20765 | 247 |
2473625 | 2473625 | 2022-05-05 | Baxter | Arkansas | 5005 | 8823 | 247 |
2474072 | 2474072 | 2022-05-05 | Bannock | Idaho | 16005 | 20873 | 247 |
2475814 | 2475814 | 2022-05-05 | Huntingdon | Pennsylvania | 42061 | 11568 | 247 |
2476330 | 2476330 | 2022-05-05 | Polk | Texas | 48373 | 7887 | 247 |
2476492 | 2476492 | 2022-05-05 | Frederick | Virginia | 51069 | 20746 | 247 |
2470368 | 2470368 | 2022-05-04 | Baxter | Arkansas | 5005 | 8808 | 247 |
2470815 | 2470815 | 2022-05-04 | Bannock | Idaho | 16005 | 20873 | 247 |
2472557 | 2472557 | 2022-05-04 | Huntingdon | Pennsylvania | 42061 | 11568 | 247 |
2473073 | 2473073 | 2022-05-04 | Polk | Texas | 48373 | 7885 | 247 |
2473234 | 2473234 | 2022-05-04 | Frederick | Virginia | 51069 | 20725 | 247 |
2467112 | 2467112 | 2022-05-03 | Baxter | Arkansas | 5005 | 8805 | 247 |
2467559 | 2467559 | 2022-05-03 | Bannock | Idaho | 16005 | 20860 | 247 |
2469301 | 2469301 | 2022-05-03 | Huntingdon | Pennsylvania | 42061 | 11561 | 247 |
2469817 | 2469817 | 2022-05-03 | Polk | Texas | 48373 | 7884 | 247 |
2463857 | 2463857 | 2022-05-02 | Baxter | Arkansas | 5005 | 8801 | 247 |
2464304 | 2464304 | 2022-05-02 | Bannock | Idaho | 16005 | 20860 | 247 |
2466561 | 2466561 | 2022-05-02 | Polk | Texas | 48373 | 7884 | 247 |
2460601 | 2460601 | 2022-05-01 | Baxter | Arkansas | 5005 | 8801 | 247 |
2461048 | 2461048 | 2022-05-01 | Bannock | Idaho | 16005 | 20852 | 247 |
2462301 | 2462301 | 2022-05-01 | Salem | New Jersey | 34033 | 14469 | 247 |
2463306 | 2463306 | 2022-05-01 | Polk | Texas | 48373 | 7884 | 247 |
2457345 | 2457345 | 2022-04-30 | Baxter | Arkansas | 5005 | 8801 | 247 |
2457792 | 2457792 | 2022-04-30 | Bannock | Idaho | 16005 | 20852 | 247 |
2459045 | 2459045 | 2022-04-30 | Salem | New Jersey | 34033 | 14460 | 247 |
2460050 | 2460050 | 2022-04-30 | Polk | Texas | 48373 | 7880 | 247 |
2454089 | 2454089 | 2022-04-29 | Baxter | Arkansas | 5005 | 8798 | 247 |
2454536 | 2454536 | 2022-04-29 | Bannock | Idaho | 16005 | 20852 | 247 |
2455789 | 2455789 | 2022-04-29 | Salem | New Jersey | 34033 | 14449 | 247 |
2456794 | 2456794 | 2022-04-29 | Polk | Texas | 48373 | 7876 | 247 |
2450833 | 2450833 | 2022-04-28 | Baxter | Arkansas | 5005 | 8798 | 247 |
2451280 | 2451280 | 2022-04-28 | Bannock | Idaho | 16005 | 20840 | 247 |
2452533 | 2452533 | 2022-04-28 | Salem | New Jersey | 34033 | 14428 | 247 |
2453538 | 2453538 | 2022-04-28 | Polk | Texas | 48373 | 7873 | 247 |
2447577 | 2447577 | 2022-04-27 | Baxter | Arkansas | 5005 | 8796 | 247 |
2448024 | 2448024 | 2022-04-27 | Bannock | Idaho | 16005 | 20840 | 247 |
2449277 | 2449277 | 2022-04-27 | Salem | New Jersey | 34033 | 14418 | 247 |
2449576 | 2449576 | 2022-04-27 | Lawrence | Ohio | 39087 | 17895 | 247 |
2450282 | 2450282 | 2022-04-27 | Polk | Texas | 48373 | 7844 | 247 |
2444321 | 2444321 | 2022-04-26 | Baxter | Arkansas | 5005 | 8789 | 247 |
2444768 | 2444768 | 2022-04-26 | Bannock | Idaho | 16005 | 20835 | 247 |
2446020 | 2446020 | 2022-04-26 | Salem | New Jersey | 34033 | 14410 | 247 |
2446319 | 2446319 | 2022-04-26 | Lawrence | Ohio | 39087 | 17895 | 247 |
2447025 | 2447025 | 2022-04-26 | Polk | Texas | 48373 | 7839 | 247 |
2441065 | 2441065 | 2022-04-25 | Baxter | Arkansas | 5005 | 8788 | 247 |
2441512 | 2441512 | 2022-04-25 | Bannock | Idaho | 16005 | 20835 | 247 |
2442765 | 2442765 | 2022-04-25 | Salem | New Jersey | 34033 | 14407 | 247 |
2443064 | 2443064 | 2022-04-25 | Lawrence | Ohio | 39087 | 17895 | 247 |
2443770 | 2443770 | 2022-04-25 | Polk | Texas | 48373 | 7838 | 247 |
2437809 | 2437809 | 2022-04-24 | Baxter | Arkansas | 5005 | 8787 | 247 |
2438256 | 2438256 | 2022-04-24 | Bannock | Idaho | 16005 | 20830 | 247 |
2439509 | 2439509 | 2022-04-24 | Salem | New Jersey | 34033 | 14416 | 247 |
2439808 | 2439808 | 2022-04-24 | Lawrence | Ohio | 39087 | 17895 | 247 |
2440514 | 2440514 | 2022-04-24 | Polk | Texas | 48373 | 7835 | 247 |
2434553 | 2434553 | 2022-04-23 | Baxter | Arkansas | 5005 | 8787 | 247 |
2435000 | 2435000 | 2022-04-23 | Bannock | Idaho | 16005 | 20830 | 247 |
2436253 | 2436253 | 2022-04-23 | Salem | New Jersey | 34033 | 14409 | 247 |
2436552 | 2436552 | 2022-04-23 | Lawrence | Ohio | 39087 | 17895 | 247 |
2437258 | 2437258 | 2022-04-23 | Polk | Texas | 48373 | 7834 | 247 |
2431297 | 2431297 | 2022-04-22 | Baxter | Arkansas | 5005 | 8786 | 247 |
2431744 | 2431744 | 2022-04-22 | Bannock | Idaho | 16005 | 20830 | 247 |
2433296 | 2433296 | 2022-04-22 | Lawrence | Ohio | 39087 | 17895 | 247 |
2434002 | 2434002 | 2022-04-22 | Polk | Texas | 48373 | 7834 | 247 |
2428041 | 2428041 | 2022-04-21 | Baxter | Arkansas | 5005 | 8786 | 247 |
2428488 | 2428488 | 2022-04-21 | Bannock | Idaho | 16005 | 20813 | 247 |
2430040 | 2430040 | 2022-04-21 | Lawrence | Ohio | 39087 | 17895 | 247 |
2430746 | 2430746 | 2022-04-21 | Polk | Texas | 48373 | 7832 | 247 |
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);