ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where fips = 18055 and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
18184 | 18184 | 2020-03-29 | Greene | Indiana | 18055 | 1 | 0 |
20190 | 20190 | 2020-03-30 | Greene | Indiana | 18055 | 1 | 0 |
22284 | 22284 | 2020-03-31 | Greene | Indiana | 18055 | 2 | 0 |
24454 | 24454 | 2020-04-01 | Greene | Indiana | 18055 | 3 | 0 |
26693 | 26693 | 2020-04-02 | Greene | Indiana | 18055 | 8 | 0 |
29003 | 29003 | 2020-04-03 | Greene | Indiana | 18055 | 9 | 0 |
31369 | 31369 | 2020-04-04 | Greene | Indiana | 18055 | 9 | 0 |
33780 | 33780 | 2020-04-05 | Greene | Indiana | 18055 | 10 | 0 |
36233 | 36233 | 2020-04-06 | Greene | Indiana | 18055 | 11 | 0 |
38731 | 38731 | 2020-04-07 | Greene | Indiana | 18055 | 11 | 0 |
41277 | 41277 | 2020-04-08 | Greene | Indiana | 18055 | 12 | 0 |
43853 | 43853 | 2020-04-09 | Greene | Indiana | 18055 | 12 | 0 |
46457 | 46457 | 2020-04-10 | Greene | Indiana | 18055 | 14 | 1 |
49091 | 49091 | 2020-04-11 | Greene | Indiana | 18055 | 15 | 2 |
51754 | 51754 | 2020-04-12 | Greene | Indiana | 18055 | 20 | 2 |
54435 | 54435 | 2020-04-13 | Greene | Indiana | 18055 | 26 | 2 |
57128 | 57128 | 2020-04-14 | Greene | Indiana | 18055 | 26 | 2 |
59836 | 59836 | 2020-04-15 | Greene | Indiana | 18055 | 29 | 3 |
62557 | 62557 | 2020-04-16 | Greene | Indiana | 18055 | 37 | 3 |
65291 | 65291 | 2020-04-17 | Greene | Indiana | 18055 | 38 | 4 |
68040 | 68040 | 2020-04-18 | Greene | Indiana | 18055 | 43 | 4 |
70802 | 70802 | 2020-04-19 | Greene | Indiana | 18055 | 43 | 4 |
73573 | 73573 | 2020-04-20 | Greene | Indiana | 18055 | 43 | 5 |
76350 | 76350 | 2020-04-21 | Greene | Indiana | 18055 | 45 | 5 |
79134 | 79134 | 2020-04-22 | Greene | Indiana | 18055 | 45 | 5 |
81927 | 81927 | 2020-04-23 | Greene | Indiana | 18055 | 45 | 5 |
84727 | 84727 | 2020-04-24 | Greene | Indiana | 18055 | 46 | 5 |
87537 | 87537 | 2020-04-25 | Greene | Indiana | 18055 | 48 | 6 |
90353 | 90353 | 2020-04-26 | Greene | Indiana | 18055 | 49 | 7 |
93172 | 93172 | 2020-04-27 | Greene | Indiana | 18055 | 48 | 6 |
96004 | 96004 | 2020-04-28 | Greene | Indiana | 18055 | 50 | 7 |
98848 | 98848 | 2020-04-29 | Greene | Indiana | 18055 | 58 | 8 |
101699 | 101699 | 2020-04-30 | Greene | Indiana | 18055 | 59 | 8 |
104555 | 104555 | 2020-05-01 | Greene | Indiana | 18055 | 93 | 8 |
107420 | 107420 | 2020-05-02 | Greene | Indiana | 18055 | 98 | 8 |
110290 | 110290 | 2020-05-03 | Greene | Indiana | 18055 | 99 | 8 |
113165 | 113165 | 2020-05-04 | Greene | Indiana | 18055 | 99 | 8 |
116048 | 116048 | 2020-05-05 | Greene | Indiana | 18055 | 100 | 9 |
119008 | 119008 | 2020-05-06 | Greene | Indiana | 18055 | 105 | 10 |
121978 | 121978 | 2020-05-07 | Greene | Indiana | 18055 | 136 | 11 |
124958 | 124958 | 2020-05-08 | Greene | Indiana | 18055 | 150 | 11 |
127945 | 127945 | 2020-05-09 | Greene | Indiana | 18055 | 151 | 11 |
130936 | 130936 | 2020-05-10 | Greene | Indiana | 18055 | 151 | 13 |
133926 | 133926 | 2020-05-11 | Greene | Indiana | 18055 | 151 | 17 |
136915 | 136915 | 2020-05-12 | Greene | Indiana | 18055 | 155 | 19 |
139907 | 139907 | 2020-05-13 | Greene | Indiana | 18055 | 155 | 20 |
142903 | 142903 | 2020-05-14 | Greene | Indiana | 18055 | 157 | 20 |
145903 | 145903 | 2020-05-15 | Greene | Indiana | 18055 | 158 | 20 |
148907 | 148907 | 2020-05-16 | Greene | Indiana | 18055 | 158 | 23 |
151916 | 151916 | 2020-05-17 | Greene | Indiana | 18055 | 162 | 24 |
154928 | 154928 | 2020-05-18 | Greene | Indiana | 18055 | 164 | 24 |
157944 | 157944 | 2020-05-19 | Greene | Indiana | 18055 | 165 | 24 |
160970 | 160970 | 2020-05-20 | Greene | Indiana | 18055 | 166 | 24 |
163998 | 163998 | 2020-05-21 | Greene | Indiana | 18055 | 169 | 24 |
167031 | 167031 | 2020-05-22 | Greene | Indiana | 18055 | 171 | 25 |
170068 | 170068 | 2020-05-23 | Greene | Indiana | 18055 | 171 | 26 |
173109 | 173109 | 2020-05-24 | Greene | Indiana | 18055 | 171 | 26 |
176153 | 176153 | 2020-05-25 | Greene | Indiana | 18055 | 171 | 26 |
179197 | 179197 | 2020-05-26 | Greene | Indiana | 18055 | 171 | 27 |
182241 | 182241 | 2020-05-27 | Greene | Indiana | 18055 | 172 | 27 |
185295 | 185295 | 2020-05-28 | Greene | Indiana | 18055 | 172 | 27 |
188353 | 188353 | 2020-05-29 | Greene | Indiana | 18055 | 172 | 27 |
191418 | 191418 | 2020-05-30 | Greene | Indiana | 18055 | 173 | 27 |
194485 | 194485 | 2020-05-31 | Greene | Indiana | 18055 | 173 | 27 |
197555 | 197555 | 2020-06-01 | Greene | Indiana | 18055 | 173 | 28 |
200628 | 200628 | 2020-06-02 | Greene | Indiana | 18055 | 173 | 28 |
203704 | 203704 | 2020-06-03 | Greene | Indiana | 18055 | 175 | 28 |
206784 | 206784 | 2020-06-04 | Greene | Indiana | 18055 | 176 | 28 |
209865 | 209865 | 2020-06-05 | Greene | Indiana | 18055 | 176 | 29 |
212950 | 212950 | 2020-06-06 | Greene | Indiana | 18055 | 178 | 30 |
216037 | 216037 | 2020-06-07 | Greene | Indiana | 18055 | 179 | 30 |
219129 | 219129 | 2020-06-08 | Greene | Indiana | 18055 | 179 | 31 |
222224 | 222224 | 2020-06-09 | Greene | Indiana | 18055 | 179 | 31 |
225319 | 225319 | 2020-06-10 | Greene | Indiana | 18055 | 182 | 31 |
228421 | 228421 | 2020-06-11 | Greene | Indiana | 18055 | 182 | 31 |
231524 | 231524 | 2020-06-12 | Greene | Indiana | 18055 | 182 | 31 |
234630 | 234630 | 2020-06-13 | Greene | Indiana | 18055 | 182 | 31 |
237737 | 237737 | 2020-06-14 | Greene | Indiana | 18055 | 184 | 32 |
240845 | 240845 | 2020-06-15 | Greene | Indiana | 18055 | 186 | 32 |
243956 | 243956 | 2020-06-16 | Greene | Indiana | 18055 | 186 | 32 |
247069 | 247069 | 2020-06-17 | Greene | Indiana | 18055 | 187 | 32 |
250181 | 250181 | 2020-06-18 | Greene | Indiana | 18055 | 187 | 32 |
253296 | 253296 | 2020-06-19 | Greene | Indiana | 18055 | 188 | 32 |
256416 | 256416 | 2020-06-20 | Greene | Indiana | 18055 | 189 | 32 |
259542 | 259542 | 2020-06-21 | Greene | Indiana | 18055 | 189 | 32 |
262669 | 262669 | 2020-06-22 | Greene | Indiana | 18055 | 189 | 32 |
265797 | 265797 | 2020-06-23 | Greene | Indiana | 18055 | 189 | 32 |
268927 | 268927 | 2020-06-24 | Greene | Indiana | 18055 | 189 | 32 |
272064 | 272064 | 2020-06-25 | Greene | Indiana | 18055 | 189 | 32 |
275206 | 275206 | 2020-06-26 | Greene | Indiana | 18055 | 190 | 32 |
278354 | 278354 | 2020-06-27 | Greene | Indiana | 18055 | 188 | 34 |
281502 | 281502 | 2020-06-28 | Greene | Indiana | 18055 | 188 | 34 |
284647 | 284647 | 2020-06-29 | Greene | Indiana | 18055 | 188 | 34 |
287796 | 287796 | 2020-06-30 | Greene | Indiana | 18055 | 189 | 34 |
290946 | 290946 | 2020-07-01 | Greene | Indiana | 18055 | 189 | 34 |
294100 | 294100 | 2020-07-02 | Greene | Indiana | 18055 | 189 | 35 |
297258 | 297258 | 2020-07-03 | Greene | Indiana | 18055 | 189 | 35 |
300420 | 300420 | 2020-07-04 | Greene | Indiana | 18055 | 190 | 35 |
303584 | 303584 | 2020-07-05 | Greene | Indiana | 18055 | 193 | 35 |
306749 | 306749 | 2020-07-06 | Greene | Indiana | 18055 | 194 | 35 |
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);