ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where county = "Allendale" and state = "South Carolina" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
25555 | 25555 | 2020-04-01 | Allendale | South Carolina | 45005 | 1 | 0 |
27828 | 27828 | 2020-04-02 | Allendale | South Carolina | 45005 | 1 | 0 |
30163 | 30163 | 2020-04-03 | Allendale | South Carolina | 45005 | 1 | 0 |
32554 | 32554 | 2020-04-04 | Allendale | South Carolina | 45005 | 2 | 0 |
34990 | 34990 | 2020-04-05 | Allendale | South Carolina | 45005 | 2 | 0 |
37465 | 37465 | 2020-04-06 | Allendale | South Carolina | 45005 | 2 | 0 |
39988 | 39988 | 2020-04-07 | Allendale | South Carolina | 45005 | 2 | 0 |
42548 | 42548 | 2020-04-08 | Allendale | South Carolina | 45005 | 2 | 0 |
45134 | 45134 | 2020-04-09 | Allendale | South Carolina | 45005 | 2 | 0 |
47751 | 47751 | 2020-04-10 | Allendale | South Carolina | 45005 | 4 | 0 |
50408 | 50408 | 2020-04-11 | Allendale | South Carolina | 45005 | 4 | 0 |
53081 | 53081 | 2020-04-12 | Allendale | South Carolina | 45005 | 5 | 0 |
55766 | 55766 | 2020-04-13 | Allendale | South Carolina | 45005 | 5 | 0 |
58469 | 58469 | 2020-04-14 | Allendale | South Carolina | 45005 | 5 | 0 |
61184 | 61184 | 2020-04-15 | Allendale | South Carolina | 45005 | 5 | 0 |
63910 | 63910 | 2020-04-16 | Allendale | South Carolina | 45005 | 5 | 0 |
66656 | 66656 | 2020-04-17 | Allendale | South Carolina | 45005 | 6 | 0 |
69414 | 69414 | 2020-04-18 | Allendale | South Carolina | 45005 | 6 | 0 |
72181 | 72181 | 2020-04-19 | Allendale | South Carolina | 45005 | 6 | 0 |
74956 | 74956 | 2020-04-20 | Allendale | South Carolina | 45005 | 6 | 0 |
77738 | 77738 | 2020-04-21 | Allendale | South Carolina | 45005 | 6 | 0 |
80528 | 80528 | 2020-04-22 | Allendale | South Carolina | 45005 | 6 | 0 |
83327 | 83327 | 2020-04-23 | Allendale | South Carolina | 45005 | 7 | 1 |
86131 | 86131 | 2020-04-24 | Allendale | South Carolina | 45005 | 8 | 1 |
88945 | 88945 | 2020-04-25 | Allendale | South Carolina | 45005 | 8 | 1 |
91761 | 91761 | 2020-04-26 | Allendale | South Carolina | 45005 | 8 | 1 |
94588 | 94588 | 2020-04-27 | Allendale | South Carolina | 45005 | 8 | 1 |
97427 | 97427 | 2020-04-28 | Allendale | South Carolina | 45005 | 10 | 1 |
100276 | 100276 | 2020-04-29 | Allendale | South Carolina | 45005 | 10 | 1 |
103129 | 103129 | 2020-04-30 | Allendale | South Carolina | 45005 | 10 | 1 |
105992 | 105992 | 2020-05-01 | Allendale | South Carolina | 45005 | 11 | 1 |
108859 | 108859 | 2020-05-02 | Allendale | South Carolina | 45005 | 11 | 1 |
111733 | 111733 | 2020-05-03 | Allendale | South Carolina | 45005 | 12 | 1 |
114615 | 114615 | 2020-05-04 | Allendale | South Carolina | 45005 | 14 | 1 |
117571 | 117571 | 2020-05-05 | Allendale | South Carolina | 45005 | 18 | 1 |
120533 | 120533 | 2020-05-06 | Allendale | South Carolina | 45005 | 18 | 2 |
123511 | 123511 | 2020-05-07 | Allendale | South Carolina | 45005 | 19 | 3 |
126494 | 126494 | 2020-05-08 | Allendale | South Carolina | 45005 | 23 | 3 |
129483 | 129483 | 2020-05-09 | Allendale | South Carolina | 45005 | 24 | 3 |
132472 | 132472 | 2020-05-10 | Allendale | South Carolina | 45005 | 25 | 3 |
135463 | 135463 | 2020-05-11 | Allendale | South Carolina | 45005 | 26 | 3 |
138453 | 138453 | 2020-05-12 | Allendale | South Carolina | 45005 | 27 | 3 |
141449 | 141449 | 2020-05-13 | Allendale | South Carolina | 45005 | 29 | 3 |
144445 | 144445 | 2020-05-14 | Allendale | South Carolina | 45005 | 29 | 3 |
147446 | 147446 | 2020-05-15 | Allendale | South Carolina | 45005 | 30 | 3 |
150454 | 150454 | 2020-05-16 | Allendale | South Carolina | 45005 | 31 | 3 |
153465 | 153465 | 2020-05-17 | Allendale | South Carolina | 45005 | 33 | 3 |
156482 | 156482 | 2020-05-18 | Allendale | South Carolina | 45005 | 33 | 3 |
159503 | 159503 | 2020-05-19 | Allendale | South Carolina | 45005 | 33 | 3 |
162530 | 162530 | 2020-05-20 | Allendale | South Carolina | 45005 | 33 | 3 |
165559 | 165559 | 2020-05-21 | Allendale | South Carolina | 45005 | 34 | 3 |
168595 | 168595 | 2020-05-22 | Allendale | South Carolina | 45005 | 34 | 3 |
171634 | 171634 | 2020-05-23 | Allendale | South Carolina | 45005 | 34 | 3 |
174676 | 174676 | 2020-05-24 | Allendale | South Carolina | 45005 | 34 | 3 |
177720 | 177720 | 2020-05-25 | Allendale | South Carolina | 45005 | 34 | 3 |
180763 | 180763 | 2020-05-26 | Allendale | South Carolina | 45005 | 34 | 3 |
183813 | 183813 | 2020-05-27 | Allendale | South Carolina | 45005 | 34 | 3 |
186870 | 186870 | 2020-05-28 | Allendale | South Carolina | 45005 | 34 | 3 |
189932 | 189932 | 2020-05-29 | Allendale | South Carolina | 45005 | 34 | 3 |
192997 | 192997 | 2020-05-30 | Allendale | South Carolina | 45005 | 34 | 3 |
196066 | 196066 | 2020-05-31 | Allendale | South Carolina | 45005 | 35 | 3 |
199139 | 199139 | 2020-06-01 | Allendale | South Carolina | 45005 | 38 | 3 |
202214 | 202214 | 2020-06-02 | Allendale | South Carolina | 45005 | 38 | 3 |
205291 | 205291 | 2020-06-03 | Allendale | South Carolina | 45005 | 39 | 3 |
208372 | 208372 | 2020-06-04 | Allendale | South Carolina | 45005 | 40 | 3 |
211454 | 211454 | 2020-06-05 | Allendale | South Carolina | 45005 | 39 | 3 |
214540 | 214540 | 2020-06-06 | Allendale | South Carolina | 45005 | 39 | 3 |
217630 | 217630 | 2020-06-07 | Allendale | South Carolina | 45005 | 39 | 3 |
220722 | 220722 | 2020-06-08 | Allendale | South Carolina | 45005 | 39 | 3 |
223817 | 223817 | 2020-06-09 | Allendale | South Carolina | 45005 | 39 | 3 |
226917 | 226917 | 2020-06-10 | Allendale | South Carolina | 45005 | 39 | 3 |
230021 | 230021 | 2020-06-11 | Allendale | South Carolina | 45005 | 40 | 3 |
233126 | 233126 | 2020-06-12 | Allendale | South Carolina | 45005 | 40 | 3 |
236231 | 236231 | 2020-06-13 | Allendale | South Carolina | 45005 | 40 | 3 |
239339 | 239339 | 2020-06-14 | Allendale | South Carolina | 45005 | 40 | 3 |
242448 | 242448 | 2020-06-15 | Allendale | South Carolina | 45005 | 40 | 3 |
245560 | 245560 | 2020-06-16 | Allendale | South Carolina | 45005 | 41 | 3 |
248673 | 248673 | 2020-06-17 | Allendale | South Carolina | 45005 | 41 | 3 |
251788 | 251788 | 2020-06-18 | Allendale | South Carolina | 45005 | 41 | 3 |
254903 | 254903 | 2020-06-19 | Allendale | South Carolina | 45005 | 45 | 3 |
258029 | 258029 | 2020-06-20 | Allendale | South Carolina | 45005 | 45 | 3 |
261156 | 261156 | 2020-06-21 | Allendale | South Carolina | 45005 | 45 | 3 |
264284 | 264284 | 2020-06-22 | Allendale | South Carolina | 45005 | 46 | 3 |
267412 | 267412 | 2020-06-23 | Allendale | South Carolina | 45005 | 46 | 3 |
270546 | 270546 | 2020-06-24 | Allendale | South Carolina | 45005 | 46 | 3 |
273685 | 273685 | 2020-06-25 | Allendale | South Carolina | 45005 | 47 | 3 |
276832 | 276832 | 2020-06-26 | Allendale | South Carolina | 45005 | 47 | 3 |
279980 | 279980 | 2020-06-27 | Allendale | South Carolina | 45005 | 48 | 3 |
283126 | 283126 | 2020-06-28 | Allendale | South Carolina | 45005 | 48 | 3 |
286271 | 286271 | 2020-06-29 | Allendale | South Carolina | 45005 | 48 | 3 |
289422 | 289422 | 2020-06-30 | Allendale | South Carolina | 45005 | 48 | 3 |
292574 | 292574 | 2020-07-01 | Allendale | South Carolina | 45005 | 50 | 3 |
295730 | 295730 | 2020-07-02 | Allendale | South Carolina | 45005 | 58 | 3 |
298889 | 298889 | 2020-07-03 | Allendale | South Carolina | 45005 | 58 | 3 |
302053 | 302053 | 2020-07-04 | Allendale | South Carolina | 45005 | 58 | 3 |
305216 | 305216 | 2020-07-05 | Allendale | South Carolina | 45005 | 61 | 3 |
308383 | 308383 | 2020-07-06 | Allendale | South Carolina | 45005 | 64 | 3 |
311552 | 311552 | 2020-07-07 | Allendale | South Carolina | 45005 | 64 | 3 |
314724 | 314724 | 2020-07-08 | Allendale | South Carolina | 45005 | 64 | 3 |
317897 | 317897 | 2020-07-09 | Allendale | South Carolina | 45005 | 73 | 3 |
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);