ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
724 rows where county = "Hall" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502302 | 2502302 | 2022-05-13 | Hall | Texas | 48191 | 1102 | 24 |
2499044 | 2499044 | 2022-05-12 | Hall | Texas | 48191 | 1102 | 24 |
2495786 | 2495786 | 2022-05-11 | Hall | Texas | 48191 | 1101 | 24 |
2492528 | 2492528 | 2022-05-10 | Hall | Texas | 48191 | 1101 | 23 |
2489270 | 2489270 | 2022-05-09 | Hall | Texas | 48191 | 1101 | 23 |
2486013 | 2486013 | 2022-05-08 | Hall | Texas | 48191 | 1101 | 23 |
2482755 | 2482755 | 2022-05-07 | Hall | Texas | 48191 | 1101 | 23 |
2479497 | 2479497 | 2022-05-06 | Hall | Texas | 48191 | 1101 | 23 |
2476239 | 2476239 | 2022-05-05 | Hall | Texas | 48191 | 1101 | 23 |
2472982 | 2472982 | 2022-05-04 | Hall | Texas | 48191 | 1101 | 23 |
2469726 | 2469726 | 2022-05-03 | Hall | Texas | 48191 | 1101 | 23 |
2466470 | 2466470 | 2022-05-02 | Hall | Texas | 48191 | 1101 | 23 |
2463215 | 2463215 | 2022-05-01 | Hall | Texas | 48191 | 1101 | 23 |
2459959 | 2459959 | 2022-04-30 | Hall | Texas | 48191 | 1101 | 23 |
2456703 | 2456703 | 2022-04-29 | Hall | Texas | 48191 | 1101 | 23 |
2453447 | 2453447 | 2022-04-28 | Hall | Texas | 48191 | 1101 | 23 |
2450191 | 2450191 | 2022-04-27 | Hall | Texas | 48191 | 1101 | 23 |
2446934 | 2446934 | 2022-04-26 | Hall | Texas | 48191 | 1101 | 23 |
2443679 | 2443679 | 2022-04-25 | Hall | Texas | 48191 | 1101 | 23 |
2440423 | 2440423 | 2022-04-24 | Hall | Texas | 48191 | 1101 | 23 |
2437167 | 2437167 | 2022-04-23 | Hall | Texas | 48191 | 1101 | 23 |
2433911 | 2433911 | 2022-04-22 | Hall | Texas | 48191 | 1101 | 23 |
2430655 | 2430655 | 2022-04-21 | Hall | Texas | 48191 | 1100 | 23 |
2427399 | 2427399 | 2022-04-20 | Hall | Texas | 48191 | 1099 | 23 |
2424143 | 2424143 | 2022-04-19 | Hall | Texas | 48191 | 1095 | 23 |
2420887 | 2420887 | 2022-04-18 | Hall | Texas | 48191 | 1095 | 23 |
2417631 | 2417631 | 2022-04-17 | Hall | Texas | 48191 | 1094 | 23 |
2414375 | 2414375 | 2022-04-16 | Hall | Texas | 48191 | 1094 | 23 |
2411119 | 2411119 | 2022-04-15 | Hall | Texas | 48191 | 1094 | 23 |
2407863 | 2407863 | 2022-04-14 | Hall | Texas | 48191 | 1094 | 23 |
2404607 | 2404607 | 2022-04-13 | Hall | Texas | 48191 | 1094 | 23 |
2401352 | 2401352 | 2022-04-12 | Hall | Texas | 48191 | 1094 | 23 |
2398097 | 2398097 | 2022-04-11 | Hall | Texas | 48191 | 1094 | 23 |
2394842 | 2394842 | 2022-04-10 | Hall | Texas | 48191 | 1094 | 23 |
2391586 | 2391586 | 2022-04-09 | Hall | Texas | 48191 | 1094 | 23 |
2388330 | 2388330 | 2022-04-08 | Hall | Texas | 48191 | 1094 | 23 |
2385075 | 2385075 | 2022-04-07 | Hall | Texas | 48191 | 1094 | 23 |
2381820 | 2381820 | 2022-04-06 | Hall | Texas | 48191 | 1093 | 23 |
2378565 | 2378565 | 2022-04-05 | Hall | Texas | 48191 | 1093 | 23 |
2375311 | 2375311 | 2022-04-04 | Hall | Texas | 48191 | 1090 | 23 |
2372059 | 2372059 | 2022-04-03 | Hall | Texas | 48191 | 1090 | 23 |
2368806 | 2368806 | 2022-04-02 | Hall | Texas | 48191 | 1090 | 23 |
2365553 | 2365553 | 2022-04-01 | Hall | Texas | 48191 | 1089 | 23 |
2362300 | 2362300 | 2022-03-31 | Hall | Texas | 48191 | 1089 | 23 |
2359046 | 2359046 | 2022-03-30 | Hall | Texas | 48191 | 1089 | 23 |
2355792 | 2355792 | 2022-03-29 | Hall | Texas | 48191 | 1089 | 23 |
2352539 | 2352539 | 2022-03-28 | Hall | Texas | 48191 | 1089 | 23 |
2349287 | 2349287 | 2022-03-27 | Hall | Texas | 48191 | 1089 | 23 |
2346034 | 2346034 | 2022-03-26 | Hall | Texas | 48191 | 1089 | 23 |
2342781 | 2342781 | 2022-03-25 | Hall | Texas | 48191 | 1089 | 23 |
2339528 | 2339528 | 2022-03-24 | Hall | Texas | 48191 | 1089 | 23 |
2336274 | 2336274 | 2022-03-23 | Hall | Texas | 48191 | 1088 | 23 |
2333020 | 2333020 | 2022-03-22 | Hall | Texas | 48191 | 1084 | 23 |
2329767 | 2329767 | 2022-03-21 | Hall | Texas | 48191 | 1082 | 23 |
2326515 | 2326515 | 2022-03-20 | Hall | Texas | 48191 | 1082 | 23 |
2323262 | 2323262 | 2022-03-19 | Hall | Texas | 48191 | 1082 | 23 |
2320008 | 2320008 | 2022-03-18 | Hall | Texas | 48191 | 1082 | 23 |
2316754 | 2316754 | 2022-03-17 | Hall | Texas | 48191 | 1080 | 23 |
2313501 | 2313501 | 2022-03-16 | Hall | Texas | 48191 | 1080 | 23 |
2310248 | 2310248 | 2022-03-15 | Hall | Texas | 48191 | 1078 | 23 |
2306995 | 2306995 | 2022-03-14 | Hall | Texas | 48191 | 1074 | 23 |
2303744 | 2303744 | 2022-03-13 | Hall | Texas | 48191 | 1074 | 23 |
2300492 | 2300492 | 2022-03-12 | Hall | Texas | 48191 | 1074 | 23 |
2297240 | 2297240 | 2022-03-11 | Hall | Texas | 48191 | 1071 | 22 |
2293988 | 2293988 | 2022-03-10 | Hall | Texas | 48191 | 1068 | 22 |
2290736 | 2290736 | 2022-03-09 | Hall | Texas | 48191 | 1067 | 22 |
2287484 | 2287484 | 2022-03-08 | Hall | Texas | 48191 | 1067 | 22 |
2284232 | 2284232 | 2022-03-07 | Hall | Texas | 48191 | 1067 | 22 |
2280980 | 2280980 | 2022-03-06 | Hall | Texas | 48191 | 1067 | 22 |
2277727 | 2277727 | 2022-03-05 | Hall | Texas | 48191 | 1067 | 22 |
2274474 | 2274474 | 2022-03-04 | Hall | Texas | 48191 | 1067 | 22 |
2271221 | 2271221 | 2022-03-03 | Hall | Texas | 48191 | 1067 | 22 |
2267969 | 2267969 | 2022-03-02 | Hall | Texas | 48191 | 1067 | 22 |
2264716 | 2264716 | 2022-03-01 | Hall | Texas | 48191 | 1067 | 22 |
2261466 | 2261466 | 2022-02-28 | Hall | Texas | 48191 | 1067 | 21 |
2258215 | 2258215 | 2022-02-27 | Hall | Texas | 48191 | 1067 | 21 |
2254964 | 2254964 | 2022-02-26 | Hall | Texas | 48191 | 1067 | 21 |
2251713 | 2251713 | 2022-02-25 | Hall | Texas | 48191 | 1067 | 21 |
2248462 | 2248462 | 2022-02-24 | Hall | Texas | 48191 | 1066 | 21 |
2245211 | 2245211 | 2022-02-23 | Hall | Texas | 48191 | 1051 | 21 |
2241960 | 2241960 | 2022-02-22 | Hall | Texas | 48191 | 1029 | 21 |
2238709 | 2238709 | 2022-02-21 | Hall | Texas | 48191 | 1029 | 21 |
2235458 | 2235458 | 2022-02-20 | Hall | Texas | 48191 | 1029 | 21 |
2232207 | 2232207 | 2022-02-19 | Hall | Texas | 48191 | 1029 | 21 |
2228956 | 2228956 | 2022-02-18 | Hall | Texas | 48191 | 994 | 21 |
2225705 | 2225705 | 2022-02-17 | Hall | Texas | 48191 | 984 | 21 |
2222454 | 2222454 | 2022-02-16 | Hall | Texas | 48191 | 981 | 21 |
2219203 | 2219203 | 2022-02-15 | Hall | Texas | 48191 | 980 | 21 |
2215952 | 2215952 | 2022-02-14 | Hall | Texas | 48191 | 978 | 21 |
2212701 | 2212701 | 2022-02-13 | Hall | Texas | 48191 | 978 | 21 |
2209448 | 2209448 | 2022-02-12 | Hall | Texas | 48191 | 977 | 21 |
2206195 | 2206195 | 2022-02-11 | Hall | Texas | 48191 | 975 | 21 |
2202942 | 2202942 | 2022-02-10 | Hall | Texas | 48191 | 963 | 21 |
2199688 | 2199688 | 2022-02-09 | Hall | Texas | 48191 | 936 | 20 |
2196434 | 2196434 | 2022-02-08 | Hall | Texas | 48191 | 932 | 20 |
2193180 | 2193180 | 2022-02-07 | Hall | Texas | 48191 | 924 | 20 |
2189926 | 2189926 | 2022-02-06 | Hall | Texas | 48191 | 924 | 20 |
2186673 | 2186673 | 2022-02-05 | Hall | Texas | 48191 | 924 | 20 |
2183421 | 2183421 | 2022-02-04 | Hall | Texas | 48191 | 911 | 20 |
2180169 | 2180169 | 2022-02-03 | Hall | Texas | 48191 | 910 | 20 |
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);