ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,292 rows where county = "Hall" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 1
- Hall · 2,192 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2393828 | 2393828 | 2022-04-10 | Hall | Nebraska | 31079 | 16522 | 137 |
2394842 | 2394842 | 2022-04-10 | Hall | Texas | 48191 | 1094 | 23 |
2389318 | 2389318 | 2022-04-09 | Hall | Georgia | 13139 | 53910 | 836 |
2390572 | 2390572 | 2022-04-09 | Hall | Nebraska | 31079 | 16522 | 137 |
2391586 | 2391586 | 2022-04-09 | Hall | Texas | 48191 | 1094 | 23 |
2386063 | 2386063 | 2022-04-08 | Hall | Georgia | 13139 | 53910 | 836 |
2387316 | 2387316 | 2022-04-08 | Hall | Nebraska | 31079 | 16522 | 137 |
2388330 | 2388330 | 2022-04-08 | Hall | Texas | 48191 | 1094 | 23 |
2382808 | 2382808 | 2022-04-07 | Hall | Georgia | 13139 | 53916 | 833 |
2384061 | 2384061 | 2022-04-07 | Hall | Nebraska | 31079 | 16520 | 137 |
2385075 | 2385075 | 2022-04-07 | Hall | Texas | 48191 | 1094 | 23 |
2379553 | 2379553 | 2022-04-06 | Hall | Georgia | 13139 | 53899 | 832 |
2380806 | 2380806 | 2022-04-06 | Hall | Nebraska | 31079 | 16519 | 137 |
2381820 | 2381820 | 2022-04-06 | Hall | Texas | 48191 | 1093 | 23 |
2376299 | 2376299 | 2022-04-05 | Hall | Georgia | 13139 | 53876 | 831 |
2377551 | 2377551 | 2022-04-05 | Hall | Nebraska | 31079 | 16519 | 137 |
2378565 | 2378565 | 2022-04-05 | Hall | Texas | 48191 | 1093 | 23 |
2373047 | 2373047 | 2022-04-04 | Hall | Georgia | 13139 | 53883 | 831 |
2374298 | 2374298 | 2022-04-04 | Hall | Nebraska | 31079 | 16515 | 137 |
2375311 | 2375311 | 2022-04-04 | Hall | Texas | 48191 | 1090 | 23 |
2369794 | 2369794 | 2022-04-03 | Hall | Georgia | 13139 | 53757 | 830 |
2371046 | 2371046 | 2022-04-03 | Hall | Nebraska | 31079 | 16515 | 137 |
2372059 | 2372059 | 2022-04-03 | Hall | Texas | 48191 | 1090 | 23 |
2366541 | 2366541 | 2022-04-02 | Hall | Georgia | 13139 | 53757 | 830 |
2367793 | 2367793 | 2022-04-02 | Hall | Nebraska | 31079 | 16515 | 137 |
2368806 | 2368806 | 2022-04-02 | Hall | Texas | 48191 | 1090 | 23 |
2363288 | 2363288 | 2022-04-01 | Hall | Georgia | 13139 | 53757 | 830 |
2364540 | 2364540 | 2022-04-01 | Hall | Nebraska | 31079 | 16515 | 137 |
2365553 | 2365553 | 2022-04-01 | Hall | Texas | 48191 | 1089 | 23 |
2360034 | 2360034 | 2022-03-31 | Hall | Georgia | 13139 | 53740 | 827 |
2361286 | 2361286 | 2022-03-31 | Hall | Nebraska | 31079 | 16516 | 137 |
2362300 | 2362300 | 2022-03-31 | Hall | Texas | 48191 | 1089 | 23 |
2356780 | 2356780 | 2022-03-30 | Hall | Georgia | 13139 | 53727 | 824 |
2358032 | 2358032 | 2022-03-30 | Hall | Nebraska | 31079 | 16512 | 137 |
2359046 | 2359046 | 2022-03-30 | Hall | Texas | 48191 | 1089 | 23 |
2353527 | 2353527 | 2022-03-29 | Hall | Georgia | 13139 | 53698 | 824 |
2354779 | 2354779 | 2022-03-29 | Hall | Nebraska | 31079 | 16513 | 137 |
2355792 | 2355792 | 2022-03-29 | Hall | Texas | 48191 | 1089 | 23 |
2350275 | 2350275 | 2022-03-28 | Hall | Georgia | 13139 | 53695 | 824 |
2351526 | 2351526 | 2022-03-28 | Hall | Nebraska | 31079 | 16514 | 137 |
2352539 | 2352539 | 2022-03-28 | Hall | Texas | 48191 | 1089 | 23 |
2347022 | 2347022 | 2022-03-27 | Hall | Georgia | 13139 | 53549 | 823 |
2348274 | 2348274 | 2022-03-27 | Hall | Nebraska | 31079 | 16493 | 137 |
2349287 | 2349287 | 2022-03-27 | Hall | Texas | 48191 | 1089 | 23 |
2343769 | 2343769 | 2022-03-26 | Hall | Georgia | 13139 | 53549 | 823 |
2345021 | 2345021 | 2022-03-26 | Hall | Nebraska | 31079 | 16493 | 137 |
2346034 | 2346034 | 2022-03-26 | Hall | Texas | 48191 | 1089 | 23 |
2340516 | 2340516 | 2022-03-25 | Hall | Georgia | 13139 | 53549 | 823 |
2341768 | 2341768 | 2022-03-25 | Hall | Nebraska | 31079 | 16493 | 137 |
2342781 | 2342781 | 2022-03-25 | Hall | Texas | 48191 | 1089 | 23 |
2337263 | 2337263 | 2022-03-24 | Hall | Georgia | 13139 | 53555 | 819 |
2338515 | 2338515 | 2022-03-24 | Hall | Nebraska | 31079 | 16495 | 137 |
2339528 | 2339528 | 2022-03-24 | Hall | Texas | 48191 | 1089 | 23 |
2334009 | 2334009 | 2022-03-23 | Hall | Georgia | 13139 | 53556 | 816 |
2335261 | 2335261 | 2022-03-23 | Hall | Nebraska | 31079 | 16493 | 137 |
2336274 | 2336274 | 2022-03-23 | Hall | Texas | 48191 | 1088 | 23 |
2330755 | 2330755 | 2022-03-22 | Hall | Georgia | 13139 | 53557 | 817 |
2332007 | 2332007 | 2022-03-22 | Hall | Nebraska | 31079 | 16493 | 137 |
2333020 | 2333020 | 2022-03-22 | Hall | Texas | 48191 | 1084 | 23 |
2327503 | 2327503 | 2022-03-21 | Hall | Georgia | 13139 | 53559 | 816 |
2328754 | 2328754 | 2022-03-21 | Hall | Nebraska | 31079 | 16491 | 137 |
2329767 | 2329767 | 2022-03-21 | Hall | Texas | 48191 | 1082 | 23 |
2324250 | 2324250 | 2022-03-20 | Hall | Georgia | 13139 | 53516 | 815 |
2325502 | 2325502 | 2022-03-20 | Hall | Nebraska | 31079 | 16482 | 137 |
2326515 | 2326515 | 2022-03-20 | Hall | Texas | 48191 | 1082 | 23 |
2320996 | 2320996 | 2022-03-19 | Hall | Georgia | 13139 | 53516 | 815 |
2322248 | 2322248 | 2022-03-19 | Hall | Nebraska | 31079 | 16482 | 137 |
2323262 | 2323262 | 2022-03-19 | Hall | Texas | 48191 | 1082 | 23 |
2317742 | 2317742 | 2022-03-18 | Hall | Georgia | 13139 | 53516 | 815 |
2318994 | 2318994 | 2022-03-18 | Hall | Nebraska | 31079 | 16479 | 137 |
2320008 | 2320008 | 2022-03-18 | Hall | Texas | 48191 | 1082 | 23 |
2314489 | 2314489 | 2022-03-17 | Hall | Georgia | 13139 | 53517 | 814 |
2315741 | 2315741 | 2022-03-17 | Hall | Nebraska | 31079 | 16479 | 137 |
2316754 | 2316754 | 2022-03-17 | Hall | Texas | 48191 | 1080 | 23 |
2311236 | 2311236 | 2022-03-16 | Hall | Georgia | 13139 | 53518 | 814 |
2312488 | 2312488 | 2022-03-16 | Hall | Nebraska | 31079 | 16474 | 137 |
2313501 | 2313501 | 2022-03-16 | Hall | Texas | 48191 | 1080 | 23 |
2307983 | 2307983 | 2022-03-15 | Hall | Georgia | 13139 | 53508 | 812 |
2309235 | 2309235 | 2022-03-15 | Hall | Nebraska | 31079 | 16476 | 137 |
2310248 | 2310248 | 2022-03-15 | Hall | Texas | 48191 | 1078 | 23 |
2304732 | 2304732 | 2022-03-14 | Hall | Georgia | 13139 | 53498 | 812 |
2305983 | 2305983 | 2022-03-14 | Hall | Nebraska | 31079 | 16476 | 137 |
2306995 | 2306995 | 2022-03-14 | Hall | Texas | 48191 | 1074 | 23 |
2301480 | 2301480 | 2022-03-13 | Hall | Georgia | 13139 | 53431 | 810 |
2302732 | 2302732 | 2022-03-13 | Hall | Nebraska | 31079 | 16471 | 137 |
2303744 | 2303744 | 2022-03-13 | Hall | Texas | 48191 | 1074 | 23 |
2298228 | 2298228 | 2022-03-12 | Hall | Georgia | 13139 | 53431 | 810 |
2299480 | 2299480 | 2022-03-12 | Hall | Nebraska | 31079 | 16471 | 137 |
2300492 | 2300492 | 2022-03-12 | Hall | Texas | 48191 | 1074 | 23 |
2294976 | 2294976 | 2022-03-11 | Hall | Georgia | 13139 | 53431 | 810 |
2296228 | 2296228 | 2022-03-11 | Hall | Nebraska | 31079 | 16471 | 137 |
2297240 | 2297240 | 2022-03-11 | Hall | Texas | 48191 | 1071 | 22 |
2291724 | 2291724 | 2022-03-10 | Hall | Georgia | 13139 | 53436 | 808 |
2292976 | 2292976 | 2022-03-10 | Hall | Nebraska | 31079 | 16470 | 137 |
2293988 | 2293988 | 2022-03-10 | Hall | Texas | 48191 | 1068 | 22 |
2288472 | 2288472 | 2022-03-09 | Hall | Georgia | 13139 | 53426 | 804 |
2289724 | 2289724 | 2022-03-09 | Hall | Nebraska | 31079 | 16472 | 120 |
2290736 | 2290736 | 2022-03-09 | Hall | Texas | 48191 | 1067 | 22 |
2285221 | 2285221 | 2022-03-08 | Hall | Georgia | 13139 | 53427 | 804 |
2286472 | 2286472 | 2022-03-08 | Hall | Nebraska | 31079 | 16463 | 120 |
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);