ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
193,519 rows where state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
- 48029 822
- 48157 801
- 48201 800
- 48085 796
- 48113 795
- 48339 795
- 48439 795
- 48183 794
- 48027 792
- 48141 792
- 48167 792
- 48423 792
- 48453 792
- 48039 791
- 48209 791
- 48121 790
- 48037 789
- 48321 789
- 48041 788
- 48139 788
- 48303 788
- 48285 787
- 48309 787
- 48325 787
- 48401 787
- 48479 787
- 48485 787
- 48491 787
- 48061 786
- 48103 786
- …
county >30
- Bexar 822
- Fort Bend 801
- Harris 800
- Collin 796
- Dallas 795
- Montgomery 795
- Tarrant 795
- Gregg 794
- Bell 792
- El Paso 792
- Galveston 792
- Smith 792
- Travis 792
- Brazoria 791
- Hays 791
- Denton 790
- Bowie 789
- Matagorda 789
- Brazos 788
- Ellis 788
- Lubbock 788
- Lavaca 787
- McLennan 787
- Medina 787
- Rusk 787
- Webb 787
- Wichita 787
- Williamson 787
- Cameron 786
- Crane 786
- …
state 1
- Texas · 193,519 ✖
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
25709 | 25709 | 2020-04-01 | Anderson | Texas | 48001 | 1 | 0 |
27989 | 27989 | 2020-04-02 | Anderson | Texas | 48001 | 1 | 0 |
30324 | 30324 | 2020-04-03 | Anderson | Texas | 48001 | 1 | 0 |
32716 | 32716 | 2020-04-04 | Anderson | Texas | 48001 | 1 | 0 |
35153 | 35153 | 2020-04-05 | Anderson | Texas | 48001 | 1 | 0 |
37629 | 37629 | 2020-04-06 | Anderson | Texas | 48001 | 1 | 0 |
40151 | 40151 | 2020-04-07 | Anderson | Texas | 48001 | 1 | 0 |
42713 | 42713 | 2020-04-08 | Anderson | Texas | 48001 | 1 | 0 |
45301 | 45301 | 2020-04-09 | Anderson | Texas | 48001 | 2 | 0 |
47919 | 47919 | 2020-04-10 | Anderson | Texas | 48001 | 3 | 0 |
50576 | 50576 | 2020-04-11 | Anderson | Texas | 48001 | 3 | 0 |
53251 | 53251 | 2020-04-12 | Anderson | Texas | 48001 | 3 | 0 |
55939 | 55939 | 2020-04-13 | Anderson | Texas | 48001 | 3 | 0 |
58642 | 58642 | 2020-04-14 | Anderson | Texas | 48001 | 3 | 0 |
61358 | 61358 | 2020-04-15 | Anderson | Texas | 48001 | 4 | 0 |
64085 | 64085 | 2020-04-16 | Anderson | Texas | 48001 | 6 | 0 |
66832 | 66832 | 2020-04-17 | Anderson | Texas | 48001 | 6 | 0 |
69591 | 69591 | 2020-04-18 | Anderson | Texas | 48001 | 6 | 0 |
72358 | 72358 | 2020-04-19 | Anderson | Texas | 48001 | 8 | 0 |
75133 | 75133 | 2020-04-20 | Anderson | Texas | 48001 | 8 | 0 |
77915 | 77915 | 2020-04-21 | Anderson | Texas | 48001 | 10 | 0 |
80705 | 80705 | 2020-04-22 | Anderson | Texas | 48001 | 14 | 0 |
83504 | 83504 | 2020-04-23 | Anderson | Texas | 48001 | 14 | 0 |
86309 | 86309 | 2020-04-24 | Anderson | Texas | 48001 | 16 | 0 |
89124 | 89124 | 2020-04-25 | Anderson | Texas | 48001 | 16 | 0 |
91941 | 91941 | 2020-04-26 | Anderson | Texas | 48001 | 18 | 0 |
94769 | 94769 | 2020-04-27 | Anderson | Texas | 48001 | 19 | 0 |
97609 | 97609 | 2020-04-28 | Anderson | Texas | 48001 | 23 | 0 |
100459 | 100459 | 2020-04-29 | Anderson | Texas | 48001 | 23 | 0 |
103312 | 103312 | 2020-04-30 | Anderson | Texas | 48001 | 29 | 0 |
106175 | 106175 | 2020-05-01 | Anderson | Texas | 48001 | 30 | 0 |
109042 | 109042 | 2020-05-02 | Anderson | Texas | 48001 | 32 | 0 |
111916 | 111916 | 2020-05-03 | Anderson | Texas | 48001 | 32 | 0 |
114798 | 114798 | 2020-05-04 | Anderson | Texas | 48001 | 32 | 0 |
117754 | 117754 | 2020-05-05 | Anderson | Texas | 48001 | 34 | 0 |
120718 | 120718 | 2020-05-06 | Anderson | Texas | 48001 | 38 | 0 |
123697 | 123697 | 2020-05-07 | Anderson | Texas | 48001 | 40 | 0 |
126680 | 126680 | 2020-05-08 | Anderson | Texas | 48001 | 41 | 0 |
129669 | 129669 | 2020-05-09 | Anderson | Texas | 48001 | 41 | 0 |
132659 | 132659 | 2020-05-10 | Anderson | Texas | 48001 | 41 | 0 |
135650 | 135650 | 2020-05-11 | Anderson | Texas | 48001 | 41 | 0 |
138640 | 138640 | 2020-05-12 | Anderson | Texas | 48001 | 50 | 0 |
141636 | 141636 | 2020-05-13 | Anderson | Texas | 48001 | 50 | 0 |
144633 | 144633 | 2020-05-14 | Anderson | Texas | 48001 | 51 | 0 |
147634 | 147634 | 2020-05-15 | Anderson | Texas | 48001 | 52 | 0 |
150642 | 150642 | 2020-05-16 | Anderson | Texas | 48001 | 54 | 0 |
153653 | 153653 | 2020-05-17 | Anderson | Texas | 48001 | 54 | 0 |
156670 | 156670 | 2020-05-18 | Anderson | Texas | 48001 | 54 | 0 |
159692 | 159692 | 2020-05-19 | Anderson | Texas | 48001 | 60 | 0 |
162719 | 162719 | 2020-05-20 | Anderson | Texas | 48001 | 61 | 0 |
165748 | 165748 | 2020-05-21 | Anderson | Texas | 48001 | 63 | 0 |
168784 | 168784 | 2020-05-22 | Anderson | Texas | 48001 | 63 | 0 |
171823 | 171823 | 2020-05-23 | Anderson | Texas | 48001 | 66 | 0 |
174866 | 174866 | 2020-05-24 | Anderson | Texas | 48001 | 66 | 0 |
177910 | 177910 | 2020-05-25 | Anderson | Texas | 48001 | 66 | 0 |
180953 | 180953 | 2020-05-26 | Anderson | Texas | 48001 | 66 | 0 |
184003 | 184003 | 2020-05-27 | Anderson | Texas | 48001 | 66 | 0 |
187060 | 187060 | 2020-05-28 | Anderson | Texas | 48001 | 66 | 0 |
190124 | 190124 | 2020-05-29 | Anderson | Texas | 48001 | 72 | 0 |
193189 | 193189 | 2020-05-30 | Anderson | Texas | 48001 | 72 | 0 |
196259 | 196259 | 2020-05-31 | Anderson | Texas | 48001 | 72 | 0 |
199332 | 199332 | 2020-06-01 | Anderson | Texas | 48001 | 72 | 0 |
202407 | 202407 | 2020-06-02 | Anderson | Texas | 48001 | 76 | 0 |
205486 | 205486 | 2020-06-03 | Anderson | Texas | 48001 | 78 | 0 |
208568 | 208568 | 2020-06-04 | Anderson | Texas | 48001 | 85 | 0 |
211650 | 211650 | 2020-06-05 | Anderson | Texas | 48001 | 87 | 0 |
214737 | 214737 | 2020-06-06 | Anderson | Texas | 48001 | 85 | 0 |
217827 | 217827 | 2020-06-07 | Anderson | Texas | 48001 | 85 | 0 |
220919 | 220919 | 2020-06-08 | Anderson | Texas | 48001 | 85 | 0 |
224014 | 224014 | 2020-06-09 | Anderson | Texas | 48001 | 91 | 0 |
227114 | 227114 | 2020-06-10 | Anderson | Texas | 48001 | 91 | 0 |
230218 | 230218 | 2020-06-11 | Anderson | Texas | 48001 | 95 | 0 |
233322 | 233322 | 2020-06-12 | Anderson | Texas | 48001 | 95 | 0 |
236428 | 236428 | 2020-06-13 | Anderson | Texas | 48001 | 102 | 0 |
239536 | 239536 | 2020-06-14 | Anderson | Texas | 48001 | 102 | 0 |
242646 | 242646 | 2020-06-15 | Anderson | Texas | 48001 | 102 | 0 |
245758 | 245758 | 2020-06-16 | Anderson | Texas | 48001 | 989 | 2 |
248871 | 248871 | 2020-06-17 | Anderson | Texas | 48001 | 990 | 2 |
251986 | 251986 | 2020-06-18 | Anderson | Texas | 48001 | 1003 | 2 |
255101 | 255101 | 2020-06-19 | Anderson | Texas | 48001 | 1007 | 2 |
258227 | 258227 | 2020-06-20 | Anderson | Texas | 48001 | 1006 | 2 |
261354 | 261354 | 2020-06-21 | Anderson | Texas | 48001 | 1006 | 2 |
264482 | 264482 | 2020-06-22 | Anderson | Texas | 48001 | 1006 | 2 |
267610 | 267610 | 2020-06-23 | Anderson | Texas | 48001 | 1009 | 2 |
270744 | 270744 | 2020-06-24 | Anderson | Texas | 48001 | 1013 | 2 |
273883 | 273883 | 2020-06-25 | Anderson | Texas | 48001 | 1014 | 2 |
277030 | 277030 | 2020-06-26 | Anderson | Texas | 48001 | 1017 | 2 |
280178 | 280178 | 2020-06-27 | Anderson | Texas | 48001 | 1017 | 2 |
283324 | 283324 | 2020-06-28 | Anderson | Texas | 48001 | 1016 | 2 |
286470 | 286470 | 2020-06-29 | Anderson | Texas | 48001 | 1016 | 2 |
289620 | 289620 | 2020-06-30 | Anderson | Texas | 48001 | 1032 | 2 |
292773 | 292773 | 2020-07-01 | Anderson | Texas | 48001 | 1040 | 2 |
295928 | 295928 | 2020-07-02 | Anderson | Texas | 48001 | 1063 | 2 |
299088 | 299088 | 2020-07-03 | Anderson | Texas | 48001 | 1072 | 2 |
302252 | 302252 | 2020-07-04 | Anderson | Texas | 48001 | 1070 | 2 |
305416 | 305416 | 2020-07-05 | Anderson | Texas | 48001 | 1082 | 2 |
308584 | 308584 | 2020-07-06 | Anderson | Texas | 48001 | 1082 | 2 |
311753 | 311753 | 2020-07-07 | Anderson | Texas | 48001 | 1108 | 2 |
314927 | 314927 | 2020-07-08 | Anderson | Texas | 48001 | 1152 | 3 |
318100 | 318100 | 2020-07-09 | Anderson | Texas | 48001 | 1533 | 3 |
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);