ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Johnson" and state = "Indiana" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1237 | 1237 | 2020-03-11 | Johnson | Indiana | 18081 | 3 | 0 |
1451 | 1451 | 2020-03-12 | Johnson | Indiana | 18081 | 3 | 0 |
1722 | 1722 | 2020-03-13 | Johnson | Indiana | 18081 | 3 | 0 |
2053 | 2053 | 2020-03-14 | Johnson | Indiana | 18081 | 3 | 0 |
2447 | 2447 | 2020-03-15 | Johnson | Indiana | 18081 | 3 | 0 |
2892 | 2892 | 2020-03-16 | Johnson | Indiana | 18081 | 3 | 0 |
3382 | 3382 | 2020-03-17 | Johnson | Indiana | 18081 | 3 | 1 |
3955 | 3955 | 2020-03-18 | Johnson | Indiana | 18081 | 3 | 1 |
4631 | 4631 | 2020-03-19 | Johnson | Indiana | 18081 | 3 | 1 |
5439 | 5439 | 2020-03-20 | Johnson | Indiana | 18081 | 4 | 1 |
6378 | 6378 | 2020-03-21 | Johnson | Indiana | 18081 | 7 | 1 |
7432 | 7432 | 2020-03-22 | Johnson | Indiana | 18081 | 12 | 1 |
8590 | 8590 | 2020-03-23 | Johnson | Indiana | 18081 | 14 | 1 |
9859 | 9859 | 2020-03-24 | Johnson | Indiana | 18081 | 18 | 3 |
11254 | 11254 | 2020-03-25 | Johnson | Indiana | 18081 | 24 | 3 |
12811 | 12811 | 2020-03-26 | Johnson | Indiana | 18081 | 36 | 3 |
14494 | 14494 | 2020-03-27 | Johnson | Indiana | 18081 | 42 | 3 |
16292 | 16292 | 2020-03-28 | Johnson | Indiana | 18081 | 52 | 3 |
18195 | 18195 | 2020-03-29 | Johnson | Indiana | 18081 | 71 | 3 |
20201 | 20201 | 2020-03-30 | Johnson | Indiana | 18081 | 81 | 3 |
22296 | 22296 | 2020-03-31 | Johnson | Indiana | 18081 | 101 | 3 |
24467 | 24467 | 2020-04-01 | Johnson | Indiana | 18081 | 118 | 3 |
26706 | 26706 | 2020-04-02 | Johnson | Indiana | 18081 | 126 | 3 |
29016 | 29016 | 2020-04-03 | Johnson | Indiana | 18081 | 136 | 4 |
31382 | 31382 | 2020-04-04 | Johnson | Indiana | 18081 | 153 | 6 |
33793 | 33793 | 2020-04-05 | Johnson | Indiana | 18081 | 167 | 6 |
36246 | 36246 | 2020-04-06 | Johnson | Indiana | 18081 | 195 | 6 |
38744 | 38744 | 2020-04-07 | Johnson | Indiana | 18081 | 212 | 7 |
41290 | 41290 | 2020-04-08 | Johnson | Indiana | 18081 | 230 | 8 |
43866 | 43866 | 2020-04-09 | Johnson | Indiana | 18081 | 248 | 11 |
46470 | 46470 | 2020-04-10 | Johnson | Indiana | 18081 | 271 | 17 |
49104 | 49104 | 2020-04-11 | Johnson | Indiana | 18081 | 288 | 20 |
51767 | 51767 | 2020-04-12 | Johnson | Indiana | 18081 | 318 | 21 |
54448 | 54448 | 2020-04-13 | Johnson | Indiana | 18081 | 328 | 21 |
57141 | 57141 | 2020-04-14 | Johnson | Indiana | 18081 | 331 | 23 |
59849 | 59849 | 2020-04-15 | Johnson | Indiana | 18081 | 349 | 27 |
62570 | 62570 | 2020-04-16 | Johnson | Indiana | 18081 | 360 | 32 |
65304 | 65304 | 2020-04-17 | Johnson | Indiana | 18081 | 373 | 32 |
68053 | 68053 | 2020-04-18 | Johnson | Indiana | 18081 | 397 | 35 |
70815 | 70815 | 2020-04-19 | Johnson | Indiana | 18081 | 415 | 36 |
73586 | 73586 | 2020-04-20 | Johnson | Indiana | 18081 | 430 | 37 |
76363 | 76363 | 2020-04-21 | Johnson | Indiana | 18081 | 455 | 43 |
79147 | 79147 | 2020-04-22 | Johnson | Indiana | 18081 | 460 | 44 |
81940 | 81940 | 2020-04-23 | Johnson | Indiana | 18081 | 482 | 47 |
84740 | 84740 | 2020-04-24 | Johnson | Indiana | 18081 | 516 | 53 |
87550 | 87550 | 2020-04-25 | Johnson | Indiana | 18081 | 535 | 55 |
90366 | 90366 | 2020-04-26 | Johnson | Indiana | 18081 | 538 | 56 |
93185 | 93185 | 2020-04-27 | Johnson | Indiana | 18081 | 543 | 53 |
96017 | 96017 | 2020-04-28 | Johnson | Indiana | 18081 | 553 | 60 |
98861 | 98861 | 2020-04-29 | Johnson | Indiana | 18081 | 570 | 66 |
101712 | 101712 | 2020-04-30 | Johnson | Indiana | 18081 | 588 | 67 |
104568 | 104568 | 2020-05-01 | Johnson | Indiana | 18081 | 625 | 72 |
107433 | 107433 | 2020-05-02 | Johnson | Indiana | 18081 | 677 | 74 |
110303 | 110303 | 2020-05-03 | Johnson | Indiana | 18081 | 715 | 77 |
113178 | 113178 | 2020-05-04 | Johnson | Indiana | 18081 | 727 | 77 |
116061 | 116061 | 2020-05-05 | Johnson | Indiana | 18081 | 739 | 80 |
119021 | 119021 | 2020-05-06 | Johnson | Indiana | 18081 | 756 | 81 |
121991 | 121991 | 2020-05-07 | Johnson | Indiana | 18081 | 768 | 81 |
124971 | 124971 | 2020-05-08 | Johnson | Indiana | 18081 | 783 | 87 |
127958 | 127958 | 2020-05-09 | Johnson | Indiana | 18081 | 805 | 89 |
130949 | 130949 | 2020-05-10 | Johnson | Indiana | 18081 | 822 | 89 |
133939 | 133939 | 2020-05-11 | Johnson | Indiana | 18081 | 842 | 94 |
136928 | 136928 | 2020-05-12 | Johnson | Indiana | 18081 | 856 | 95 |
139920 | 139920 | 2020-05-13 | Johnson | Indiana | 18081 | 858 | 96 |
142916 | 142916 | 2020-05-14 | Johnson | Indiana | 18081 | 972 | 96 |
145916 | 145916 | 2020-05-15 | Johnson | Indiana | 18081 | 983 | 98 |
148920 | 148920 | 2020-05-16 | Johnson | Indiana | 18081 | 1004 | 99 |
151929 | 151929 | 2020-05-17 | Johnson | Indiana | 18081 | 1016 | 99 |
154941 | 154941 | 2020-05-18 | Johnson | Indiana | 18081 | 1026 | 99 |
157957 | 157957 | 2020-05-19 | Johnson | Indiana | 18081 | 1041 | 102 |
160983 | 160983 | 2020-05-20 | Johnson | Indiana | 18081 | 1053 | 104 |
164011 | 164011 | 2020-05-21 | Johnson | Indiana | 18081 | 1074 | 107 |
167044 | 167044 | 2020-05-22 | Johnson | Indiana | 18081 | 1077 | 107 |
170081 | 170081 | 2020-05-23 | Johnson | Indiana | 18081 | 1090 | 107 |
173122 | 173122 | 2020-05-24 | Johnson | Indiana | 18081 | 1105 | 109 |
176166 | 176166 | 2020-05-25 | Johnson | Indiana | 18081 | 1107 | 109 |
179210 | 179210 | 2020-05-26 | Johnson | Indiana | 18081 | 1111 | 109 |
182254 | 182254 | 2020-05-27 | Johnson | Indiana | 18081 | 1119 | 111 |
185308 | 185308 | 2020-05-28 | Johnson | Indiana | 18081 | 1121 | 113 |
188366 | 188366 | 2020-05-29 | Johnson | Indiana | 18081 | 1121 | 115 |
191431 | 191431 | 2020-05-30 | Johnson | Indiana | 18081 | 1125 | 115 |
194498 | 194498 | 2020-05-31 | Johnson | Indiana | 18081 | 1133 | 115 |
197568 | 197568 | 2020-06-01 | Johnson | Indiana | 18081 | 1142 | 115 |
200641 | 200641 | 2020-06-02 | Johnson | Indiana | 18081 | 1144 | 118 |
203717 | 203717 | 2020-06-03 | Johnson | Indiana | 18081 | 1147 | 118 |
206797 | 206797 | 2020-06-04 | Johnson | Indiana | 18081 | 1148 | 120 |
209878 | 209878 | 2020-06-05 | Johnson | Indiana | 18081 | 1152 | 121 |
212963 | 212963 | 2020-06-06 | Johnson | Indiana | 18081 | 1156 | 122 |
216050 | 216050 | 2020-06-07 | Johnson | Indiana | 18081 | 1160 | 122 |
219142 | 219142 | 2020-06-08 | Johnson | Indiana | 18081 | 1166 | 122 |
222237 | 222237 | 2020-06-09 | Johnson | Indiana | 18081 | 1172 | 122 |
225332 | 225332 | 2020-06-10 | Johnson | Indiana | 18081 | 1183 | 122 |
228434 | 228434 | 2020-06-11 | Johnson | Indiana | 18081 | 1185 | 122 |
231537 | 231537 | 2020-06-12 | Johnson | Indiana | 18081 | 1188 | 122 |
234643 | 234643 | 2020-06-13 | Johnson | Indiana | 18081 | 1196 | 122 |
237750 | 237750 | 2020-06-14 | Johnson | Indiana | 18081 | 1196 | 122 |
240858 | 240858 | 2020-06-15 | Johnson | Indiana | 18081 | 1200 | 122 |
243969 | 243969 | 2020-06-16 | Johnson | Indiana | 18081 | 1202 | 123 |
247082 | 247082 | 2020-06-17 | Johnson | Indiana | 18081 | 1205 | 123 |
250194 | 250194 | 2020-06-18 | Johnson | Indiana | 18081 | 1213 | 124 |
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);