ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,111 rows where deaths = 48 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Burleson 106
- Ochiltree 71
- Floyd 67
- Calhoun 66
- La Salle 53
- Gillespie 48
- Mitchell 45
- Washington 42
- Eastland 39
- Medina 27
- Milam 26
- Chambers 22
- Frio 22
- Dimmit 20
- Falls 19
- Freestone 19
- Andrews 17
- Rains 17
- Brooks 15
- Robertson 14
- Coleman 11
- DeWitt 10
- Llano 10
- Bastrop 9
- Jasper 9
- Matagorda 9
- Runnels 9
- Bosque 8
- Hunt 8
- Johnson 8
- …
state 1
- Texas · 1,111 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502235 | 2502235 | 2022-05-13 | Calhoun | Texas | 48057 | 5731 | 48 |
2502283 | 2502283 | 2022-05-13 | Floyd | Texas | 48153 | 1961 | 48 |
2502345 | 2502345 | 2022-05-13 | La Salle | Texas | 48283 | 2421 | 48 |
2502385 | 2502385 | 2022-05-13 | Ochiltree | Texas | 48357 | 2424 | 48 |
2498977 | 2498977 | 2022-05-12 | Calhoun | Texas | 48057 | 5729 | 48 |
2499025 | 2499025 | 2022-05-12 | Floyd | Texas | 48153 | 1961 | 48 |
2499087 | 2499087 | 2022-05-12 | La Salle | Texas | 48283 | 2421 | 48 |
2499127 | 2499127 | 2022-05-12 | Ochiltree | Texas | 48357 | 2424 | 48 |
2495719 | 2495719 | 2022-05-11 | Calhoun | Texas | 48057 | 5729 | 48 |
2495767 | 2495767 | 2022-05-11 | Floyd | Texas | 48153 | 1961 | 48 |
2495829 | 2495829 | 2022-05-11 | La Salle | Texas | 48283 | 2421 | 48 |
2495858 | 2495858 | 2022-05-11 | Mitchell | Texas | 48335 | 1864 | 48 |
2495869 | 2495869 | 2022-05-11 | Ochiltree | Texas | 48357 | 2424 | 48 |
2492461 | 2492461 | 2022-05-10 | Calhoun | Texas | 48057 | 5727 | 48 |
2492509 | 2492509 | 2022-05-10 | Floyd | Texas | 48153 | 1960 | 48 |
2492571 | 2492571 | 2022-05-10 | La Salle | Texas | 48283 | 2421 | 48 |
2492600 | 2492600 | 2022-05-10 | Mitchell | Texas | 48335 | 1864 | 48 |
2492611 | 2492611 | 2022-05-10 | Ochiltree | Texas | 48357 | 2424 | 48 |
2489203 | 2489203 | 2022-05-09 | Calhoun | Texas | 48057 | 5722 | 48 |
2489251 | 2489251 | 2022-05-09 | Floyd | Texas | 48153 | 1960 | 48 |
2489313 | 2489313 | 2022-05-09 | La Salle | Texas | 48283 | 2416 | 48 |
2489342 | 2489342 | 2022-05-09 | Mitchell | Texas | 48335 | 1864 | 48 |
2489353 | 2489353 | 2022-05-09 | Ochiltree | Texas | 48357 | 2424 | 48 |
2485946 | 2485946 | 2022-05-08 | Calhoun | Texas | 48057 | 5722 | 48 |
2485994 | 2485994 | 2022-05-08 | Floyd | Texas | 48153 | 1960 | 48 |
2486056 | 2486056 | 2022-05-08 | La Salle | Texas | 48283 | 2416 | 48 |
2486085 | 2486085 | 2022-05-08 | Mitchell | Texas | 48335 | 1864 | 48 |
2486096 | 2486096 | 2022-05-08 | Ochiltree | Texas | 48357 | 2423 | 48 |
2482688 | 2482688 | 2022-05-07 | Calhoun | Texas | 48057 | 5720 | 48 |
2482736 | 2482736 | 2022-05-07 | Floyd | Texas | 48153 | 1959 | 48 |
2482798 | 2482798 | 2022-05-07 | La Salle | Texas | 48283 | 2416 | 48 |
2482827 | 2482827 | 2022-05-07 | Mitchell | Texas | 48335 | 1864 | 48 |
2482838 | 2482838 | 2022-05-07 | Ochiltree | Texas | 48357 | 2423 | 48 |
2479430 | 2479430 | 2022-05-06 | Calhoun | Texas | 48057 | 5718 | 48 |
2479478 | 2479478 | 2022-05-06 | Floyd | Texas | 48153 | 1958 | 48 |
2479540 | 2479540 | 2022-05-06 | La Salle | Texas | 48283 | 2410 | 48 |
2479569 | 2479569 | 2022-05-06 | Mitchell | Texas | 48335 | 1864 | 48 |
2479580 | 2479580 | 2022-05-06 | Ochiltree | Texas | 48357 | 2423 | 48 |
2476172 | 2476172 | 2022-05-05 | Calhoun | Texas | 48057 | 5716 | 48 |
2476220 | 2476220 | 2022-05-05 | Floyd | Texas | 48153 | 1958 | 48 |
2476282 | 2476282 | 2022-05-05 | La Salle | Texas | 48283 | 2402 | 48 |
2476311 | 2476311 | 2022-05-05 | Mitchell | Texas | 48335 | 1864 | 48 |
2476322 | 2476322 | 2022-05-05 | Ochiltree | Texas | 48357 | 2423 | 48 |
2472915 | 2472915 | 2022-05-04 | Calhoun | Texas | 48057 | 5715 | 48 |
2472963 | 2472963 | 2022-05-04 | Floyd | Texas | 48153 | 1958 | 48 |
2473025 | 2473025 | 2022-05-04 | La Salle | Texas | 48283 | 2394 | 48 |
2473054 | 2473054 | 2022-05-04 | Mitchell | Texas | 48335 | 1864 | 48 |
2473065 | 2473065 | 2022-05-04 | Ochiltree | Texas | 48357 | 2423 | 48 |
2469659 | 2469659 | 2022-05-03 | Calhoun | Texas | 48057 | 5714 | 48 |
2469707 | 2469707 | 2022-05-03 | Floyd | Texas | 48153 | 1957 | 48 |
2469769 | 2469769 | 2022-05-03 | La Salle | Texas | 48283 | 2391 | 48 |
2469798 | 2469798 | 2022-05-03 | Mitchell | Texas | 48335 | 1864 | 48 |
2469809 | 2469809 | 2022-05-03 | Ochiltree | Texas | 48357 | 2423 | 48 |
2466403 | 2466403 | 2022-05-02 | Calhoun | Texas | 48057 | 5712 | 48 |
2466451 | 2466451 | 2022-05-02 | Floyd | Texas | 48153 | 1957 | 48 |
2466513 | 2466513 | 2022-05-02 | La Salle | Texas | 48283 | 2382 | 48 |
2466542 | 2466542 | 2022-05-02 | Mitchell | Texas | 48335 | 1864 | 48 |
2466553 | 2466553 | 2022-05-02 | Ochiltree | Texas | 48357 | 2423 | 48 |
2463148 | 2463148 | 2022-05-01 | Calhoun | Texas | 48057 | 5711 | 48 |
2463196 | 2463196 | 2022-05-01 | Floyd | Texas | 48153 | 1957 | 48 |
2463258 | 2463258 | 2022-05-01 | La Salle | Texas | 48283 | 2380 | 48 |
2463287 | 2463287 | 2022-05-01 | Mitchell | Texas | 48335 | 1864 | 48 |
2463298 | 2463298 | 2022-05-01 | Ochiltree | Texas | 48357 | 2423 | 48 |
2459892 | 2459892 | 2022-04-30 | Calhoun | Texas | 48057 | 5709 | 48 |
2459940 | 2459940 | 2022-04-30 | Floyd | Texas | 48153 | 1957 | 48 |
2460002 | 2460002 | 2022-04-30 | La Salle | Texas | 48283 | 2378 | 48 |
2460031 | 2460031 | 2022-04-30 | Mitchell | Texas | 48335 | 1864 | 48 |
2460042 | 2460042 | 2022-04-30 | Ochiltree | Texas | 48357 | 2423 | 48 |
2456636 | 2456636 | 2022-04-29 | Calhoun | Texas | 48057 | 5707 | 48 |
2456684 | 2456684 | 2022-04-29 | Floyd | Texas | 48153 | 1957 | 48 |
2456746 | 2456746 | 2022-04-29 | La Salle | Texas | 48283 | 2377 | 48 |
2456775 | 2456775 | 2022-04-29 | Mitchell | Texas | 48335 | 1864 | 48 |
2456786 | 2456786 | 2022-04-29 | Ochiltree | Texas | 48357 | 2423 | 48 |
2453380 | 2453380 | 2022-04-28 | Calhoun | Texas | 48057 | 5706 | 48 |
2453428 | 2453428 | 2022-04-28 | Floyd | Texas | 48153 | 1957 | 48 |
2453490 | 2453490 | 2022-04-28 | La Salle | Texas | 48283 | 2362 | 48 |
2453519 | 2453519 | 2022-04-28 | Mitchell | Texas | 48335 | 1864 | 48 |
2453530 | 2453530 | 2022-04-28 | Ochiltree | Texas | 48357 | 2423 | 48 |
2450124 | 2450124 | 2022-04-27 | Calhoun | Texas | 48057 | 5706 | 48 |
2450172 | 2450172 | 2022-04-27 | Floyd | Texas | 48153 | 1957 | 48 |
2450234 | 2450234 | 2022-04-27 | La Salle | Texas | 48283 | 2361 | 48 |
2450263 | 2450263 | 2022-04-27 | Mitchell | Texas | 48335 | 1864 | 48 |
2450274 | 2450274 | 2022-04-27 | Ochiltree | Texas | 48357 | 2423 | 48 |
2446867 | 2446867 | 2022-04-26 | Calhoun | Texas | 48057 | 5706 | 48 |
2446915 | 2446915 | 2022-04-26 | Floyd | Texas | 48153 | 1957 | 48 |
2446977 | 2446977 | 2022-04-26 | La Salle | Texas | 48283 | 2357 | 48 |
2447006 | 2447006 | 2022-04-26 | Mitchell | Texas | 48335 | 1864 | 48 |
2447017 | 2447017 | 2022-04-26 | Ochiltree | Texas | 48357 | 2423 | 48 |
2443612 | 2443612 | 2022-04-25 | Calhoun | Texas | 48057 | 5706 | 48 |
2443660 | 2443660 | 2022-04-25 | Floyd | Texas | 48153 | 1957 | 48 |
2443722 | 2443722 | 2022-04-25 | La Salle | Texas | 48283 | 2354 | 48 |
2443751 | 2443751 | 2022-04-25 | Mitchell | Texas | 48335 | 1864 | 48 |
2443762 | 2443762 | 2022-04-25 | Ochiltree | Texas | 48357 | 2423 | 48 |
2440356 | 2440356 | 2022-04-24 | Calhoun | Texas | 48057 | 5706 | 48 |
2440404 | 2440404 | 2022-04-24 | Floyd | Texas | 48153 | 1957 | 48 |
2440466 | 2440466 | 2022-04-24 | La Salle | Texas | 48283 | 2354 | 48 |
2440495 | 2440495 | 2022-04-24 | Mitchell | Texas | 48335 | 1864 | 48 |
2440506 | 2440506 | 2022-04-24 | Ochiltree | Texas | 48357 | 2423 | 48 |
2437100 | 2437100 | 2022-04-23 | Calhoun | Texas | 48057 | 5706 | 48 |
2437148 | 2437148 | 2022-04-23 | Floyd | Texas | 48153 | 1957 | 48 |
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);