ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45085 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 |
---|---|---|---|---|---|---|---|
5897 | 5897 | 2020-03-20 | Sumter | South Carolina | 45085 | 1 | 0 |
6907 | 6907 | 2020-03-21 | Sumter | South Carolina | 45085 | 3 | 0 |
8028 | 8028 | 2020-03-22 | Sumter | South Carolina | 45085 | 3 | 0 |
9242 | 9242 | 2020-03-23 | Sumter | South Carolina | 45085 | 4 | 0 |
10568 | 10568 | 2020-03-24 | Sumter | South Carolina | 45085 | 8 | 1 |
12040 | 12040 | 2020-03-25 | Sumter | South Carolina | 45085 | 10 | 1 |
13662 | 13662 | 2020-03-26 | Sumter | South Carolina | 45085 | 10 | 2 |
15409 | 15409 | 2020-03-27 | Sumter | South Carolina | 45085 | 10 | 2 |
17264 | 17264 | 2020-03-28 | Sumter | South Carolina | 45085 | 24 | 2 |
19204 | 19204 | 2020-03-29 | Sumter | South Carolina | 45085 | 30 | 2 |
21256 | 21256 | 2020-03-30 | Sumter | South Carolina | 45085 | 34 | 2 |
23394 | 23394 | 2020-03-31 | Sumter | South Carolina | 45085 | 39 | 2 |
25592 | 25592 | 2020-04-01 | Sumter | South Carolina | 45085 | 48 | 2 |
27868 | 27868 | 2020-04-02 | Sumter | South Carolina | 45085 | 66 | 3 |
30203 | 30203 | 2020-04-03 | Sumter | South Carolina | 45085 | 75 | 3 |
32594 | 32594 | 2020-04-04 | Sumter | South Carolina | 45085 | 79 | 3 |
35030 | 35030 | 2020-04-05 | Sumter | South Carolina | 45085 | 80 | 3 |
37505 | 37505 | 2020-04-06 | Sumter | South Carolina | 45085 | 90 | 3 |
40028 | 40028 | 2020-04-07 | Sumter | South Carolina | 45085 | 105 | 3 |
42588 | 42588 | 2020-04-08 | Sumter | South Carolina | 45085 | 117 | 3 |
45174 | 45174 | 2020-04-09 | Sumter | South Carolina | 45085 | 126 | 3 |
47791 | 47791 | 2020-04-10 | Sumter | South Carolina | 45085 | 142 | 3 |
50448 | 50448 | 2020-04-11 | Sumter | South Carolina | 45085 | 146 | 4 |
53121 | 53121 | 2020-04-12 | Sumter | South Carolina | 45085 | 148 | 4 |
55806 | 55806 | 2020-04-13 | Sumter | South Carolina | 45085 | 152 | 4 |
58509 | 58509 | 2020-04-14 | Sumter | South Carolina | 45085 | 156 | 4 |
61224 | 61224 | 2020-04-15 | Sumter | South Carolina | 45085 | 161 | 5 |
63950 | 63950 | 2020-04-16 | Sumter | South Carolina | 45085 | 168 | 5 |
66696 | 66696 | 2020-04-17 | Sumter | South Carolina | 45085 | 176 | 6 |
69454 | 69454 | 2020-04-18 | Sumter | South Carolina | 45085 | 181 | 6 |
72221 | 72221 | 2020-04-19 | Sumter | South Carolina | 45085 | 181 | 6 |
74996 | 74996 | 2020-04-20 | Sumter | South Carolina | 45085 | 185 | 6 |
77778 | 77778 | 2020-04-21 | Sumter | South Carolina | 45085 | 199 | 6 |
80568 | 80568 | 2020-04-22 | Sumter | South Carolina | 45085 | 206 | 6 |
83367 | 83367 | 2020-04-23 | Sumter | South Carolina | 45085 | 207 | 6 |
86171 | 86171 | 2020-04-24 | Sumter | South Carolina | 45085 | 209 | 6 |
88985 | 88985 | 2020-04-25 | Sumter | South Carolina | 45085 | 213 | 6 |
91801 | 91801 | 2020-04-26 | Sumter | South Carolina | 45085 | 214 | 6 |
94628 | 94628 | 2020-04-27 | Sumter | South Carolina | 45085 | 215 | 6 |
97467 | 97467 | 2020-04-28 | Sumter | South Carolina | 45085 | 220 | 7 |
100316 | 100316 | 2020-04-29 | Sumter | South Carolina | 45085 | 223 | 11 |
103169 | 103169 | 2020-04-30 | Sumter | South Carolina | 45085 | 228 | 11 |
106032 | 106032 | 2020-05-01 | Sumter | South Carolina | 45085 | 230 | 11 |
108899 | 108899 | 2020-05-02 | Sumter | South Carolina | 45085 | 248 | 12 |
111773 | 111773 | 2020-05-03 | Sumter | South Carolina | 45085 | 251 | 12 |
114655 | 114655 | 2020-05-04 | Sumter | South Carolina | 45085 | 264 | 12 |
117611 | 117611 | 2020-05-05 | Sumter | South Carolina | 45085 | 270 | 12 |
120573 | 120573 | 2020-05-06 | Sumter | South Carolina | 45085 | 271 | 12 |
123551 | 123551 | 2020-05-07 | Sumter | South Carolina | 45085 | 277 | 12 |
126534 | 126534 | 2020-05-08 | Sumter | South Carolina | 45085 | 281 | 12 |
129523 | 129523 | 2020-05-09 | Sumter | South Carolina | 45085 | 286 | 12 |
132512 | 132512 | 2020-05-10 | Sumter | South Carolina | 45085 | 287 | 12 |
135503 | 135503 | 2020-05-11 | Sumter | South Carolina | 45085 | 290 | 13 |
138493 | 138493 | 2020-05-12 | Sumter | South Carolina | 45085 | 294 | 13 |
141489 | 141489 | 2020-05-13 | Sumter | South Carolina | 45085 | 296 | 13 |
144485 | 144485 | 2020-05-14 | Sumter | South Carolina | 45085 | 301 | 13 |
147486 | 147486 | 2020-05-15 | Sumter | South Carolina | 45085 | 313 | 16 |
150494 | 150494 | 2020-05-16 | Sumter | South Carolina | 45085 | 313 | 16 |
153505 | 153505 | 2020-05-17 | Sumter | South Carolina | 45085 | 321 | 17 |
156522 | 156522 | 2020-05-18 | Sumter | South Carolina | 45085 | 322 | 17 |
159543 | 159543 | 2020-05-19 | Sumter | South Carolina | 45085 | 323 | 17 |
162570 | 162570 | 2020-05-20 | Sumter | South Carolina | 45085 | 324 | 17 |
165599 | 165599 | 2020-05-21 | Sumter | South Carolina | 45085 | 331 | 17 |
168635 | 168635 | 2020-05-22 | Sumter | South Carolina | 45085 | 339 | 17 |
171674 | 171674 | 2020-05-23 | Sumter | South Carolina | 45085 | 344 | 17 |
174716 | 174716 | 2020-05-24 | Sumter | South Carolina | 45085 | 346 | 18 |
177760 | 177760 | 2020-05-25 | Sumter | South Carolina | 45085 | 347 | 18 |
180803 | 180803 | 2020-05-26 | Sumter | South Carolina | 45085 | 347 | 18 |
183853 | 183853 | 2020-05-27 | Sumter | South Carolina | 45085 | 357 | 18 |
186910 | 186910 | 2020-05-28 | Sumter | South Carolina | 45085 | 359 | 18 |
189972 | 189972 | 2020-05-29 | Sumter | South Carolina | 45085 | 365 | 18 |
193037 | 193037 | 2020-05-30 | Sumter | South Carolina | 45085 | 378 | 18 |
196106 | 196106 | 2020-05-31 | Sumter | South Carolina | 45085 | 384 | 18 |
199179 | 199179 | 2020-06-01 | Sumter | South Carolina | 45085 | 387 | 18 |
202254 | 202254 | 2020-06-02 | Sumter | South Carolina | 45085 | 396 | 18 |
205331 | 205331 | 2020-06-03 | Sumter | South Carolina | 45085 | 408 | 19 |
208412 | 208412 | 2020-06-04 | Sumter | South Carolina | 45085 | 414 | 19 |
211494 | 211494 | 2020-06-05 | Sumter | South Carolina | 45085 | 426 | 19 |
214580 | 214580 | 2020-06-06 | Sumter | South Carolina | 45085 | 448 | 19 |
217670 | 217670 | 2020-06-07 | Sumter | South Carolina | 45085 | 462 | 19 |
220762 | 220762 | 2020-06-08 | Sumter | South Carolina | 45085 | 472 | 19 |
223857 | 223857 | 2020-06-09 | Sumter | South Carolina | 45085 | 494 | 19 |
226957 | 226957 | 2020-06-10 | Sumter | South Carolina | 45085 | 509 | 19 |
230061 | 230061 | 2020-06-11 | Sumter | South Carolina | 45085 | 556 | 19 |
233166 | 233166 | 2020-06-12 | Sumter | South Carolina | 45085 | 580 | 19 |
236271 | 236271 | 2020-06-13 | Sumter | South Carolina | 45085 | 594 | 19 |
239379 | 239379 | 2020-06-14 | Sumter | South Carolina | 45085 | 626 | 19 |
242488 | 242488 | 2020-06-15 | Sumter | South Carolina | 45085 | 633 | 19 |
245600 | 245600 | 2020-06-16 | Sumter | South Carolina | 45085 | 648 | 19 |
248713 | 248713 | 2020-06-17 | Sumter | South Carolina | 45085 | 655 | 19 |
251828 | 251828 | 2020-06-18 | Sumter | South Carolina | 45085 | 690 | 19 |
254943 | 254943 | 2020-06-19 | Sumter | South Carolina | 45085 | 736 | 20 |
258069 | 258069 | 2020-06-20 | Sumter | South Carolina | 45085 | 776 | 20 |
261196 | 261196 | 2020-06-21 | Sumter | South Carolina | 45085 | 791 | 21 |
264324 | 264324 | 2020-06-22 | Sumter | South Carolina | 45085 | 825 | 21 |
267452 | 267452 | 2020-06-23 | Sumter | South Carolina | 45085 | 842 | 21 |
270586 | 270586 | 2020-06-24 | Sumter | South Carolina | 45085 | 867 | 21 |
273725 | 273725 | 2020-06-25 | Sumter | South Carolina | 45085 | 905 | 22 |
276872 | 276872 | 2020-06-26 | Sumter | South Carolina | 45085 | 945 | 22 |
280020 | 280020 | 2020-06-27 | Sumter | South Carolina | 45085 | 996 | 23 |
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);