ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 48037 and state = "Texas" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
3138 | 3138 | 2020-03-16 | Bowie | Texas | 48037 | 1 | 0 |
3671 | 3671 | 2020-03-17 | Bowie | Texas | 48037 | 1 | 0 |
4294 | 4294 | 2020-03-18 | Bowie | Texas | 48037 | 1 | 0 |
5045 | 5045 | 2020-03-19 | Bowie | Texas | 48037 | 1 | 0 |
5934 | 5934 | 2020-03-20 | Bowie | Texas | 48037 | 1 | 0 |
6952 | 6952 | 2020-03-21 | Bowie | Texas | 48037 | 1 | 0 |
8082 | 8082 | 2020-03-22 | Bowie | Texas | 48037 | 1 | 0 |
9300 | 9300 | 2020-03-23 | Bowie | Texas | 48037 | 1 | 0 |
10634 | 10634 | 2020-03-24 | Bowie | Texas | 48037 | 1 | 0 |
12117 | 12117 | 2020-03-25 | Bowie | Texas | 48037 | 1 | 0 |
13745 | 13745 | 2020-03-26 | Bowie | Texas | 48037 | 1 | 0 |
15498 | 15498 | 2020-03-27 | Bowie | Texas | 48037 | 2 | 0 |
17365 | 17365 | 2020-03-28 | Bowie | Texas | 48037 | 3 | 0 |
19315 | 19315 | 2020-03-29 | Bowie | Texas | 48037 | 3 | 0 |
21374 | 21374 | 2020-03-30 | Bowie | Texas | 48037 | 4 | 0 |
23513 | 23513 | 2020-03-31 | Bowie | Texas | 48037 | 9 | 0 |
25717 | 25717 | 2020-04-01 | Bowie | Texas | 48037 | 9 | 0 |
27997 | 27997 | 2020-04-02 | Bowie | Texas | 48037 | 9 | 0 |
30332 | 30332 | 2020-04-03 | Bowie | Texas | 48037 | 10 | 0 |
32725 | 32725 | 2020-04-04 | Bowie | Texas | 48037 | 17 | 1 |
35163 | 35163 | 2020-04-05 | Bowie | Texas | 48037 | 17 | 1 |
37639 | 37639 | 2020-04-06 | Bowie | Texas | 48037 | 27 | 5 |
40161 | 40161 | 2020-04-07 | Bowie | Texas | 48037 | 27 | 5 |
42724 | 42724 | 2020-04-08 | Bowie | Texas | 48037 | 35 | 5 |
45313 | 45313 | 2020-04-09 | Bowie | Texas | 48037 | 35 | 5 |
47931 | 47931 | 2020-04-10 | Bowie | Texas | 48037 | 35 | 5 |
50588 | 50588 | 2020-04-11 | Bowie | Texas | 48037 | 35 | 5 |
53263 | 53263 | 2020-04-12 | Bowie | Texas | 48037 | 35 | 5 |
55951 | 55951 | 2020-04-13 | Bowie | Texas | 48037 | 51 | 5 |
58655 | 58655 | 2020-04-14 | Bowie | Texas | 48037 | 54 | 5 |
61372 | 61372 | 2020-04-15 | Bowie | Texas | 48037 | 63 | 5 |
64099 | 64099 | 2020-04-16 | Bowie | Texas | 48037 | 71 | 5 |
66846 | 66846 | 2020-04-17 | Bowie | Texas | 48037 | 76 | 5 |
69605 | 69605 | 2020-04-18 | Bowie | Texas | 48037 | 76 | 5 |
72372 | 72372 | 2020-04-19 | Bowie | Texas | 48037 | 76 | 5 |
75147 | 75147 | 2020-04-20 | Bowie | Texas | 48037 | 83 | 6 |
77929 | 77929 | 2020-04-21 | Bowie | Texas | 48037 | 88 | 6 |
80719 | 80719 | 2020-04-22 | Bowie | Texas | 48037 | 88 | 6 |
83518 | 83518 | 2020-04-23 | Bowie | Texas | 48037 | 89 | 6 |
86323 | 86323 | 2020-04-24 | Bowie | Texas | 48037 | 93 | 6 |
89138 | 89138 | 2020-04-25 | Bowie | Texas | 48037 | 93 | 7 |
91955 | 91955 | 2020-04-26 | Bowie | Texas | 48037 | 93 | 7 |
94783 | 94783 | 2020-04-27 | Bowie | Texas | 48037 | 94 | 8 |
97623 | 97623 | 2020-04-28 | Bowie | Texas | 48037 | 94 | 8 |
100473 | 100473 | 2020-04-29 | Bowie | Texas | 48037 | 95 | 8 |
103326 | 103326 | 2020-04-30 | Bowie | Texas | 48037 | 99 | 9 |
106189 | 106189 | 2020-05-01 | Bowie | Texas | 48037 | 101 | 9 |
109056 | 109056 | 2020-05-02 | Bowie | Texas | 48037 | 101 | 9 |
111930 | 111930 | 2020-05-03 | Bowie | Texas | 48037 | 101 | 9 |
114812 | 114812 | 2020-05-04 | Bowie | Texas | 48037 | 103 | 10 |
117769 | 117769 | 2020-05-05 | Bowie | Texas | 48037 | 104 | 10 |
120733 | 120733 | 2020-05-06 | Bowie | Texas | 48037 | 105 | 10 |
123712 | 123712 | 2020-05-07 | Bowie | Texas | 48037 | 105 | 10 |
126695 | 126695 | 2020-05-08 | Bowie | Texas | 48037 | 105 | 10 |
129684 | 129684 | 2020-05-09 | Bowie | Texas | 48037 | 105 | 10 |
132674 | 132674 | 2020-05-10 | Bowie | Texas | 48037 | 105 | 10 |
135665 | 135665 | 2020-05-11 | Bowie | Texas | 48037 | 107 | 11 |
138655 | 138655 | 2020-05-12 | Bowie | Texas | 48037 | 110 | 11 |
141651 | 141651 | 2020-05-13 | Bowie | Texas | 48037 | 111 | 11 |
144648 | 144648 | 2020-05-14 | Bowie | Texas | 48037 | 120 | 11 |
147650 | 147650 | 2020-05-15 | Bowie | Texas | 48037 | 122 | 11 |
150658 | 150658 | 2020-05-16 | Bowie | Texas | 48037 | 130 | 11 |
153669 | 153669 | 2020-05-17 | Bowie | Texas | 48037 | 133 | 11 |
156686 | 156686 | 2020-05-18 | Bowie | Texas | 48037 | 133 | 11 |
159708 | 159708 | 2020-05-19 | Bowie | Texas | 48037 | 137 | 11 |
162735 | 162735 | 2020-05-20 | Bowie | Texas | 48037 | 174 | 11 |
165764 | 165764 | 2020-05-21 | Bowie | Texas | 48037 | 176 | 11 |
168800 | 168800 | 2020-05-22 | Bowie | Texas | 48037 | 176 | 11 |
171839 | 171839 | 2020-05-23 | Bowie | Texas | 48037 | 176 | 11 |
174882 | 174882 | 2020-05-24 | Bowie | Texas | 48037 | 153 | 11 |
177926 | 177926 | 2020-05-25 | Bowie | Texas | 48037 | 153 | 11 |
180969 | 180969 | 2020-05-26 | Bowie | Texas | 48037 | 147 | 12 |
184019 | 184019 | 2020-05-27 | Bowie | Texas | 48037 | 156 | 12 |
187076 | 187076 | 2020-05-28 | Bowie | Texas | 48037 | 189 | 12 |
190140 | 190140 | 2020-05-29 | Bowie | Texas | 48037 | 191 | 12 |
193205 | 193205 | 2020-05-30 | Bowie | Texas | 48037 | 197 | 12 |
196275 | 196275 | 2020-05-31 | Bowie | Texas | 48037 | 265 | 12 |
199348 | 199348 | 2020-06-01 | Bowie | Texas | 48037 | 267 | 12 |
202423 | 202423 | 2020-06-02 | Bowie | Texas | 48037 | 270 | 13 |
205502 | 205502 | 2020-06-03 | Bowie | Texas | 48037 | 287 | 13 |
208584 | 208584 | 2020-06-04 | Bowie | Texas | 48037 | 296 | 13 |
211667 | 211667 | 2020-06-05 | Bowie | Texas | 48037 | 301 | 13 |
214754 | 214754 | 2020-06-06 | Bowie | Texas | 48037 | 312 | 13 |
217844 | 217844 | 2020-06-07 | Bowie | Texas | 48037 | 336 | 13 |
220936 | 220936 | 2020-06-08 | Bowie | Texas | 48037 | 336 | 13 |
224031 | 224031 | 2020-06-09 | Bowie | Texas | 48037 | 351 | 13 |
227131 | 227131 | 2020-06-10 | Bowie | Texas | 48037 | 358 | 13 |
230235 | 230235 | 2020-06-11 | Bowie | Texas | 48037 | 363 | 13 |
233339 | 233339 | 2020-06-12 | Bowie | Texas | 48037 | 367 | 13 |
236445 | 236445 | 2020-06-13 | Bowie | Texas | 48037 | 370 | 13 |
239553 | 239553 | 2020-06-14 | Bowie | Texas | 48037 | 373 | 13 |
242663 | 242663 | 2020-06-15 | Bowie | Texas | 48037 | 372 | 13 |
245775 | 245775 | 2020-06-16 | Bowie | Texas | 48037 | 377 | 13 |
248888 | 248888 | 2020-06-17 | Bowie | Texas | 48037 | 381 | 13 |
252003 | 252003 | 2020-06-18 | Bowie | Texas | 48037 | 384 | 13 |
255118 | 255118 | 2020-06-19 | Bowie | Texas | 48037 | 394 | 15 |
258244 | 258244 | 2020-06-20 | Bowie | Texas | 48037 | 398 | 15 |
261371 | 261371 | 2020-06-21 | Bowie | Texas | 48037 | 400 | 15 |
264499 | 264499 | 2020-06-22 | Bowie | Texas | 48037 | 400 | 15 |
267627 | 267627 | 2020-06-23 | Bowie | Texas | 48037 | 404 | 16 |
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);