ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
93 rows where county = "Fulton", deaths = 1 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
389879 | 389879 | 2020-08-01 | Fulton | Indiana | 18049 | 140 | 1 |
386662 | 386662 | 2020-07-31 | Fulton | Indiana | 18049 | 135 | 1 |
383444 | 383444 | 2020-07-30 | Fulton | Indiana | 18049 | 130 | 1 |
380227 | 380227 | 2020-07-29 | Fulton | Indiana | 18049 | 125 | 1 |
377010 | 377010 | 2020-07-28 | Fulton | Indiana | 18049 | 122 | 1 |
373795 | 373795 | 2020-07-27 | Fulton | Indiana | 18049 | 119 | 1 |
370583 | 370583 | 2020-07-26 | Fulton | Indiana | 18049 | 109 | 1 |
367373 | 367373 | 2020-07-25 | Fulton | Indiana | 18049 | 108 | 1 |
364166 | 364166 | 2020-07-24 | Fulton | Indiana | 18049 | 105 | 1 |
360959 | 360959 | 2020-07-23 | Fulton | Indiana | 18049 | 102 | 1 |
357754 | 357754 | 2020-07-22 | Fulton | Indiana | 18049 | 100 | 1 |
351350 | 351350 | 2020-07-20 | Fulton | Indiana | 18049 | 91 | 1 |
348150 | 348150 | 2020-07-19 | Fulton | Indiana | 18049 | 89 | 1 |
344949 | 344949 | 2020-07-18 | Fulton | Indiana | 18049 | 86 | 1 |
341749 | 341749 | 2020-07-17 | Fulton | Indiana | 18049 | 84 | 1 |
338553 | 338553 | 2020-07-16 | Fulton | Indiana | 18049 | 83 | 1 |
335357 | 335357 | 2020-07-15 | Fulton | Indiana | 18049 | 81 | 1 |
332164 | 332164 | 2020-07-14 | Fulton | Indiana | 18049 | 79 | 1 |
328977 | 328977 | 2020-07-13 | Fulton | Indiana | 18049 | 76 | 1 |
325791 | 325791 | 2020-07-12 | Fulton | Indiana | 18049 | 73 | 1 |
322610 | 322610 | 2020-07-11 | Fulton | Indiana | 18049 | 73 | 1 |
319431 | 319431 | 2020-07-10 | Fulton | Indiana | 18049 | 73 | 1 |
316258 | 316258 | 2020-07-09 | Fulton | Indiana | 18049 | 73 | 1 |
313084 | 313084 | 2020-07-08 | Fulton | Indiana | 18049 | 72 | 1 |
309914 | 309914 | 2020-07-07 | Fulton | Indiana | 18049 | 71 | 1 |
306746 | 306746 | 2020-07-06 | Fulton | Indiana | 18049 | 72 | 1 |
303581 | 303581 | 2020-07-05 | Fulton | Indiana | 18049 | 70 | 1 |
300417 | 300417 | 2020-07-04 | Fulton | Indiana | 18049 | 69 | 1 |
297255 | 297255 | 2020-07-03 | Fulton | Indiana | 18049 | 68 | 1 |
294097 | 294097 | 2020-07-02 | Fulton | Indiana | 18049 | 66 | 1 |
290943 | 290943 | 2020-07-01 | Fulton | Indiana | 18049 | 66 | 1 |
287793 | 287793 | 2020-06-30 | Fulton | Indiana | 18049 | 66 | 1 |
284644 | 284644 | 2020-06-29 | Fulton | Indiana | 18049 | 65 | 1 |
281499 | 281499 | 2020-06-28 | Fulton | Indiana | 18049 | 65 | 1 |
278351 | 278351 | 2020-06-27 | Fulton | Indiana | 18049 | 65 | 1 |
275203 | 275203 | 2020-06-26 | Fulton | Indiana | 18049 | 64 | 1 |
272061 | 272061 | 2020-06-25 | Fulton | Indiana | 18049 | 64 | 1 |
268924 | 268924 | 2020-06-24 | Fulton | Indiana | 18049 | 64 | 1 |
265794 | 265794 | 2020-06-23 | Fulton | Indiana | 18049 | 63 | 1 |
262666 | 262666 | 2020-06-22 | Fulton | Indiana | 18049 | 62 | 1 |
259539 | 259539 | 2020-06-21 | Fulton | Indiana | 18049 | 62 | 1 |
256413 | 256413 | 2020-06-20 | Fulton | Indiana | 18049 | 61 | 1 |
253293 | 253293 | 2020-06-19 | Fulton | Indiana | 18049 | 60 | 1 |
250178 | 250178 | 2020-06-18 | Fulton | Indiana | 18049 | 58 | 1 |
247066 | 247066 | 2020-06-17 | Fulton | Indiana | 18049 | 56 | 1 |
243953 | 243953 | 2020-06-16 | Fulton | Indiana | 18049 | 56 | 1 |
240842 | 240842 | 2020-06-15 | Fulton | Indiana | 18049 | 55 | 1 |
237734 | 237734 | 2020-06-14 | Fulton | Indiana | 18049 | 55 | 1 |
234627 | 234627 | 2020-06-13 | Fulton | Indiana | 18049 | 53 | 1 |
231521 | 231521 | 2020-06-12 | Fulton | Indiana | 18049 | 53 | 1 |
228418 | 228418 | 2020-06-11 | Fulton | Indiana | 18049 | 52 | 1 |
225316 | 225316 | 2020-06-10 | Fulton | Indiana | 18049 | 51 | 1 |
222221 | 222221 | 2020-06-09 | Fulton | Indiana | 18049 | 51 | 1 |
219126 | 219126 | 2020-06-08 | Fulton | Indiana | 18049 | 51 | 1 |
216034 | 216034 | 2020-06-07 | Fulton | Indiana | 18049 | 51 | 1 |
212947 | 212947 | 2020-06-06 | Fulton | Indiana | 18049 | 51 | 1 |
209862 | 209862 | 2020-06-05 | Fulton | Indiana | 18049 | 51 | 1 |
206781 | 206781 | 2020-06-04 | Fulton | Indiana | 18049 | 50 | 1 |
203701 | 203701 | 2020-06-03 | Fulton | Indiana | 18049 | 50 | 1 |
200625 | 200625 | 2020-06-02 | Fulton | Indiana | 18049 | 49 | 1 |
197552 | 197552 | 2020-06-01 | Fulton | Indiana | 18049 | 49 | 1 |
194482 | 194482 | 2020-05-31 | Fulton | Indiana | 18049 | 49 | 1 |
191415 | 191415 | 2020-05-30 | Fulton | Indiana | 18049 | 49 | 1 |
188350 | 188350 | 2020-05-29 | Fulton | Indiana | 18049 | 48 | 1 |
185292 | 185292 | 2020-05-28 | Fulton | Indiana | 18049 | 47 | 1 |
182238 | 182238 | 2020-05-27 | Fulton | Indiana | 18049 | 47 | 1 |
179194 | 179194 | 2020-05-26 | Fulton | Indiana | 18049 | 47 | 1 |
176150 | 176150 | 2020-05-25 | Fulton | Indiana | 18049 | 47 | 1 |
173106 | 173106 | 2020-05-24 | Fulton | Indiana | 18049 | 46 | 1 |
170065 | 170065 | 2020-05-23 | Fulton | Indiana | 18049 | 46 | 1 |
167028 | 167028 | 2020-05-22 | Fulton | Indiana | 18049 | 46 | 1 |
163995 | 163995 | 2020-05-21 | Fulton | Indiana | 18049 | 46 | 1 |
160967 | 160967 | 2020-05-20 | Fulton | Indiana | 18049 | 47 | 1 |
157941 | 157941 | 2020-05-19 | Fulton | Indiana | 18049 | 45 | 1 |
154925 | 154925 | 2020-05-18 | Fulton | Indiana | 18049 | 44 | 1 |
151913 | 151913 | 2020-05-17 | Fulton | Indiana | 18049 | 43 | 1 |
148904 | 148904 | 2020-05-16 | Fulton | Indiana | 18049 | 42 | 1 |
145900 | 145900 | 2020-05-15 | Fulton | Indiana | 18049 | 39 | 1 |
142900 | 142900 | 2020-05-14 | Fulton | Indiana | 18049 | 39 | 1 |
139904 | 139904 | 2020-05-13 | Fulton | Indiana | 18049 | 37 | 1 |
136912 | 136912 | 2020-05-12 | Fulton | Indiana | 18049 | 37 | 1 |
133923 | 133923 | 2020-05-11 | Fulton | Indiana | 18049 | 36 | 1 |
130933 | 130933 | 2020-05-10 | Fulton | Indiana | 18049 | 36 | 1 |
127942 | 127942 | 2020-05-09 | Fulton | Indiana | 18049 | 36 | 1 |
124955 | 124955 | 2020-05-08 | Fulton | Indiana | 18049 | 34 | 1 |
121975 | 121975 | 2020-05-07 | Fulton | Indiana | 18049 | 34 | 1 |
119005 | 119005 | 2020-05-06 | Fulton | Indiana | 18049 | 34 | 1 |
116045 | 116045 | 2020-05-05 | Fulton | Indiana | 18049 | 34 | 1 |
113162 | 113162 | 2020-05-04 | Fulton | Indiana | 18049 | 33 | 1 |
110287 | 110287 | 2020-05-03 | Fulton | Indiana | 18049 | 33 | 1 |
107417 | 107417 | 2020-05-02 | Fulton | Indiana | 18049 | 31 | 1 |
104552 | 104552 | 2020-05-01 | Fulton | Indiana | 18049 | 30 | 1 |
101696 | 101696 | 2020-04-30 | Fulton | Indiana | 18049 | 27 | 1 |
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);