ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 45039 and state = "South Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3113 | 3113 | 2020-03-16 | Fairfield | South Carolina | 45039 | 1 | 0 |
3644 | 3644 | 2020-03-17 | Fairfield | South Carolina | 45039 | 1 | 0 |
4263 | 4263 | 2020-03-18 | Fairfield | South Carolina | 45039 | 1 | 0 |
5007 | 5007 | 2020-03-19 | Fairfield | South Carolina | 45039 | 1 | 0 |
5884 | 5884 | 2020-03-20 | Fairfield | South Carolina | 45039 | 1 | 0 |
6890 | 6890 | 2020-03-21 | Fairfield | South Carolina | 45039 | 1 | 0 |
8011 | 8011 | 2020-03-22 | Fairfield | South Carolina | 45039 | 1 | 0 |
9223 | 9223 | 2020-03-23 | Fairfield | South Carolina | 45039 | 2 | 0 |
10549 | 10549 | 2020-03-24 | Fairfield | South Carolina | 45039 | 2 | 0 |
12020 | 12020 | 2020-03-25 | Fairfield | South Carolina | 45039 | 3 | 0 |
13642 | 13642 | 2020-03-26 | Fairfield | South Carolina | 45039 | 4 | 0 |
15389 | 15389 | 2020-03-27 | Fairfield | South Carolina | 45039 | 4 | 0 |
17243 | 17243 | 2020-03-28 | Fairfield | South Carolina | 45039 | 4 | 0 |
19183 | 19183 | 2020-03-29 | Fairfield | South Carolina | 45039 | 4 | 0 |
21235 | 21235 | 2020-03-30 | Fairfield | South Carolina | 45039 | 5 | 0 |
23373 | 23373 | 2020-03-31 | Fairfield | South Carolina | 45039 | 6 | 0 |
25571 | 25571 | 2020-04-01 | Fairfield | South Carolina | 45039 | 7 | 0 |
27845 | 27845 | 2020-04-02 | Fairfield | South Carolina | 45039 | 8 | 0 |
30180 | 30180 | 2020-04-03 | Fairfield | South Carolina | 45039 | 8 | 0 |
32571 | 32571 | 2020-04-04 | Fairfield | South Carolina | 45039 | 12 | 0 |
35007 | 35007 | 2020-04-05 | Fairfield | South Carolina | 45039 | 14 | 0 |
37482 | 37482 | 2020-04-06 | Fairfield | South Carolina | 45039 | 16 | 0 |
40005 | 40005 | 2020-04-07 | Fairfield | South Carolina | 45039 | 17 | 0 |
42565 | 42565 | 2020-04-08 | Fairfield | South Carolina | 45039 | 16 | 0 |
45151 | 45151 | 2020-04-09 | Fairfield | South Carolina | 45039 | 17 | 0 |
47768 | 47768 | 2020-04-10 | Fairfield | South Carolina | 45039 | 18 | 0 |
50425 | 50425 | 2020-04-11 | Fairfield | South Carolina | 45039 | 21 | 0 |
53098 | 53098 | 2020-04-12 | Fairfield | South Carolina | 45039 | 21 | 0 |
55783 | 55783 | 2020-04-13 | Fairfield | South Carolina | 45039 | 23 | 0 |
58486 | 58486 | 2020-04-14 | Fairfield | South Carolina | 45039 | 24 | 0 |
61201 | 61201 | 2020-04-15 | Fairfield | South Carolina | 45039 | 24 | 0 |
63927 | 63927 | 2020-04-16 | Fairfield | South Carolina | 45039 | 25 | 0 |
66673 | 66673 | 2020-04-17 | Fairfield | South Carolina | 45039 | 25 | 0 |
69431 | 69431 | 2020-04-18 | Fairfield | South Carolina | 45039 | 25 | 0 |
72198 | 72198 | 2020-04-19 | Fairfield | South Carolina | 45039 | 25 | 0 |
74973 | 74973 | 2020-04-20 | Fairfield | South Carolina | 45039 | 25 | 0 |
77755 | 77755 | 2020-04-21 | Fairfield | South Carolina | 45039 | 26 | 0 |
80545 | 80545 | 2020-04-22 | Fairfield | South Carolina | 45039 | 26 | 0 |
83344 | 83344 | 2020-04-23 | Fairfield | South Carolina | 45039 | 27 | 2 |
86148 | 86148 | 2020-04-24 | Fairfield | South Carolina | 45039 | 28 | 2 |
88962 | 88962 | 2020-04-25 | Fairfield | South Carolina | 45039 | 29 | 2 |
91778 | 91778 | 2020-04-26 | Fairfield | South Carolina | 45039 | 33 | 2 |
94605 | 94605 | 2020-04-27 | Fairfield | South Carolina | 45039 | 33 | 2 |
97444 | 97444 | 2020-04-28 | Fairfield | South Carolina | 45039 | 33 | 2 |
100293 | 100293 | 2020-04-29 | Fairfield | South Carolina | 45039 | 34 | 2 |
103146 | 103146 | 2020-04-30 | Fairfield | South Carolina | 45039 | 36 | 2 |
106009 | 106009 | 2020-05-01 | Fairfield | South Carolina | 45039 | 36 | 2 |
108876 | 108876 | 2020-05-02 | Fairfield | South Carolina | 45039 | 42 | 2 |
111750 | 111750 | 2020-05-03 | Fairfield | South Carolina | 45039 | 68 | 2 |
114632 | 114632 | 2020-05-04 | Fairfield | South Carolina | 45039 | 68 | 2 |
117588 | 117588 | 2020-05-05 | Fairfield | South Carolina | 45039 | 71 | 2 |
120550 | 120550 | 2020-05-06 | Fairfield | South Carolina | 45039 | 74 | 2 |
123528 | 123528 | 2020-05-07 | Fairfield | South Carolina | 45039 | 75 | 3 |
126511 | 126511 | 2020-05-08 | Fairfield | South Carolina | 45039 | 76 | 3 |
129500 | 129500 | 2020-05-09 | Fairfield | South Carolina | 45039 | 80 | 4 |
132489 | 132489 | 2020-05-10 | Fairfield | South Carolina | 45039 | 80 | 4 |
135480 | 135480 | 2020-05-11 | Fairfield | South Carolina | 45039 | 81 | 5 |
138470 | 138470 | 2020-05-12 | Fairfield | South Carolina | 45039 | 82 | 5 |
141466 | 141466 | 2020-05-13 | Fairfield | South Carolina | 45039 | 83 | 5 |
144462 | 144462 | 2020-05-14 | Fairfield | South Carolina | 45039 | 96 | 7 |
147463 | 147463 | 2020-05-15 | Fairfield | South Carolina | 45039 | 108 | 8 |
150471 | 150471 | 2020-05-16 | Fairfield | South Carolina | 45039 | 120 | 8 |
153482 | 153482 | 2020-05-17 | Fairfield | South Carolina | 45039 | 122 | 8 |
156499 | 156499 | 2020-05-18 | Fairfield | South Carolina | 45039 | 128 | 8 |
159520 | 159520 | 2020-05-19 | Fairfield | South Carolina | 45039 | 134 | 8 |
162547 | 162547 | 2020-05-20 | Fairfield | South Carolina | 45039 | 139 | 9 |
165576 | 165576 | 2020-05-21 | Fairfield | South Carolina | 45039 | 152 | 9 |
168612 | 168612 | 2020-05-22 | Fairfield | South Carolina | 45039 | 155 | 9 |
171651 | 171651 | 2020-05-23 | Fairfield | South Carolina | 45039 | 158 | 9 |
174693 | 174693 | 2020-05-24 | Fairfield | South Carolina | 45039 | 159 | 9 |
177737 | 177737 | 2020-05-25 | Fairfield | South Carolina | 45039 | 160 | 9 |
180780 | 180780 | 2020-05-26 | Fairfield | South Carolina | 45039 | 160 | 10 |
183830 | 183830 | 2020-05-27 | Fairfield | South Carolina | 45039 | 163 | 13 |
186887 | 186887 | 2020-05-28 | Fairfield | South Carolina | 45039 | 163 | 14 |
189949 | 189949 | 2020-05-29 | Fairfield | South Carolina | 45039 | 168 | 15 |
193014 | 193014 | 2020-05-30 | Fairfield | South Carolina | 45039 | 174 | 15 |
196083 | 196083 | 2020-05-31 | Fairfield | South Carolina | 45039 | 179 | 15 |
199156 | 199156 | 2020-06-01 | Fairfield | South Carolina | 45039 | 181 | 17 |
202231 | 202231 | 2020-06-02 | Fairfield | South Carolina | 45039 | 181 | 17 |
205308 | 205308 | 2020-06-03 | Fairfield | South Carolina | 45039 | 185 | 17 |
208389 | 208389 | 2020-06-04 | Fairfield | South Carolina | 45039 | 194 | 17 |
211471 | 211471 | 2020-06-05 | Fairfield | South Carolina | 45039 | 203 | 17 |
214557 | 214557 | 2020-06-06 | Fairfield | South Carolina | 45039 | 208 | 17 |
217647 | 217647 | 2020-06-07 | Fairfield | South Carolina | 45039 | 206 | 17 |
220739 | 220739 | 2020-06-08 | Fairfield | South Carolina | 45039 | 211 | 17 |
223834 | 223834 | 2020-06-09 | Fairfield | South Carolina | 45039 | 216 | 19 |
226934 | 226934 | 2020-06-10 | Fairfield | South Carolina | 45039 | 219 | 19 |
230038 | 230038 | 2020-06-11 | Fairfield | South Carolina | 45039 | 224 | 20 |
233143 | 233143 | 2020-06-12 | Fairfield | South Carolina | 45039 | 223 | 20 |
236248 | 236248 | 2020-06-13 | Fairfield | South Carolina | 45039 | 225 | 20 |
239356 | 239356 | 2020-06-14 | Fairfield | South Carolina | 45039 | 227 | 20 |
242465 | 242465 | 2020-06-15 | Fairfield | South Carolina | 45039 | 231 | 20 |
245577 | 245577 | 2020-06-16 | Fairfield | South Carolina | 45039 | 232 | 20 |
248690 | 248690 | 2020-06-17 | Fairfield | South Carolina | 45039 | 233 | 20 |
251805 | 251805 | 2020-06-18 | Fairfield | South Carolina | 45039 | 238 | 20 |
254920 | 254920 | 2020-06-19 | Fairfield | South Carolina | 45039 | 246 | 20 |
258046 | 258046 | 2020-06-20 | Fairfield | South Carolina | 45039 | 253 | 20 |
261173 | 261173 | 2020-06-21 | Fairfield | South Carolina | 45039 | 257 | 20 |
264301 | 264301 | 2020-06-22 | Fairfield | South Carolina | 45039 | 259 | 20 |
267429 | 267429 | 2020-06-23 | Fairfield | South Carolina | 45039 | 266 | 21 |
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);