ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
37 rows where cases = 1527 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2424080 | 2424080 | 2022-04-19 | Carson | Texas | 48065 | 1527 | 36 |
2420824 | 2420824 | 2022-04-18 | Carson | Texas | 48065 | 1527 | 36 |
2417568 | 2417568 | 2022-04-17 | Carson | Texas | 48065 | 1527 | 36 |
2414312 | 2414312 | 2022-04-16 | Carson | Texas | 48065 | 1527 | 36 |
2411056 | 2411056 | 2022-04-15 | Carson | Texas | 48065 | 1527 | 36 |
2407800 | 2407800 | 2022-04-14 | Carson | Texas | 48065 | 1527 | 36 |
2404544 | 2404544 | 2022-04-13 | Carson | Texas | 48065 | 1527 | 35 |
2401289 | 2401289 | 2022-04-12 | Carson | Texas | 48065 | 1527 | 34 |
2398034 | 2398034 | 2022-04-11 | Carson | Texas | 48065 | 1527 | 34 |
2394779 | 2394779 | 2022-04-10 | Carson | Texas | 48065 | 1527 | 34 |
2391523 | 2391523 | 2022-04-09 | Carson | Texas | 48065 | 1527 | 34 |
2388267 | 2388267 | 2022-04-08 | Carson | Texas | 48065 | 1527 | 34 |
2385012 | 2385012 | 2022-04-07 | Carson | Texas | 48065 | 1527 | 34 |
2381757 | 2381757 | 2022-04-06 | Carson | Texas | 48065 | 1527 | 34 |
2378502 | 2378502 | 2022-04-05 | Carson | Texas | 48065 | 1527 | 34 |
2375248 | 2375248 | 2022-04-04 | Carson | Texas | 48065 | 1527 | 34 |
2371996 | 2371996 | 2022-04-03 | Carson | Texas | 48065 | 1527 | 34 |
2368743 | 2368743 | 2022-04-02 | Carson | Texas | 48065 | 1527 | 34 |
2011196 | 2011196 | 2021-12-13 | Somervell | Texas | 48425 | 1527 | 25 |
2007945 | 2007945 | 2021-12-12 | Somervell | Texas | 48425 | 1527 | 25 |
1855159 | 1855159 | 2021-10-26 | Ochiltree | Texas | 48357 | 1527 | 37 |
1228389 | 1228389 | 2021-04-16 | Nolan | Texas | 48353 | 1527 | 51 |
1225141 | 1225141 | 2021-04-15 | Nolan | Texas | 48353 | 1527 | 51 |
1221894 | 1221894 | 2021-04-14 | Nolan | Texas | 48353 | 1527 | 51 |
1095260 | 1095260 | 2021-03-06 | Pecos | Texas | 48371 | 1527 | 34 |
1072399 | 1072399 | 2021-02-27 | Colorado | Texas | 48089 | 1527 | 25 |
1066008 | 1066008 | 2021-02-25 | Leon | Texas | 48289 | 1527 | 36 |
1059490 | 1059490 | 2021-02-23 | Hutchinson | Texas | 48233 | 1527 | 68 |
767490 | 767490 | 2020-11-25 | Scurry | Texas | 48415 | 1527 | 21 |
764245 | 764245 | 2020-11-24 | Scurry | Texas | 48415 | 1527 | 21 |
744733 | 744733 | 2020-11-18 | Moore | Texas | 48341 | 1527 | 26 |
744803 | 744803 | 2020-11-18 | Wharton | Texas | 48481 | 1527 | 62 |
647469 | 647469 | 2020-10-19 | Titus | Texas | 48449 | 1527 | 35 |
644223 | 644223 | 2020-10-18 | Titus | Texas | 48449 | 1527 | 35 |
640975 | 640975 | 2020-10-17 | Titus | Texas | 48449 | 1527 | 35 |
582411 | 582411 | 2020-09-29 | Caldwell | Texas | 48055 | 1527 | 35 |
495076 | 495076 | 2020-09-02 | Grayson | Texas | 48181 | 1527 | 28 |
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);