ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 45027 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 122 ✖
- 114 67
- 157 55
- 136 49
- 113 35
- 68 25
- 69 25
- 137 23
- 135 19
- 66 15
- 41 14
- 74 14
- 134 14
- 1 13
- 105 13
- 138 13
- 70 12
- 112 12
- 67 11
- 81 11
- 102 11
- 109 11
- 141 11
- 159 11
- 42 10
- 107 10
- 47 9
- 152 8
- 43 7
- 50 7
- 63 7
- 82 7
- 116 7
- 132 7
- 154 7
- 6 6
- 38 6
- 39 6
- 61 6
- 103 6
- 111 6
- 49 5
- 62 5
- 72 5
- 89 5
- 145 5
- 9 4
- 24 4
- 84 4
- 91 4
- 94 4
- 121 4
- 148 4
- 0 3
- 2 3
- 3 3
- 4 3
- 40 3
- 45 3
- 48 3
- 51 3
- 59 3
- 64 3
- 65 3
- 80 3
- 100 3
- 101 3
- 120 3
- 125 3
- 128 3
- 147 3
- 153 3
- 21 2
- 26 2
- 27 2
- 32 2
- 34 2
- 36 2
- 52 2
- 57 2
- 73 2
- 76 2
- 85 2
- 97 2
- 104 2
- 133 2
- 140 2
- 142 2
- 149 2
- 156 2
- 7 1
- 8 1
- 11 1
- 12 1
- 14 1
- 17 1
- 18 1
- 22 1
- 25 1
- 29 1
- 31 1
- 33 1
- 35 1
- 37 1
- 46 1
- 53 1
- 54 1
- 55 1
- 56 1
- 60 1
- 71 1
- 75 1
- 77 1
- 79 1
- 86 1
- 88 1
- 90 1
- 92 1
- 93 1
- 98 1
- 106 1
- 123 1
- 151 1
state 1
- South Carolina 785
fips 1
- 45027 · 785 ✖
county 1
- Clarendon 785
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5881 | 5881 | 2020-03-20 | Clarendon | South Carolina | 45027 | 1 | 0 |
6885 | 6885 | 2020-03-21 | Clarendon | South Carolina | 45027 | 1 | 0 |
8005 | 8005 | 2020-03-22 | Clarendon | South Carolina | 45027 | 1 | 0 |
9217 | 9217 | 2020-03-23 | Clarendon | South Carolina | 45027 | 4 | 1 |
10543 | 10543 | 2020-03-24 | Clarendon | South Carolina | 45027 | 5 | 1 |
12014 | 12014 | 2020-03-25 | Clarendon | South Carolina | 45027 | 5 | 1 |
13636 | 13636 | 2020-03-26 | Clarendon | South Carolina | 45027 | 5 | 1 |
15383 | 15383 | 2020-03-27 | Clarendon | South Carolina | 45027 | 6 | 1 |
17237 | 17237 | 2020-03-28 | Clarendon | South Carolina | 45027 | 7 | 1 |
19177 | 19177 | 2020-03-29 | Clarendon | South Carolina | 45027 | 16 | 1 |
21229 | 21229 | 2020-03-30 | Clarendon | South Carolina | 45027 | 18 | 1 |
23367 | 23367 | 2020-03-31 | Clarendon | South Carolina | 45027 | 25 | 1 |
25565 | 25565 | 2020-04-01 | Clarendon | South Carolina | 45027 | 28 | 1 |
27839 | 27839 | 2020-04-02 | Clarendon | South Carolina | 45027 | 31 | 1 |
30174 | 30174 | 2020-04-03 | Clarendon | South Carolina | 45027 | 34 | 1 |
32565 | 32565 | 2020-04-04 | Clarendon | South Carolina | 45027 | 45 | 1 |
35001 | 35001 | 2020-04-05 | Clarendon | South Carolina | 45027 | 54 | 2 |
37476 | 37476 | 2020-04-06 | Clarendon | South Carolina | 45027 | 58 | 2 |
39999 | 39999 | 2020-04-07 | Clarendon | South Carolina | 45027 | 68 | 2 |
42559 | 42559 | 2020-04-08 | Clarendon | South Carolina | 45027 | 72 | 3 |
45145 | 45145 | 2020-04-09 | Clarendon | South Carolina | 45027 | 75 | 3 |
47762 | 47762 | 2020-04-10 | Clarendon | South Carolina | 45027 | 80 | 3 |
50419 | 50419 | 2020-04-11 | Clarendon | South Carolina | 45027 | 85 | 4 |
53092 | 53092 | 2020-04-12 | Clarendon | South Carolina | 45027 | 85 | 4 |
55777 | 55777 | 2020-04-13 | Clarendon | South Carolina | 45027 | 86 | 4 |
58480 | 58480 | 2020-04-14 | Clarendon | South Carolina | 45027 | 89 | 6 |
61195 | 61195 | 2020-04-15 | Clarendon | South Carolina | 45027 | 90 | 6 |
63921 | 63921 | 2020-04-16 | Clarendon | South Carolina | 45027 | 98 | 6 |
66667 | 66667 | 2020-04-17 | Clarendon | South Carolina | 45027 | 106 | 6 |
69425 | 69425 | 2020-04-18 | Clarendon | South Carolina | 45027 | 109 | 6 |
72192 | 72192 | 2020-04-19 | Clarendon | South Carolina | 45027 | 112 | 6 |
74967 | 74967 | 2020-04-20 | Clarendon | South Carolina | 45027 | 120 | 7 |
77749 | 77749 | 2020-04-21 | Clarendon | South Carolina | 45027 | 126 | 8 |
80539 | 80539 | 2020-04-22 | Clarendon | South Carolina | 45027 | 138 | 9 |
83338 | 83338 | 2020-04-23 | Clarendon | South Carolina | 45027 | 151 | 9 |
86142 | 86142 | 2020-04-24 | Clarendon | South Carolina | 45027 | 163 | 9 |
88956 | 88956 | 2020-04-25 | Clarendon | South Carolina | 45027 | 172 | 9 |
91772 | 91772 | 2020-04-26 | Clarendon | South Carolina | 45027 | 181 | 11 |
94599 | 94599 | 2020-04-27 | Clarendon | South Carolina | 45027 | 185 | 12 |
97438 | 97438 | 2020-04-28 | Clarendon | South Carolina | 45027 | 194 | 14 |
100287 | 100287 | 2020-04-29 | Clarendon | South Carolina | 45027 | 201 | 17 |
103140 | 103140 | 2020-04-30 | Clarendon | South Carolina | 45027 | 210 | 18 |
106003 | 106003 | 2020-05-01 | Clarendon | South Carolina | 45027 | 214 | 21 |
108870 | 108870 | 2020-05-02 | Clarendon | South Carolina | 45027 | 218 | 21 |
111744 | 111744 | 2020-05-03 | Clarendon | South Carolina | 45027 | 229 | 22 |
114626 | 114626 | 2020-05-04 | Clarendon | South Carolina | 45027 | 232 | 24 |
117582 | 117582 | 2020-05-05 | Clarendon | South Carolina | 45027 | 237 | 24 |
120544 | 120544 | 2020-05-06 | Clarendon | South Carolina | 45027 | 248 | 24 |
123522 | 123522 | 2020-05-07 | Clarendon | South Carolina | 45027 | 253 | 24 |
126505 | 126505 | 2020-05-08 | Clarendon | South Carolina | 45027 | 258 | 25 |
129494 | 129494 | 2020-05-09 | Clarendon | South Carolina | 45027 | 262 | 26 |
132483 | 132483 | 2020-05-10 | Clarendon | South Carolina | 45027 | 263 | 26 |
135474 | 135474 | 2020-05-11 | Clarendon | South Carolina | 45027 | 265 | 27 |
138464 | 138464 | 2020-05-12 | Clarendon | South Carolina | 45027 | 267 | 27 |
141460 | 141460 | 2020-05-13 | Clarendon | South Carolina | 45027 | 266 | 29 |
144456 | 144456 | 2020-05-14 | Clarendon | South Carolina | 45027 | 266 | 31 |
147457 | 147457 | 2020-05-15 | Clarendon | South Carolina | 45027 | 274 | 33 |
150465 | 150465 | 2020-05-16 | Clarendon | South Carolina | 45027 | 274 | 32 |
153476 | 153476 | 2020-05-17 | Clarendon | South Carolina | 45027 | 286 | 32 |
156493 | 156493 | 2020-05-18 | Clarendon | South Carolina | 45027 | 290 | 34 |
159514 | 159514 | 2020-05-19 | Clarendon | South Carolina | 45027 | 293 | 34 |
162541 | 162541 | 2020-05-20 | Clarendon | South Carolina | 45027 | 290 | 35 |
165570 | 165570 | 2020-05-21 | Clarendon | South Carolina | 45027 | 288 | 36 |
168606 | 168606 | 2020-05-22 | Clarendon | South Carolina | 45027 | 289 | 36 |
171645 | 171645 | 2020-05-23 | Clarendon | South Carolina | 45027 | 289 | 37 |
174687 | 174687 | 2020-05-24 | Clarendon | South Carolina | 45027 | 293 | 38 |
177731 | 177731 | 2020-05-25 | Clarendon | South Carolina | 45027 | 293 | 38 |
180774 | 180774 | 2020-05-26 | Clarendon | South Carolina | 45027 | 294 | 38 |
183824 | 183824 | 2020-05-27 | Clarendon | South Carolina | 45027 | 295 | 38 |
186881 | 186881 | 2020-05-28 | Clarendon | South Carolina | 45027 | 296 | 38 |
189943 | 189943 | 2020-05-29 | Clarendon | South Carolina | 45027 | 296 | 38 |
193008 | 193008 | 2020-05-30 | Clarendon | South Carolina | 45027 | 301 | 39 |
196077 | 196077 | 2020-05-31 | Clarendon | South Carolina | 45027 | 301 | 39 |
199150 | 199150 | 2020-06-01 | Clarendon | South Carolina | 45027 | 301 | 39 |
202225 | 202225 | 2020-06-02 | Clarendon | South Carolina | 45027 | 302 | 39 |
205302 | 205302 | 2020-06-03 | Clarendon | South Carolina | 45027 | 302 | 39 |
208383 | 208383 | 2020-06-04 | Clarendon | South Carolina | 45027 | 301 | 39 |
211465 | 211465 | 2020-06-05 | Clarendon | South Carolina | 45027 | 304 | 40 |
214551 | 214551 | 2020-06-06 | Clarendon | South Carolina | 45027 | 305 | 40 |
217641 | 217641 | 2020-06-07 | Clarendon | South Carolina | 45027 | 306 | 40 |
220733 | 220733 | 2020-06-08 | Clarendon | South Carolina | 45027 | 306 | 41 |
223828 | 223828 | 2020-06-09 | Clarendon | South Carolina | 45027 | 309 | 41 |
226928 | 226928 | 2020-06-10 | Clarendon | South Carolina | 45027 | 311 | 41 |
230032 | 230032 | 2020-06-11 | Clarendon | South Carolina | 45027 | 320 | 41 |
233137 | 233137 | 2020-06-12 | Clarendon | South Carolina | 45027 | 325 | 41 |
236242 | 236242 | 2020-06-13 | Clarendon | South Carolina | 45027 | 327 | 41 |
239350 | 239350 | 2020-06-14 | Clarendon | South Carolina | 45027 | 335 | 41 |
242459 | 242459 | 2020-06-15 | Clarendon | South Carolina | 45027 | 343 | 41 |
245571 | 245571 | 2020-06-16 | Clarendon | South Carolina | 45027 | 342 | 41 |
248684 | 248684 | 2020-06-17 | Clarendon | South Carolina | 45027 | 347 | 41 |
251799 | 251799 | 2020-06-18 | Clarendon | South Carolina | 45027 | 346 | 41 |
254914 | 254914 | 2020-06-19 | Clarendon | South Carolina | 45027 | 349 | 41 |
258040 | 258040 | 2020-06-20 | Clarendon | South Carolina | 45027 | 357 | 41 |
261167 | 261167 | 2020-06-21 | Clarendon | South Carolina | 45027 | 359 | 41 |
264295 | 264295 | 2020-06-22 | Clarendon | South Carolina | 45027 | 365 | 42 |
267423 | 267423 | 2020-06-23 | Clarendon | South Carolina | 45027 | 373 | 42 |
270557 | 270557 | 2020-06-24 | Clarendon | South Carolina | 45027 | 378 | 42 |
273696 | 273696 | 2020-06-25 | Clarendon | South Carolina | 45027 | 387 | 42 |
276843 | 276843 | 2020-06-26 | Clarendon | South Carolina | 45027 | 403 | 42 |
279991 | 279991 | 2020-06-27 | Clarendon | South Carolina | 45027 | 406 | 42 |
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);