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, date (date)
deaths 215 ✖
- 211 48
- 390 23
- 19 16
- 77 13
- 6 11
- 210 11
- 293 11
- 383 11
- 18 10
- 197 10
- 206 10
- 208 10
- 3 9
- 12 9
- 201 9
- 84 8
- 393 8
- 2 7
- 17 7
- 78 7
- 98 7
- 133 7
- 174 7
- 196 7
- 202 7
- 209 7
- 212 7
- 290 7
- 306 7
- 327 7
- 386 7
- 389 7
- 88 6
- 103 6
- 125 6
- 153 6
- 205 6
- 292 6
- 304 6
- 309 6
- 310 6
- 312 6
- 356 6
- 23 5
- 59 5
- 74 5
- 89 5
- 92 5
- 94 5
- 100 5
- 194 5
- 214 5
- 269 5
- 316 5
- 358 5
- 391 5
- 0 4
- 4 4
- 13 4
- 21 4
- 25 4
- 45 4
- 56 4
- 111 4
- 113 4
- 115 4
- 168 4
- 175 4
- 181 4
- 225 4
- 237 4
- 296 4
- 300 4
- 302 4
- 303 4
- 305 4
- 323 4
- 344 4
- 370 4
- 11 3
- 27 3
- 31 3
- 34 3
- 53 3
- 64 3
- 69 3
- 70 3
- 83 3
- 117 3
- 122 3
- 123 3
- 132 3
- 190 3
- 245 3
- 253 3
- 264 3
- 275 3
- 280 3
- 284 3
- 307 3
- 324 3
- 329 3
- 353 3
- 359 3
- 365 3
- 394 3
- 1 2
- 5 2
- 16 2
- 20 2
- 22 2
- 29 2
- 30 2
- 35 2
- 39 2
- 40 2
- 42 2
- 47 2
- 51 2
- 63 2
- 66 2
- 85 2
- 93 2
- 97 2
- 101 2
- 105 2
- 109 2
- 140 2
- 148 2
- 157 2
- 161 2
- 173 2
- 177 2
- 185 2
- 187 2
- 203 2
- 213 2
- 222 2
- 241 2
- 250 2
- 259 2
- 301 2
- 320 2
- 322 2
- 337 2
- 382 2
- 7 1
- 26 1
- 32 1
- 33 1
- 38 1
- 43 1
- 46 1
- 50 1
- 52 1
- 57 1
- 60 1
- 61 1
- 65 1
- 71 1
- 79 1
- 81 1
- 82 1
- 90 1
- 91 1
- 95 1
- 96 1
- 104 1
- 107 1
- 108 1
- 112 1
- 114 1
- 124 1
- 127 1
- 135 1
- 139 1
- 141 1
- 149 1
- 151 1
- 158 1
- 159 1
- 162 1
- 163 1
- 164 1
- 166 1
- 169 1
- 191 1
- 192 1
- 195 1
- 198 1
- 204 1
- 207 1
- 223 1
- 230 1
- 231 1
- 235 1
- 242 1
- 243 1
- 247 1
- 248 1
- 254 1
- 258 1
- 266 1
- 268 1
- 278 1
- 285 1
- 308 1
- 313 1
- 340 1
- 357 1
- 366 1
- 368 1
- 369 1
- 376 1
- 379 1
state 1
- South Carolina 785
fips 1
- 45085 · 785 ✖
county 1
- Sumter 785
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);