ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where fips = 46023 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1125 | 1125 | 2020-03-10 | Charles Mix | South Dakota | 46023 | 1 | 0 |
1321 | 1321 | 2020-03-11 | Charles Mix | South Dakota | 46023 | 1 | 0 |
1567 | 1567 | 2020-03-12 | Charles Mix | South Dakota | 46023 | 1 | 0 |
1867 | 1867 | 2020-03-13 | Charles Mix | South Dakota | 46023 | 1 | 0 |
2231 | 2231 | 2020-03-14 | Charles Mix | South Dakota | 46023 | 1 | 0 |
2656 | 2656 | 2020-03-15 | Charles Mix | South Dakota | 46023 | 1 | 0 |
3122 | 3122 | 2020-03-16 | Charles Mix | South Dakota | 46023 | 1 | 0 |
3655 | 3655 | 2020-03-17 | Charles Mix | South Dakota | 46023 | 1 | 0 |
4275 | 4275 | 2020-03-18 | Charles Mix | South Dakota | 46023 | 1 | 0 |
5020 | 5020 | 2020-03-19 | Charles Mix | South Dakota | 46023 | 1 | 0 |
5901 | 5901 | 2020-03-20 | Charles Mix | South Dakota | 46023 | 1 | 0 |
6911 | 6911 | 2020-03-21 | Charles Mix | South Dakota | 46023 | 1 | 0 |
8033 | 8033 | 2020-03-22 | Charles Mix | South Dakota | 46023 | 1 | 0 |
9247 | 9247 | 2020-03-23 | Charles Mix | South Dakota | 46023 | 1 | 0 |
10574 | 10574 | 2020-03-24 | Charles Mix | South Dakota | 46023 | 1 | 0 |
12048 | 12048 | 2020-03-25 | Charles Mix | South Dakota | 46023 | 1 | 0 |
13670 | 13670 | 2020-03-26 | Charles Mix | South Dakota | 46023 | 1 | 0 |
15418 | 15418 | 2020-03-27 | Charles Mix | South Dakota | 46023 | 1 | 0 |
17273 | 17273 | 2020-03-28 | Charles Mix | South Dakota | 46023 | 1 | 0 |
19213 | 19213 | 2020-03-29 | Charles Mix | South Dakota | 46023 | 1 | 0 |
21265 | 21265 | 2020-03-30 | Charles Mix | South Dakota | 46023 | 1 | 0 |
23403 | 23403 | 2020-03-31 | Charles Mix | South Dakota | 46023 | 1 | 0 |
25601 | 25601 | 2020-04-01 | Charles Mix | South Dakota | 46023 | 1 | 0 |
27877 | 27877 | 2020-04-02 | Charles Mix | South Dakota | 46023 | 1 | 0 |
30212 | 30212 | 2020-04-03 | Charles Mix | South Dakota | 46023 | 1 | 0 |
32603 | 32603 | 2020-04-04 | Charles Mix | South Dakota | 46023 | 2 | 0 |
35039 | 35039 | 2020-04-05 | Charles Mix | South Dakota | 46023 | 2 | 0 |
37514 | 37514 | 2020-04-06 | Charles Mix | South Dakota | 46023 | 2 | 0 |
40037 | 40037 | 2020-04-07 | Charles Mix | South Dakota | 46023 | 2 | 0 |
42597 | 42597 | 2020-04-08 | Charles Mix | South Dakota | 46023 | 2 | 0 |
45183 | 45183 | 2020-04-09 | Charles Mix | South Dakota | 46023 | 2 | 0 |
47800 | 47800 | 2020-04-10 | Charles Mix | South Dakota | 46023 | 3 | 0 |
50457 | 50457 | 2020-04-11 | Charles Mix | South Dakota | 46023 | 3 | 0 |
53130 | 53130 | 2020-04-12 | Charles Mix | South Dakota | 46023 | 4 | 0 |
55815 | 55815 | 2020-04-13 | Charles Mix | South Dakota | 46023 | 4 | 0 |
58518 | 58518 | 2020-04-14 | Charles Mix | South Dakota | 46023 | 4 | 0 |
61233 | 61233 | 2020-04-15 | Charles Mix | South Dakota | 46023 | 4 | 0 |
63959 | 63959 | 2020-04-16 | Charles Mix | South Dakota | 46023 | 4 | 0 |
66705 | 66705 | 2020-04-17 | Charles Mix | South Dakota | 46023 | 4 | 0 |
69463 | 69463 | 2020-04-18 | Charles Mix | South Dakota | 46023 | 4 | 0 |
72230 | 72230 | 2020-04-19 | Charles Mix | South Dakota | 46023 | 4 | 0 |
75005 | 75005 | 2020-04-20 | Charles Mix | South Dakota | 46023 | 4 | 0 |
77787 | 77787 | 2020-04-21 | Charles Mix | South Dakota | 46023 | 4 | 0 |
80577 | 80577 | 2020-04-22 | Charles Mix | South Dakota | 46023 | 4 | 0 |
83376 | 83376 | 2020-04-23 | Charles Mix | South Dakota | 46023 | 4 | 0 |
86180 | 86180 | 2020-04-24 | Charles Mix | South Dakota | 46023 | 4 | 0 |
88994 | 88994 | 2020-04-25 | Charles Mix | South Dakota | 46023 | 4 | 0 |
91810 | 91810 | 2020-04-26 | Charles Mix | South Dakota | 46023 | 4 | 0 |
94637 | 94637 | 2020-04-27 | Charles Mix | South Dakota | 46023 | 4 | 0 |
97477 | 97477 | 2020-04-28 | Charles Mix | South Dakota | 46023 | 4 | 0 |
100326 | 100326 | 2020-04-29 | Charles Mix | South Dakota | 46023 | 5 | 0 |
103179 | 103179 | 2020-04-30 | Charles Mix | South Dakota | 46023 | 5 | 0 |
106042 | 106042 | 2020-05-01 | Charles Mix | South Dakota | 46023 | 5 | 0 |
108909 | 108909 | 2020-05-02 | Charles Mix | South Dakota | 46023 | 5 | 0 |
111783 | 111783 | 2020-05-03 | Charles Mix | South Dakota | 46023 | 5 | 0 |
114665 | 114665 | 2020-05-04 | Charles Mix | South Dakota | 46023 | 5 | 0 |
117621 | 117621 | 2020-05-05 | Charles Mix | South Dakota | 46023 | 5 | 0 |
120583 | 120583 | 2020-05-06 | Charles Mix | South Dakota | 46023 | 5 | 0 |
123561 | 123561 | 2020-05-07 | Charles Mix | South Dakota | 46023 | 5 | 0 |
126544 | 126544 | 2020-05-08 | Charles Mix | South Dakota | 46023 | 5 | 0 |
129533 | 129533 | 2020-05-09 | Charles Mix | South Dakota | 46023 | 5 | 0 |
132522 | 132522 | 2020-05-10 | Charles Mix | South Dakota | 46023 | 5 | 0 |
135513 | 135513 | 2020-05-11 | Charles Mix | South Dakota | 46023 | 5 | 0 |
138503 | 138503 | 2020-05-12 | Charles Mix | South Dakota | 46023 | 5 | 0 |
141499 | 141499 | 2020-05-13 | Charles Mix | South Dakota | 46023 | 6 | 0 |
144495 | 144495 | 2020-05-14 | Charles Mix | South Dakota | 46023 | 7 | 0 |
147496 | 147496 | 2020-05-15 | Charles Mix | South Dakota | 46023 | 8 | 0 |
150504 | 150504 | 2020-05-16 | Charles Mix | South Dakota | 46023 | 8 | 0 |
153515 | 153515 | 2020-05-17 | Charles Mix | South Dakota | 46023 | 9 | 0 |
156532 | 156532 | 2020-05-18 | Charles Mix | South Dakota | 46023 | 9 | 0 |
159553 | 159553 | 2020-05-19 | Charles Mix | South Dakota | 46023 | 10 | 0 |
162580 | 162580 | 2020-05-20 | Charles Mix | South Dakota | 46023 | 10 | 0 |
165609 | 165609 | 2020-05-21 | Charles Mix | South Dakota | 46023 | 10 | 0 |
168645 | 168645 | 2020-05-22 | Charles Mix | South Dakota | 46023 | 11 | 0 |
171684 | 171684 | 2020-05-23 | Charles Mix | South Dakota | 46023 | 12 | 0 |
174726 | 174726 | 2020-05-24 | Charles Mix | South Dakota | 46023 | 13 | 0 |
177770 | 177770 | 2020-05-25 | Charles Mix | South Dakota | 46023 | 13 | 0 |
180813 | 180813 | 2020-05-26 | Charles Mix | South Dakota | 46023 | 13 | 0 |
183863 | 183863 | 2020-05-27 | Charles Mix | South Dakota | 46023 | 14 | 0 |
186920 | 186920 | 2020-05-28 | Charles Mix | South Dakota | 46023 | 16 | 0 |
189982 | 189982 | 2020-05-29 | Charles Mix | South Dakota | 46023 | 16 | 0 |
193047 | 193047 | 2020-05-30 | Charles Mix | South Dakota | 46023 | 17 | 0 |
196116 | 196116 | 2020-05-31 | Charles Mix | South Dakota | 46023 | 17 | 0 |
199189 | 199189 | 2020-06-01 | Charles Mix | South Dakota | 46023 | 17 | 0 |
202264 | 202264 | 2020-06-02 | Charles Mix | South Dakota | 46023 | 18 | 0 |
205342 | 205342 | 2020-06-03 | Charles Mix | South Dakota | 46023 | 18 | 0 |
208423 | 208423 | 2020-06-04 | Charles Mix | South Dakota | 46023 | 18 | 0 |
211505 | 211505 | 2020-06-05 | Charles Mix | South Dakota | 46023 | 18 | 0 |
214591 | 214591 | 2020-06-06 | Charles Mix | South Dakota | 46023 | 20 | 0 |
217681 | 217681 | 2020-06-07 | Charles Mix | South Dakota | 46023 | 20 | 0 |
220773 | 220773 | 2020-06-08 | Charles Mix | South Dakota | 46023 | 20 | 0 |
223868 | 223868 | 2020-06-09 | Charles Mix | South Dakota | 46023 | 20 | 0 |
226968 | 226968 | 2020-06-10 | Charles Mix | South Dakota | 46023 | 20 | 0 |
230072 | 230072 | 2020-06-11 | Charles Mix | South Dakota | 46023 | 21 | 0 |
233177 | 233177 | 2020-06-12 | Charles Mix | South Dakota | 46023 | 21 | 0 |
236282 | 236282 | 2020-06-13 | Charles Mix | South Dakota | 46023 | 30 | 0 |
239390 | 239390 | 2020-06-14 | Charles Mix | South Dakota | 46023 | 32 | 0 |
242500 | 242500 | 2020-06-15 | Charles Mix | South Dakota | 46023 | 32 | 0 |
245612 | 245612 | 2020-06-16 | Charles Mix | South Dakota | 46023 | 32 | 0 |
248725 | 248725 | 2020-06-17 | Charles Mix | South Dakota | 46023 | 37 | 0 |
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);