ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Fayette" and fips = 48149 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388609 | 388609 | 2020-07-31 | Fayette | Texas | 48149 | 299 | 13 |
385392 | 385392 | 2020-07-30 | Fayette | Texas | 48149 | 297 | 13 |
382174 | 382174 | 2020-07-29 | Fayette | Texas | 48149 | 296 | 13 |
378957 | 378957 | 2020-07-28 | Fayette | Texas | 48149 | 291 | 13 |
375741 | 375741 | 2020-07-27 | Fayette | Texas | 48149 | 281 | 12 |
372528 | 372528 | 2020-07-26 | Fayette | Texas | 48149 | 281 | 5 |
369316 | 369316 | 2020-07-25 | Fayette | Texas | 48149 | 281 | 5 |
366107 | 366107 | 2020-07-24 | Fayette | Texas | 48149 | 275 | 5 |
362901 | 362901 | 2020-07-23 | Fayette | Texas | 48149 | 270 | 5 |
359694 | 359694 | 2020-07-22 | Fayette | Texas | 48149 | 253 | 5 |
356489 | 356489 | 2020-07-21 | Fayette | Texas | 48149 | 224 | 4 |
353286 | 353286 | 2020-07-20 | Fayette | Texas | 48149 | 216 | 4 |
350084 | 350084 | 2020-07-19 | Fayette | Texas | 48149 | 217 | 4 |
346884 | 346884 | 2020-07-18 | Fayette | Texas | 48149 | 206 | 4 |
343684 | 343684 | 2020-07-17 | Fayette | Texas | 48149 | 206 | 4 |
340485 | 340485 | 2020-07-16 | Fayette | Texas | 48149 | 197 | 4 |
337289 | 337289 | 2020-07-15 | Fayette | Texas | 48149 | 179 | 4 |
334094 | 334094 | 2020-07-14 | Fayette | Texas | 48149 | 174 | 4 |
330903 | 330903 | 2020-07-13 | Fayette | Texas | 48149 | 158 | 4 |
327717 | 327717 | 2020-07-12 | Fayette | Texas | 48149 | 156 | 3 |
324532 | 324532 | 2020-07-11 | Fayette | Texas | 48149 | 151 | 3 |
321351 | 321351 | 2020-07-10 | Fayette | Texas | 48149 | 142 | 3 |
318173 | 318173 | 2020-07-09 | Fayette | Texas | 48149 | 136 | 3 |
315000 | 315000 | 2020-07-08 | Fayette | Texas | 48149 | 134 | 3 |
311826 | 311826 | 2020-07-07 | Fayette | Texas | 48149 | 104 | 3 |
308657 | 308657 | 2020-07-06 | Fayette | Texas | 48149 | 104 | 3 |
305489 | 305489 | 2020-07-05 | Fayette | Texas | 48149 | 104 | 3 |
302325 | 302325 | 2020-07-04 | Fayette | Texas | 48149 | 104 | 3 |
299161 | 299161 | 2020-07-03 | Fayette | Texas | 48149 | 96 | 2 |
296001 | 296001 | 2020-07-02 | Fayette | Texas | 48149 | 95 | 2 |
292846 | 292846 | 2020-07-01 | Fayette | Texas | 48149 | 90 | 2 |
289693 | 289693 | 2020-06-30 | Fayette | Texas | 48149 | 86 | 2 |
286543 | 286543 | 2020-06-29 | Fayette | Texas | 48149 | 86 | 2 |
283397 | 283397 | 2020-06-28 | Fayette | Texas | 48149 | 80 | 2 |
280251 | 280251 | 2020-06-27 | Fayette | Texas | 48149 | 75 | 2 |
277103 | 277103 | 2020-06-26 | Fayette | Texas | 48149 | 75 | 2 |
273956 | 273956 | 2020-06-25 | Fayette | Texas | 48149 | 76 | 2 |
270816 | 270816 | 2020-06-24 | Fayette | Texas | 48149 | 75 | 2 |
267682 | 267682 | 2020-06-23 | Fayette | Texas | 48149 | 71 | 2 |
264554 | 264554 | 2020-06-22 | Fayette | Texas | 48149 | 66 | 2 |
261426 | 261426 | 2020-06-21 | Fayette | Texas | 48149 | 60 | 2 |
258299 | 258299 | 2020-06-20 | Fayette | Texas | 48149 | 58 | 2 |
255172 | 255172 | 2020-06-19 | Fayette | Texas | 48149 | 52 | 2 |
252057 | 252057 | 2020-06-18 | Fayette | Texas | 48149 | 51 | 2 |
248942 | 248942 | 2020-06-17 | Fayette | Texas | 48149 | 52 | 2 |
245829 | 245829 | 2020-06-16 | Fayette | Texas | 48149 | 45 | 2 |
242717 | 242717 | 2020-06-15 | Fayette | Texas | 48149 | 44 | 2 |
239607 | 239607 | 2020-06-14 | Fayette | Texas | 48149 | 44 | 2 |
236499 | 236499 | 2020-06-13 | Fayette | Texas | 48149 | 43 | 2 |
233393 | 233393 | 2020-06-12 | Fayette | Texas | 48149 | 44 | 2 |
230289 | 230289 | 2020-06-11 | Fayette | Texas | 48149 | 43 | 2 |
227185 | 227185 | 2020-06-10 | Fayette | Texas | 48149 | 39 | 2 |
224085 | 224085 | 2020-06-09 | Fayette | Texas | 48149 | 38 | 2 |
220990 | 220990 | 2020-06-08 | Fayette | Texas | 48149 | 38 | 2 |
217898 | 217898 | 2020-06-07 | Fayette | Texas | 48149 | 38 | 2 |
214808 | 214808 | 2020-06-06 | Fayette | Texas | 48149 | 38 | 2 |
211721 | 211721 | 2020-06-05 | Fayette | Texas | 48149 | 38 | 2 |
208637 | 208637 | 2020-06-04 | Fayette | Texas | 48149 | 38 | 2 |
205555 | 205555 | 2020-06-03 | Fayette | Texas | 48149 | 36 | 2 |
202476 | 202476 | 2020-06-02 | Fayette | Texas | 48149 | 34 | 2 |
199401 | 199401 | 2020-06-01 | Fayette | Texas | 48149 | 34 | 2 |
196328 | 196328 | 2020-05-31 | Fayette | Texas | 48149 | 34 | 2 |
193258 | 193258 | 2020-05-30 | Fayette | Texas | 48149 | 34 | 2 |
190193 | 190193 | 2020-05-29 | Fayette | Texas | 48149 | 34 | 2 |
187129 | 187129 | 2020-05-28 | Fayette | Texas | 48149 | 34 | 2 |
184072 | 184072 | 2020-05-27 | Fayette | Texas | 48149 | 32 | 2 |
181022 | 181022 | 2020-05-26 | Fayette | Texas | 48149 | 32 | 2 |
177979 | 177979 | 2020-05-25 | Fayette | Texas | 48149 | 32 | 2 |
174935 | 174935 | 2020-05-24 | Fayette | Texas | 48149 | 32 | 2 |
171892 | 171892 | 2020-05-23 | Fayette | Texas | 48149 | 32 | 2 |
168853 | 168853 | 2020-05-22 | Fayette | Texas | 48149 | 31 | 2 |
165817 | 165817 | 2020-05-21 | Fayette | Texas | 48149 | 31 | 2 |
162788 | 162788 | 2020-05-20 | Fayette | Texas | 48149 | 31 | 2 |
159761 | 159761 | 2020-05-19 | Fayette | Texas | 48149 | 31 | 2 |
156739 | 156739 | 2020-05-18 | Fayette | Texas | 48149 | 29 | 2 |
153722 | 153722 | 2020-05-17 | Fayette | Texas | 48149 | 29 | 2 |
150711 | 150711 | 2020-05-16 | Fayette | Texas | 48149 | 29 | 2 |
147703 | 147703 | 2020-05-15 | Fayette | Texas | 48149 | 26 | 2 |
144701 | 144701 | 2020-05-14 | Fayette | Texas | 48149 | 28 | 2 |
141704 | 141704 | 2020-05-13 | Fayette | Texas | 48149 | 26 | 1 |
138708 | 138708 | 2020-05-12 | Fayette | Texas | 48149 | 26 | 1 |
135718 | 135718 | 2020-05-11 | Fayette | Texas | 48149 | 25 | 1 |
132727 | 132727 | 2020-05-10 | Fayette | Texas | 48149 | 25 | 1 |
129737 | 129737 | 2020-05-09 | Fayette | Texas | 48149 | 24 | 1 |
126748 | 126748 | 2020-05-08 | Fayette | Texas | 48149 | 21 | 1 |
123765 | 123765 | 2020-05-07 | Fayette | Texas | 48149 | 19 | 1 |
120786 | 120786 | 2020-05-06 | Fayette | Texas | 48149 | 17 | 1 |
117822 | 117822 | 2020-05-05 | Fayette | Texas | 48149 | 17 | 1 |
114863 | 114863 | 2020-05-04 | Fayette | Texas | 48149 | 15 | 1 |
111981 | 111981 | 2020-05-03 | Fayette | Texas | 48149 | 15 | 1 |
109107 | 109107 | 2020-05-02 | Fayette | Texas | 48149 | 15 | 1 |
106238 | 106238 | 2020-05-01 | Fayette | Texas | 48149 | 15 | 1 |
103374 | 103374 | 2020-04-30 | Fayette | Texas | 48149 | 15 | 1 |
100521 | 100521 | 2020-04-29 | Fayette | Texas | 48149 | 15 | 1 |
97671 | 97671 | 2020-04-28 | Fayette | Texas | 48149 | 15 | 1 |
94831 | 94831 | 2020-04-27 | Fayette | Texas | 48149 | 15 | 1 |
92002 | 92002 | 2020-04-26 | Fayette | Texas | 48149 | 15 | 1 |
89185 | 89185 | 2020-04-25 | Fayette | Texas | 48149 | 15 | 1 |
86370 | 86370 | 2020-04-24 | Fayette | Texas | 48149 | 15 | 1 |
83565 | 83565 | 2020-04-23 | Fayette | Texas | 48149 | 15 | 0 |
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);