ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 18047 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 |
---|---|---|---|---|---|---|---|
3378 | 3378 | 2020-03-17 | Franklin | Indiana | 18047 | 2 | 0 |
3950 | 3950 | 2020-03-18 | Franklin | Indiana | 18047 | 2 | 0 |
4626 | 4626 | 2020-03-19 | Franklin | Indiana | 18047 | 2 | 0 |
5433 | 5433 | 2020-03-20 | Franklin | Indiana | 18047 | 2 | 0 |
6370 | 6370 | 2020-03-21 | Franklin | Indiana | 18047 | 2 | 0 |
7424 | 7424 | 2020-03-22 | Franklin | Indiana | 18047 | 4 | 0 |
8582 | 8582 | 2020-03-23 | Franklin | Indiana | 18047 | 4 | 0 |
9849 | 9849 | 2020-03-24 | Franklin | Indiana | 18047 | 7 | 0 |
11243 | 11243 | 2020-03-25 | Franklin | Indiana | 18047 | 7 | 0 |
12800 | 12800 | 2020-03-26 | Franklin | Indiana | 18047 | 13 | 1 |
14480 | 14480 | 2020-03-27 | Franklin | Indiana | 18047 | 22 | 1 |
16278 | 16278 | 2020-03-28 | Franklin | Indiana | 18047 | 23 | 2 |
18180 | 18180 | 2020-03-29 | Franklin | Indiana | 18047 | 26 | 3 |
20186 | 20186 | 2020-03-30 | Franklin | Indiana | 18047 | 28 | 4 |
22280 | 22280 | 2020-03-31 | Franklin | Indiana | 18047 | 35 | 4 |
24450 | 24450 | 2020-04-01 | Franklin | Indiana | 18047 | 39 | 5 |
26689 | 26689 | 2020-04-02 | Franklin | Indiana | 18047 | 45 | 6 |
28999 | 28999 | 2020-04-03 | Franklin | Indiana | 18047 | 48 | 6 |
31365 | 31365 | 2020-04-04 | Franklin | Indiana | 18047 | 50 | 6 |
33776 | 33776 | 2020-04-05 | Franklin | Indiana | 18047 | 53 | 6 |
36229 | 36229 | 2020-04-06 | Franklin | Indiana | 18047 | 55 | 6 |
38727 | 38727 | 2020-04-07 | Franklin | Indiana | 18047 | 60 | 7 |
41273 | 41273 | 2020-04-08 | Franklin | Indiana | 18047 | 61 | 7 |
43849 | 43849 | 2020-04-09 | Franklin | Indiana | 18047 | 64 | 7 |
46453 | 46453 | 2020-04-10 | Franklin | Indiana | 18047 | 66 | 7 |
49087 | 49087 | 2020-04-11 | Franklin | Indiana | 18047 | 67 | 7 |
51750 | 51750 | 2020-04-12 | Franklin | Indiana | 18047 | 69 | 7 |
54431 | 54431 | 2020-04-13 | Franklin | Indiana | 18047 | 69 | 7 |
57124 | 57124 | 2020-04-14 | Franklin | Indiana | 18047 | 74 | 7 |
59832 | 59832 | 2020-04-15 | Franklin | Indiana | 18047 | 75 | 7 |
62553 | 62553 | 2020-04-16 | Franklin | Indiana | 18047 | 75 | 7 |
65287 | 65287 | 2020-04-17 | Franklin | Indiana | 18047 | 87 | 7 |
68036 | 68036 | 2020-04-18 | Franklin | Indiana | 18047 | 89 | 7 |
70798 | 70798 | 2020-04-19 | Franklin | Indiana | 18047 | 89 | 7 |
73569 | 73569 | 2020-04-20 | Franklin | Indiana | 18047 | 90 | 7 |
76346 | 76346 | 2020-04-21 | Franklin | Indiana | 18047 | 91 | 7 |
79130 | 79130 | 2020-04-22 | Franklin | Indiana | 18047 | 91 | 7 |
81923 | 81923 | 2020-04-23 | Franklin | Indiana | 18047 | 92 | 7 |
84723 | 84723 | 2020-04-24 | Franklin | Indiana | 18047 | 92 | 7 |
87533 | 87533 | 2020-04-25 | Franklin | Indiana | 18047 | 94 | 7 |
90349 | 90349 | 2020-04-26 | Franklin | Indiana | 18047 | 95 | 8 |
93168 | 93168 | 2020-04-27 | Franklin | Indiana | 18047 | 94 | 7 |
96000 | 96000 | 2020-04-28 | Franklin | Indiana | 18047 | 95 | 7 |
98844 | 98844 | 2020-04-29 | Franklin | Indiana | 18047 | 96 | 7 |
101695 | 101695 | 2020-04-30 | Franklin | Indiana | 18047 | 98 | 7 |
104551 | 104551 | 2020-05-01 | Franklin | Indiana | 18047 | 98 | 7 |
107416 | 107416 | 2020-05-02 | Franklin | Indiana | 18047 | 99 | 7 |
110286 | 110286 | 2020-05-03 | Franklin | Indiana | 18047 | 99 | 7 |
113161 | 113161 | 2020-05-04 | Franklin | Indiana | 18047 | 101 | 7 |
116044 | 116044 | 2020-05-05 | Franklin | Indiana | 18047 | 101 | 7 |
119004 | 119004 | 2020-05-06 | Franklin | Indiana | 18047 | 104 | 8 |
121974 | 121974 | 2020-05-07 | Franklin | Indiana | 18047 | 104 | 8 |
124954 | 124954 | 2020-05-08 | Franklin | Indiana | 18047 | 107 | 8 |
127941 | 127941 | 2020-05-09 | Franklin | Indiana | 18047 | 107 | 8 |
130932 | 130932 | 2020-05-10 | Franklin | Indiana | 18047 | 107 | 8 |
133922 | 133922 | 2020-05-11 | Franklin | Indiana | 18047 | 109 | 8 |
136911 | 136911 | 2020-05-12 | Franklin | Indiana | 18047 | 109 | 8 |
139903 | 139903 | 2020-05-13 | Franklin | Indiana | 18047 | 109 | 8 |
142899 | 142899 | 2020-05-14 | Franklin | Indiana | 18047 | 110 | 8 |
145899 | 145899 | 2020-05-15 | Franklin | Indiana | 18047 | 111 | 8 |
148903 | 148903 | 2020-05-16 | Franklin | Indiana | 18047 | 110 | 8 |
151912 | 151912 | 2020-05-17 | Franklin | Indiana | 18047 | 110 | 8 |
154924 | 154924 | 2020-05-18 | Franklin | Indiana | 18047 | 110 | 8 |
157940 | 157940 | 2020-05-19 | Franklin | Indiana | 18047 | 111 | 8 |
160966 | 160966 | 2020-05-20 | Franklin | Indiana | 18047 | 111 | 8 |
163994 | 163994 | 2020-05-21 | Franklin | Indiana | 18047 | 111 | 8 |
167027 | 167027 | 2020-05-22 | Franklin | Indiana | 18047 | 112 | 9 |
170064 | 170064 | 2020-05-23 | Franklin | Indiana | 18047 | 112 | 9 |
173105 | 173105 | 2020-05-24 | Franklin | Indiana | 18047 | 112 | 9 |
176149 | 176149 | 2020-05-25 | Franklin | Indiana | 18047 | 112 | 9 |
179193 | 179193 | 2020-05-26 | Franklin | Indiana | 18047 | 112 | 9 |
182237 | 182237 | 2020-05-27 | Franklin | Indiana | 18047 | 112 | 9 |
185291 | 185291 | 2020-05-28 | Franklin | Indiana | 18047 | 115 | 9 |
188349 | 188349 | 2020-05-29 | Franklin | Indiana | 18047 | 115 | 9 |
191414 | 191414 | 2020-05-30 | Franklin | Indiana | 18047 | 116 | 9 |
194481 | 194481 | 2020-05-31 | Franklin | Indiana | 18047 | 116 | 9 |
197551 | 197551 | 2020-06-01 | Franklin | Indiana | 18047 | 116 | 9 |
200624 | 200624 | 2020-06-02 | Franklin | Indiana | 18047 | 116 | 9 |
203700 | 203700 | 2020-06-03 | Franklin | Indiana | 18047 | 121 | 9 |
206780 | 206780 | 2020-06-04 | Franklin | Indiana | 18047 | 123 | 9 |
209861 | 209861 | 2020-06-05 | Franklin | Indiana | 18047 | 123 | 9 |
212946 | 212946 | 2020-06-06 | Franklin | Indiana | 18047 | 124 | 9 |
216033 | 216033 | 2020-06-07 | Franklin | Indiana | 18047 | 124 | 9 |
219125 | 219125 | 2020-06-08 | Franklin | Indiana | 18047 | 124 | 9 |
222220 | 222220 | 2020-06-09 | Franklin | Indiana | 18047 | 125 | 9 |
225315 | 225315 | 2020-06-10 | Franklin | Indiana | 18047 | 126 | 9 |
228417 | 228417 | 2020-06-11 | Franklin | Indiana | 18047 | 126 | 9 |
231520 | 231520 | 2020-06-12 | Franklin | Indiana | 18047 | 126 | 9 |
234626 | 234626 | 2020-06-13 | Franklin | Indiana | 18047 | 126 | 9 |
237733 | 237733 | 2020-06-14 | Franklin | Indiana | 18047 | 127 | 9 |
240841 | 240841 | 2020-06-15 | Franklin | Indiana | 18047 | 127 | 9 |
243952 | 243952 | 2020-06-16 | Franklin | Indiana | 18047 | 127 | 9 |
247065 | 247065 | 2020-06-17 | Franklin | Indiana | 18047 | 127 | 9 |
250177 | 250177 | 2020-06-18 | Franklin | Indiana | 18047 | 127 | 9 |
253292 | 253292 | 2020-06-19 | Franklin | Indiana | 18047 | 127 | 9 |
256412 | 256412 | 2020-06-20 | Franklin | Indiana | 18047 | 127 | 9 |
259538 | 259538 | 2020-06-21 | Franklin | Indiana | 18047 | 128 | 9 |
262665 | 262665 | 2020-06-22 | Franklin | Indiana | 18047 | 128 | 9 |
265793 | 265793 | 2020-06-23 | Franklin | Indiana | 18047 | 128 | 9 |
268923 | 268923 | 2020-06-24 | Franklin | Indiana | 18047 | 128 | 9 |
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);