ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Marion" and state = "South Carolina" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
12031 | 12031 | 2020-03-25 | Marion | South Carolina | 45067 | 1 | 0 |
13653 | 13653 | 2020-03-26 | Marion | South Carolina | 45067 | 1 | 0 |
15400 | 15400 | 2020-03-27 | Marion | South Carolina | 45067 | 1 | 0 |
17255 | 17255 | 2020-03-28 | Marion | South Carolina | 45067 | 1 | 0 |
19195 | 19195 | 2020-03-29 | Marion | South Carolina | 45067 | 1 | 0 |
21247 | 21247 | 2020-03-30 | Marion | South Carolina | 45067 | 2 | 0 |
23385 | 23385 | 2020-03-31 | Marion | South Carolina | 45067 | 2 | 1 |
25583 | 25583 | 2020-04-01 | Marion | South Carolina | 45067 | 2 | 1 |
27858 | 27858 | 2020-04-02 | Marion | South Carolina | 45067 | 2 | 1 |
30193 | 30193 | 2020-04-03 | Marion | South Carolina | 45067 | 2 | 1 |
32584 | 32584 | 2020-04-04 | Marion | South Carolina | 45067 | 2 | 1 |
35020 | 35020 | 2020-04-05 | Marion | South Carolina | 45067 | 2 | 1 |
37495 | 37495 | 2020-04-06 | Marion | South Carolina | 45067 | 4 | 1 |
40018 | 40018 | 2020-04-07 | Marion | South Carolina | 45067 | 5 | 1 |
42578 | 42578 | 2020-04-08 | Marion | South Carolina | 45067 | 5 | 1 |
45164 | 45164 | 2020-04-09 | Marion | South Carolina | 45067 | 5 | 1 |
47781 | 47781 | 2020-04-10 | Marion | South Carolina | 45067 | 5 | 1 |
50438 | 50438 | 2020-04-11 | Marion | South Carolina | 45067 | 6 | 1 |
53111 | 53111 | 2020-04-12 | Marion | South Carolina | 45067 | 7 | 1 |
55796 | 55796 | 2020-04-13 | Marion | South Carolina | 45067 | 6 | 1 |
58499 | 58499 | 2020-04-14 | Marion | South Carolina | 45067 | 8 | 1 |
61214 | 61214 | 2020-04-15 | Marion | South Carolina | 45067 | 8 | 1 |
63940 | 63940 | 2020-04-16 | Marion | South Carolina | 45067 | 8 | 1 |
66686 | 66686 | 2020-04-17 | Marion | South Carolina | 45067 | 14 | 1 |
69444 | 69444 | 2020-04-18 | Marion | South Carolina | 45067 | 13 | 1 |
72211 | 72211 | 2020-04-19 | Marion | South Carolina | 45067 | 15 | 1 |
74986 | 74986 | 2020-04-20 | Marion | South Carolina | 45067 | 15 | 1 |
77768 | 77768 | 2020-04-21 | Marion | South Carolina | 45067 | 19 | 1 |
80558 | 80558 | 2020-04-22 | Marion | South Carolina | 45067 | 22 | 1 |
83357 | 83357 | 2020-04-23 | Marion | South Carolina | 45067 | 22 | 1 |
86161 | 86161 | 2020-04-24 | Marion | South Carolina | 45067 | 24 | 1 |
88975 | 88975 | 2020-04-25 | Marion | South Carolina | 45067 | 29 | 1 |
91791 | 91791 | 2020-04-26 | Marion | South Carolina | 45067 | 32 | 1 |
94618 | 94618 | 2020-04-27 | Marion | South Carolina | 45067 | 33 | 1 |
97457 | 97457 | 2020-04-28 | Marion | South Carolina | 45067 | 32 | 1 |
100306 | 100306 | 2020-04-29 | Marion | South Carolina | 45067 | 32 | 2 |
103159 | 103159 | 2020-04-30 | Marion | South Carolina | 45067 | 34 | 2 |
106022 | 106022 | 2020-05-01 | Marion | South Carolina | 45067 | 36 | 2 |
108889 | 108889 | 2020-05-02 | Marion | South Carolina | 45067 | 37 | 2 |
111763 | 111763 | 2020-05-03 | Marion | South Carolina | 45067 | 37 | 2 |
114645 | 114645 | 2020-05-04 | Marion | South Carolina | 45067 | 40 | 2 |
117601 | 117601 | 2020-05-05 | Marion | South Carolina | 45067 | 41 | 2 |
120563 | 120563 | 2020-05-06 | Marion | South Carolina | 45067 | 41 | 2 |
123541 | 123541 | 2020-05-07 | Marion | South Carolina | 45067 | 43 | 2 |
126524 | 126524 | 2020-05-08 | Marion | South Carolina | 45067 | 44 | 2 |
129513 | 129513 | 2020-05-09 | Marion | South Carolina | 45067 | 47 | 2 |
132502 | 132502 | 2020-05-10 | Marion | South Carolina | 45067 | 48 | 3 |
135493 | 135493 | 2020-05-11 | Marion | South Carolina | 45067 | 49 | 3 |
138483 | 138483 | 2020-05-12 | Marion | South Carolina | 45067 | 50 | 3 |
141479 | 141479 | 2020-05-13 | Marion | South Carolina | 45067 | 48 | 4 |
144475 | 144475 | 2020-05-14 | Marion | South Carolina | 45067 | 47 | 4 |
147476 | 147476 | 2020-05-15 | Marion | South Carolina | 45067 | 48 | 4 |
150484 | 150484 | 2020-05-16 | Marion | South Carolina | 45067 | 51 | 4 |
153495 | 153495 | 2020-05-17 | Marion | South Carolina | 45067 | 51 | 4 |
156512 | 156512 | 2020-05-18 | Marion | South Carolina | 45067 | 52 | 4 |
159533 | 159533 | 2020-05-19 | Marion | South Carolina | 45067 | 53 | 4 |
162560 | 162560 | 2020-05-20 | Marion | South Carolina | 45067 | 56 | 4 |
165589 | 165589 | 2020-05-21 | Marion | South Carolina | 45067 | 57 | 4 |
168625 | 168625 | 2020-05-22 | Marion | South Carolina | 45067 | 60 | 4 |
171664 | 171664 | 2020-05-23 | Marion | South Carolina | 45067 | 63 | 5 |
174706 | 174706 | 2020-05-24 | Marion | South Carolina | 45067 | 64 | 5 |
177750 | 177750 | 2020-05-25 | Marion | South Carolina | 45067 | 65 | 5 |
180793 | 180793 | 2020-05-26 | Marion | South Carolina | 45067 | 66 | 5 |
183843 | 183843 | 2020-05-27 | Marion | South Carolina | 45067 | 67 | 5 |
186900 | 186900 | 2020-05-28 | Marion | South Carolina | 45067 | 67 | 5 |
189962 | 189962 | 2020-05-29 | Marion | South Carolina | 45067 | 68 | 5 |
193027 | 193027 | 2020-05-30 | Marion | South Carolina | 45067 | 68 | 5 |
196096 | 196096 | 2020-05-31 | Marion | South Carolina | 45067 | 69 | 5 |
199169 | 199169 | 2020-06-01 | Marion | South Carolina | 45067 | 71 | 5 |
202244 | 202244 | 2020-06-02 | Marion | South Carolina | 45067 | 72 | 5 |
205321 | 205321 | 2020-06-03 | Marion | South Carolina | 45067 | 73 | 5 |
208402 | 208402 | 2020-06-04 | Marion | South Carolina | 45067 | 74 | 5 |
211484 | 211484 | 2020-06-05 | Marion | South Carolina | 45067 | 74 | 5 |
214570 | 214570 | 2020-06-06 | Marion | South Carolina | 45067 | 79 | 5 |
217660 | 217660 | 2020-06-07 | Marion | South Carolina | 45067 | 84 | 5 |
220752 | 220752 | 2020-06-08 | Marion | South Carolina | 45067 | 84 | 5 |
223847 | 223847 | 2020-06-09 | Marion | South Carolina | 45067 | 83 | 5 |
226947 | 226947 | 2020-06-10 | Marion | South Carolina | 45067 | 83 | 5 |
230051 | 230051 | 2020-06-11 | Marion | South Carolina | 45067 | 86 | 5 |
233156 | 233156 | 2020-06-12 | Marion | South Carolina | 45067 | 88 | 5 |
236261 | 236261 | 2020-06-13 | Marion | South Carolina | 45067 | 95 | 5 |
239369 | 239369 | 2020-06-14 | Marion | South Carolina | 45067 | 103 | 5 |
242478 | 242478 | 2020-06-15 | Marion | South Carolina | 45067 | 105 | 5 |
245590 | 245590 | 2020-06-16 | Marion | South Carolina | 45067 | 108 | 5 |
248703 | 248703 | 2020-06-17 | Marion | South Carolina | 45067 | 113 | 5 |
251818 | 251818 | 2020-06-18 | Marion | South Carolina | 45067 | 118 | 5 |
254933 | 254933 | 2020-06-19 | Marion | South Carolina | 45067 | 122 | 5 |
258059 | 258059 | 2020-06-20 | Marion | South Carolina | 45067 | 141 | 5 |
261186 | 261186 | 2020-06-21 | Marion | South Carolina | 45067 | 146 | 5 |
264314 | 264314 | 2020-06-22 | Marion | South Carolina | 45067 | 155 | 6 |
267442 | 267442 | 2020-06-23 | Marion | South Carolina | 45067 | 159 | 6 |
270576 | 270576 | 2020-06-24 | Marion | South Carolina | 45067 | 164 | 6 |
273715 | 273715 | 2020-06-25 | Marion | South Carolina | 45067 | 170 | 6 |
276862 | 276862 | 2020-06-26 | Marion | South Carolina | 45067 | 171 | 6 |
280010 | 280010 | 2020-06-27 | Marion | South Carolina | 45067 | 176 | 7 |
283156 | 283156 | 2020-06-28 | Marion | South Carolina | 45067 | 191 | 7 |
286301 | 286301 | 2020-06-29 | Marion | South Carolina | 45067 | 193 | 7 |
289452 | 289452 | 2020-06-30 | Marion | South Carolina | 45067 | 208 | 7 |
292604 | 292604 | 2020-07-01 | Marion | South Carolina | 45067 | 212 | 7 |
295760 | 295760 | 2020-07-02 | Marion | South Carolina | 45067 | 214 | 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);