ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Hamlin" and state = "South Dakota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17278 | 17278 | 2020-03-28 | Hamlin | South Dakota | 46057 | 1 | 0 |
19221 | 19221 | 2020-03-29 | Hamlin | South Dakota | 46057 | 1 | 0 |
21273 | 21273 | 2020-03-30 | Hamlin | South Dakota | 46057 | 1 | 0 |
23411 | 23411 | 2020-03-31 | Hamlin | South Dakota | 46057 | 1 | 0 |
25609 | 25609 | 2020-04-01 | Hamlin | South Dakota | 46057 | 1 | 0 |
27885 | 27885 | 2020-04-02 | Hamlin | South Dakota | 46057 | 1 | 0 |
30220 | 30220 | 2020-04-03 | Hamlin | South Dakota | 46057 | 1 | 0 |
32611 | 32611 | 2020-04-04 | Hamlin | South Dakota | 46057 | 1 | 0 |
35047 | 35047 | 2020-04-05 | Hamlin | South Dakota | 46057 | 1 | 0 |
37522 | 37522 | 2020-04-06 | Hamlin | South Dakota | 46057 | 1 | 0 |
40045 | 40045 | 2020-04-07 | Hamlin | South Dakota | 46057 | 1 | 0 |
42605 | 42605 | 2020-04-08 | Hamlin | South Dakota | 46057 | 1 | 0 |
45192 | 45192 | 2020-04-09 | Hamlin | South Dakota | 46057 | 1 | 0 |
47809 | 47809 | 2020-04-10 | Hamlin | South Dakota | 46057 | 1 | 0 |
50466 | 50466 | 2020-04-11 | Hamlin | South Dakota | 46057 | 1 | 0 |
53139 | 53139 | 2020-04-12 | Hamlin | South Dakota | 46057 | 1 | 0 |
55824 | 55824 | 2020-04-13 | Hamlin | South Dakota | 46057 | 1 | 0 |
58527 | 58527 | 2020-04-14 | Hamlin | South Dakota | 46057 | 1 | 0 |
61242 | 61242 | 2020-04-15 | Hamlin | South Dakota | 46057 | 1 | 0 |
63968 | 63968 | 2020-04-16 | Hamlin | South Dakota | 46057 | 2 | 0 |
66714 | 66714 | 2020-04-17 | Hamlin | South Dakota | 46057 | 2 | 0 |
69472 | 69472 | 2020-04-18 | Hamlin | South Dakota | 46057 | 2 | 0 |
72239 | 72239 | 2020-04-19 | Hamlin | South Dakota | 46057 | 2 | 0 |
75014 | 75014 | 2020-04-20 | Hamlin | South Dakota | 46057 | 2 | 0 |
77796 | 77796 | 2020-04-21 | Hamlin | South Dakota | 46057 | 2 | 0 |
80586 | 80586 | 2020-04-22 | Hamlin | South Dakota | 46057 | 2 | 0 |
83385 | 83385 | 2020-04-23 | Hamlin | South Dakota | 46057 | 2 | 0 |
86189 | 86189 | 2020-04-24 | Hamlin | South Dakota | 46057 | 2 | 0 |
89003 | 89003 | 2020-04-25 | Hamlin | South Dakota | 46057 | 2 | 0 |
91819 | 91819 | 2020-04-26 | Hamlin | South Dakota | 46057 | 2 | 0 |
94647 | 94647 | 2020-04-27 | Hamlin | South Dakota | 46057 | 2 | 0 |
97487 | 97487 | 2020-04-28 | Hamlin | South Dakota | 46057 | 2 | 0 |
100337 | 100337 | 2020-04-29 | Hamlin | South Dakota | 46057 | 2 | 0 |
103190 | 103190 | 2020-04-30 | Hamlin | South Dakota | 46057 | 2 | 0 |
106053 | 106053 | 2020-05-01 | Hamlin | South Dakota | 46057 | 2 | 0 |
108920 | 108920 | 2020-05-02 | Hamlin | South Dakota | 46057 | 2 | 0 |
111794 | 111794 | 2020-05-03 | Hamlin | South Dakota | 46057 | 2 | 0 |
114676 | 114676 | 2020-05-04 | Hamlin | South Dakota | 46057 | 2 | 0 |
117632 | 117632 | 2020-05-05 | Hamlin | South Dakota | 46057 | 2 | 0 |
120595 | 120595 | 2020-05-06 | Hamlin | South Dakota | 46057 | 2 | 0 |
123573 | 123573 | 2020-05-07 | Hamlin | South Dakota | 46057 | 2 | 0 |
126556 | 126556 | 2020-05-08 | Hamlin | South Dakota | 46057 | 2 | 0 |
129545 | 129545 | 2020-05-09 | Hamlin | South Dakota | 46057 | 2 | 0 |
132534 | 132534 | 2020-05-10 | Hamlin | South Dakota | 46057 | 2 | 0 |
135525 | 135525 | 2020-05-11 | Hamlin | South Dakota | 46057 | 2 | 0 |
138515 | 138515 | 2020-05-12 | Hamlin | South Dakota | 46057 | 2 | 0 |
141511 | 141511 | 2020-05-13 | Hamlin | South Dakota | 46057 | 2 | 0 |
144507 | 144507 | 2020-05-14 | Hamlin | South Dakota | 46057 | 2 | 0 |
147508 | 147508 | 2020-05-15 | Hamlin | South Dakota | 46057 | 2 | 0 |
150516 | 150516 | 2020-05-16 | Hamlin | South Dakota | 46057 | 2 | 0 |
153527 | 153527 | 2020-05-17 | Hamlin | South Dakota | 46057 | 3 | 0 |
156544 | 156544 | 2020-05-18 | Hamlin | South Dakota | 46057 | 3 | 0 |
159565 | 159565 | 2020-05-19 | Hamlin | South Dakota | 46057 | 3 | 0 |
162592 | 162592 | 2020-05-20 | Hamlin | South Dakota | 46057 | 3 | 0 |
165621 | 165621 | 2020-05-21 | Hamlin | South Dakota | 46057 | 3 | 0 |
168657 | 168657 | 2020-05-22 | Hamlin | South Dakota | 46057 | 3 | 0 |
171696 | 171696 | 2020-05-23 | Hamlin | South Dakota | 46057 | 3 | 0 |
174738 | 174738 | 2020-05-24 | Hamlin | South Dakota | 46057 | 4 | 0 |
177782 | 177782 | 2020-05-25 | Hamlin | South Dakota | 46057 | 4 | 0 |
180825 | 180825 | 2020-05-26 | Hamlin | South Dakota | 46057 | 4 | 0 |
183875 | 183875 | 2020-05-27 | Hamlin | South Dakota | 46057 | 4 | 0 |
186932 | 186932 | 2020-05-28 | Hamlin | South Dakota | 46057 | 4 | 0 |
189995 | 189995 | 2020-05-29 | Hamlin | South Dakota | 46057 | 4 | 0 |
193060 | 193060 | 2020-05-30 | Hamlin | South Dakota | 46057 | 4 | 0 |
196130 | 196130 | 2020-05-31 | Hamlin | South Dakota | 46057 | 4 | 0 |
199203 | 199203 | 2020-06-01 | Hamlin | South Dakota | 46057 | 4 | 0 |
202278 | 202278 | 2020-06-02 | Hamlin | South Dakota | 46057 | 4 | 0 |
205356 | 205356 | 2020-06-03 | Hamlin | South Dakota | 46057 | 4 | 0 |
208438 | 208438 | 2020-06-04 | Hamlin | South Dakota | 46057 | 5 | 0 |
211520 | 211520 | 2020-06-05 | Hamlin | South Dakota | 46057 | 5 | 0 |
214607 | 214607 | 2020-06-06 | Hamlin | South Dakota | 46057 | 5 | 0 |
217697 | 217697 | 2020-06-07 | Hamlin | South Dakota | 46057 | 6 | 0 |
220789 | 220789 | 2020-06-08 | Hamlin | South Dakota | 46057 | 7 | 0 |
223884 | 223884 | 2020-06-09 | Hamlin | South Dakota | 46057 | 8 | 0 |
226984 | 226984 | 2020-06-10 | Hamlin | South Dakota | 46057 | 9 | 0 |
230088 | 230088 | 2020-06-11 | Hamlin | South Dakota | 46057 | 9 | 0 |
233193 | 233193 | 2020-06-12 | Hamlin | South Dakota | 46057 | 9 | 0 |
236298 | 236298 | 2020-06-13 | Hamlin | South Dakota | 46057 | 10 | 0 |
239406 | 239406 | 2020-06-14 | Hamlin | South Dakota | 46057 | 11 | 0 |
242516 | 242516 | 2020-06-15 | Hamlin | South Dakota | 46057 | 11 | 0 |
245628 | 245628 | 2020-06-16 | Hamlin | South Dakota | 46057 | 11 | 0 |
248741 | 248741 | 2020-06-17 | Hamlin | South Dakota | 46057 | 11 | 0 |
251856 | 251856 | 2020-06-18 | Hamlin | South Dakota | 46057 | 10 | 0 |
254971 | 254971 | 2020-06-19 | Hamlin | South Dakota | 46057 | 10 | 0 |
258097 | 258097 | 2020-06-20 | Hamlin | South Dakota | 46057 | 10 | 0 |
261224 | 261224 | 2020-06-21 | Hamlin | South Dakota | 46057 | 10 | 0 |
264352 | 264352 | 2020-06-22 | Hamlin | South Dakota | 46057 | 11 | 0 |
267480 | 267480 | 2020-06-23 | Hamlin | South Dakota | 46057 | 11 | 0 |
270614 | 270614 | 2020-06-24 | Hamlin | South Dakota | 46057 | 11 | 0 |
273753 | 273753 | 2020-06-25 | Hamlin | South Dakota | 46057 | 11 | 0 |
276900 | 276900 | 2020-06-26 | Hamlin | South Dakota | 46057 | 11 | 0 |
280048 | 280048 | 2020-06-27 | Hamlin | South Dakota | 46057 | 11 | 0 |
283194 | 283194 | 2020-06-28 | Hamlin | South Dakota | 46057 | 11 | 0 |
286339 | 286339 | 2020-06-29 | Hamlin | South Dakota | 46057 | 11 | 0 |
289490 | 289490 | 2020-06-30 | Hamlin | South Dakota | 46057 | 11 | 0 |
292642 | 292642 | 2020-07-01 | Hamlin | South Dakota | 46057 | 12 | 0 |
295798 | 295798 | 2020-07-02 | Hamlin | South Dakota | 46057 | 12 | 0 |
298958 | 298958 | 2020-07-03 | Hamlin | South Dakota | 46057 | 13 | 0 |
302122 | 302122 | 2020-07-04 | Hamlin | South Dakota | 46057 | 13 | 0 |
305285 | 305285 | 2020-07-05 | Hamlin | South Dakota | 46057 | 13 | 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);