ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Scott" and fips = 18143 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7444 | 7444 | 2020-03-22 | Scott | Indiana | 18143 | 1 | 1 |
8602 | 8602 | 2020-03-23 | Scott | Indiana | 18143 | 1 | 1 |
9875 | 9875 | 2020-03-24 | Scott | Indiana | 18143 | 1 | 1 |
11271 | 11271 | 2020-03-25 | Scott | Indiana | 18143 | 1 | 1 |
12831 | 12831 | 2020-03-26 | Scott | Indiana | 18143 | 1 | 1 |
14517 | 14517 | 2020-03-27 | Scott | Indiana | 18143 | 1 | 1 |
16316 | 16316 | 2020-03-28 | Scott | Indiana | 18143 | 1 | 1 |
18220 | 18220 | 2020-03-29 | Scott | Indiana | 18143 | 1 | 1 |
20226 | 20226 | 2020-03-30 | Scott | Indiana | 18143 | 1 | 1 |
22321 | 22321 | 2020-03-31 | Scott | Indiana | 18143 | 1 | 1 |
24492 | 24492 | 2020-04-01 | Scott | Indiana | 18143 | 1 | 1 |
26731 | 26731 | 2020-04-02 | Scott | Indiana | 18143 | 5 | 1 |
29042 | 29042 | 2020-04-03 | Scott | Indiana | 18143 | 6 | 1 |
31409 | 31409 | 2020-04-04 | Scott | Indiana | 18143 | 7 | 1 |
33820 | 33820 | 2020-04-05 | Scott | Indiana | 18143 | 8 | 1 |
36274 | 36274 | 2020-04-06 | Scott | Indiana | 18143 | 7 | 1 |
38772 | 38772 | 2020-04-07 | Scott | Indiana | 18143 | 8 | 1 |
41318 | 41318 | 2020-04-08 | Scott | Indiana | 18143 | 11 | 2 |
43894 | 43894 | 2020-04-09 | Scott | Indiana | 18143 | 12 | 2 |
46499 | 46499 | 2020-04-10 | Scott | Indiana | 18143 | 12 | 2 |
49133 | 49133 | 2020-04-11 | Scott | Indiana | 18143 | 14 | 2 |
51797 | 51797 | 2020-04-12 | Scott | Indiana | 18143 | 17 | 2 |
54478 | 54478 | 2020-04-13 | Scott | Indiana | 18143 | 17 | 2 |
57171 | 57171 | 2020-04-14 | Scott | Indiana | 18143 | 17 | 2 |
59879 | 59879 | 2020-04-15 | Scott | Indiana | 18143 | 17 | 2 |
62600 | 62600 | 2020-04-16 | Scott | Indiana | 18143 | 19 | 2 |
65334 | 65334 | 2020-04-17 | Scott | Indiana | 18143 | 20 | 2 |
68083 | 68083 | 2020-04-18 | Scott | Indiana | 18143 | 22 | 2 |
70845 | 70845 | 2020-04-19 | Scott | Indiana | 18143 | 24 | 2 |
73616 | 73616 | 2020-04-20 | Scott | Indiana | 18143 | 24 | 2 |
76393 | 76393 | 2020-04-21 | Scott | Indiana | 18143 | 25 | 2 |
79177 | 79177 | 2020-04-22 | Scott | Indiana | 18143 | 27 | 2 |
81970 | 81970 | 2020-04-23 | Scott | Indiana | 18143 | 28 | 2 |
84770 | 84770 | 2020-04-24 | Scott | Indiana | 18143 | 33 | 2 |
87580 | 87580 | 2020-04-25 | Scott | Indiana | 18143 | 36 | 2 |
90396 | 90396 | 2020-04-26 | Scott | Indiana | 18143 | 37 | 2 |
93215 | 93215 | 2020-04-27 | Scott | Indiana | 18143 | 38 | 2 |
96047 | 96047 | 2020-04-28 | Scott | Indiana | 18143 | 39 | 2 |
98891 | 98891 | 2020-04-29 | Scott | Indiana | 18143 | 41 | 2 |
101742 | 101742 | 2020-04-30 | Scott | Indiana | 18143 | 46 | 2 |
104598 | 104598 | 2020-05-01 | Scott | Indiana | 18143 | 47 | 2 |
107463 | 107463 | 2020-05-02 | Scott | Indiana | 18143 | 51 | 2 |
110333 | 110333 | 2020-05-03 | Scott | Indiana | 18143 | 52 | 2 |
113208 | 113208 | 2020-05-04 | Scott | Indiana | 18143 | 52 | 2 |
116091 | 116091 | 2020-05-05 | Scott | Indiana | 18143 | 54 | 2 |
119051 | 119051 | 2020-05-06 | Scott | Indiana | 18143 | 54 | 2 |
122021 | 122021 | 2020-05-07 | Scott | Indiana | 18143 | 63 | 2 |
125001 | 125001 | 2020-05-08 | Scott | Indiana | 18143 | 73 | 2 |
127988 | 127988 | 2020-05-09 | Scott | Indiana | 18143 | 79 | 2 |
130979 | 130979 | 2020-05-10 | Scott | Indiana | 18143 | 81 | 2 |
133969 | 133969 | 2020-05-11 | Scott | Indiana | 18143 | 81 | 2 |
136958 | 136958 | 2020-05-12 | Scott | Indiana | 18143 | 85 | 2 |
139950 | 139950 | 2020-05-13 | Scott | Indiana | 18143 | 89 | 2 |
142946 | 142946 | 2020-05-14 | Scott | Indiana | 18143 | 90 | 2 |
145946 | 145946 | 2020-05-15 | Scott | Indiana | 18143 | 91 | 2 |
148950 | 148950 | 2020-05-16 | Scott | Indiana | 18143 | 94 | 2 |
151959 | 151959 | 2020-05-17 | Scott | Indiana | 18143 | 97 | 2 |
154971 | 154971 | 2020-05-18 | Scott | Indiana | 18143 | 98 | 2 |
157987 | 157987 | 2020-05-19 | Scott | Indiana | 18143 | 99 | 2 |
161013 | 161013 | 2020-05-20 | Scott | Indiana | 18143 | 102 | 3 |
164041 | 164041 | 2020-05-21 | Scott | Indiana | 18143 | 106 | 3 |
167074 | 167074 | 2020-05-22 | Scott | Indiana | 18143 | 107 | 3 |
170111 | 170111 | 2020-05-23 | Scott | Indiana | 18143 | 116 | 3 |
173152 | 173152 | 2020-05-24 | Scott | Indiana | 18143 | 117 | 3 |
176196 | 176196 | 2020-05-25 | Scott | Indiana | 18143 | 119 | 3 |
179240 | 179240 | 2020-05-26 | Scott | Indiana | 18143 | 119 | 3 |
182284 | 182284 | 2020-05-27 | Scott | Indiana | 18143 | 119 | 3 |
185338 | 185338 | 2020-05-28 | Scott | Indiana | 18143 | 121 | 3 |
188396 | 188396 | 2020-05-29 | Scott | Indiana | 18143 | 120 | 3 |
191461 | 191461 | 2020-05-30 | Scott | Indiana | 18143 | 120 | 3 |
194528 | 194528 | 2020-05-31 | Scott | Indiana | 18143 | 121 | 3 |
197598 | 197598 | 2020-06-01 | Scott | Indiana | 18143 | 121 | 3 |
200671 | 200671 | 2020-06-02 | Scott | Indiana | 18143 | 122 | 3 |
203747 | 203747 | 2020-06-03 | Scott | Indiana | 18143 | 123 | 3 |
206827 | 206827 | 2020-06-04 | Scott | Indiana | 18143 | 127 | 3 |
209908 | 209908 | 2020-06-05 | Scott | Indiana | 18143 | 127 | 3 |
212993 | 212993 | 2020-06-06 | Scott | Indiana | 18143 | 129 | 3 |
216080 | 216080 | 2020-06-07 | Scott | Indiana | 18143 | 129 | 3 |
219172 | 219172 | 2020-06-08 | Scott | Indiana | 18143 | 130 | 3 |
222267 | 222267 | 2020-06-09 | Scott | Indiana | 18143 | 132 | 3 |
225362 | 225362 | 2020-06-10 | Scott | Indiana | 18143 | 133 | 3 |
228464 | 228464 | 2020-06-11 | Scott | Indiana | 18143 | 141 | 3 |
231567 | 231567 | 2020-06-12 | Scott | Indiana | 18143 | 143 | 3 |
234673 | 234673 | 2020-06-13 | Scott | Indiana | 18143 | 144 | 3 |
237780 | 237780 | 2020-06-14 | Scott | Indiana | 18143 | 145 | 3 |
240888 | 240888 | 2020-06-15 | Scott | Indiana | 18143 | 145 | 3 |
243999 | 243999 | 2020-06-16 | Scott | Indiana | 18143 | 147 | 3 |
247112 | 247112 | 2020-06-17 | Scott | Indiana | 18143 | 147 | 5 |
250224 | 250224 | 2020-06-18 | Scott | Indiana | 18143 | 150 | 7 |
253339 | 253339 | 2020-06-19 | Scott | Indiana | 18143 | 149 | 7 |
256459 | 256459 | 2020-06-20 | Scott | Indiana | 18143 | 151 | 7 |
259585 | 259585 | 2020-06-21 | Scott | Indiana | 18143 | 151 | 7 |
262712 | 262712 | 2020-06-22 | Scott | Indiana | 18143 | 151 | 7 |
265840 | 265840 | 2020-06-23 | Scott | Indiana | 18143 | 153 | 7 |
268970 | 268970 | 2020-06-24 | Scott | Indiana | 18143 | 154 | 7 |
272107 | 272107 | 2020-06-25 | Scott | Indiana | 18143 | 157 | 7 |
275249 | 275249 | 2020-06-26 | Scott | Indiana | 18143 | 156 | 7 |
278397 | 278397 | 2020-06-27 | Scott | Indiana | 18143 | 157 | 7 |
281545 | 281545 | 2020-06-28 | Scott | Indiana | 18143 | 157 | 7 |
284690 | 284690 | 2020-06-29 | Scott | Indiana | 18143 | 157 | 7 |
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);