ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Spalding" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 252 ✖
- 62 25
- 203 24
- 33 16
- 32 14
- 54 14
- 0 12
- 186 12
- 204 11
- 206 11
- 341 11
- 98 10
- 191 10
- 421 10
- 4 9
- 61 9
- 8 8
- 11 8
- 185 8
- 188 8
- 331 8
- 22 7
- 41 7
- 43 7
- 195 7
- 202 7
- 205 7
- 208 7
- 324 7
- 394 7
- 416 7
- 419 7
- 14 6
- 21 6
- 182 6
- 189 6
- 397 6
- 24 5
- 31 5
- 63 5
- 71 5
- 74 5
- 90 5
- 174 5
- 179 5
- 209 5
- 235 5
- 315 5
- 328 5
- 338 5
- 414 5
- 7 4
- 15 4
- 38 4
- 48 4
- 56 4
- 79 4
- 88 4
- 198 4
- 212 4
- 223 4
- 253 4
- 263 4
- 318 4
- 353 4
- 389 4
- 399 4
- 403 4
- 1 3
- 10 3
- 12 3
- 36 3
- 39 3
- 45 3
- 72 3
- 75 3
- 76 3
- 96 3
- 103 3
- 129 3
- 137 3
- 153 3
- 159 3
- 166 3
- 207 3
- 230 3
- 245 3
- 281 3
- 295 3
- 306 3
- 322 3
- 325 3
- 332 3
- 348 3
- 359 3
- 366 3
- 375 3
- 382 3
- 400 3
- 402 3
- 404 3
- 410 3
- 412 3
- 2 2
- 5 2
- 9 2
- 35 2
- 40 2
- 50 2
- 53 2
- 70 2
- 77 2
- 86 2
- 91 2
- 92 2
- 100 2
- 101 2
- 113 2
- 118 2
- 122 2
- 134 2
- 139 2
- 146 2
- 157 2
- 160 2
- 162 2
- 164 2
- 165 2
- 168 2
- 169 2
- 180 2
- 190 2
- 227 2
- 233 2
- 238 2
- 248 2
- 299 2
- 309 2
- 316 2
- 320 2
- 335 2
- 339 2
- 344 2
- 347 2
- 350 2
- 354 2
- 363 2
- 369 2
- 383 2
- 391 2
- 17 1
- 19 1
- 20 1
- 23 1
- 25 1
- 29 1
- 42 1
- 44 1
- 49 1
- 51 1
- 55 1
- 59 1
- 60 1
- 64 1
- 78 1
- 80 1
- 82 1
- 84 1
- 89 1
- 93 1
- 95 1
- 106 1
- 108 1
- 111 1
- 112 1
- 114 1
- 115 1
- 117 1
- 123 1
- 125 1
- 126 1
- 127 1
- 130 1
- 131 1
- 133 1
- 141 1
- 143 1
- 147 1
- 148 1
- 149 1
- 150 1
- 151 1
- 154 1
- 155 1
- 170 1
- 171 1
- 172 1
- 176 1
- 183 1
- 192 1
- 194 1
- 196 1
- 199 1
- 201 1
- 210 1
- 211 1
- 213 1
- 215 1
- 219 1
- 221 1
- 229 1
- 237 1
- 244 1
- 247 1
- 254 1
- 255 1
- 257 1
- 262 1
- 273 1
- 274 1
- 277 1
- 282 1
- 285 1
- 286 1
- 292 1
- 296 1
- 298 1
- 312 1
- 313 1
- 319 1
- 327 1
- 330 1
- 337 1
- 349 1
- 352 1
- 358 1
- 364 1
- 365 1
- 371 1
- 374 1
- 376 1
- 377 1
- 378 1
- 381 1
- 384 1
- 386 1
- 398 1
- 401 1
- 405 1
- 406 1
- 407 1
- 408 1
- 413 1
state 1
- Georgia 785
fips 1
- 13255 785
county 1
- Spalding · 785 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5380 | 5380 | 2020-03-20 | Spalding | Georgia | 13255 | 2 | 0 |
6314 | 6314 | 2020-03-21 | Spalding | Georgia | 13255 | 2 | 0 |
7360 | 7360 | 2020-03-22 | Spalding | Georgia | 13255 | 2 | 0 |
8513 | 8513 | 2020-03-23 | Spalding | Georgia | 13255 | 4 | 0 |
9773 | 9773 | 2020-03-24 | Spalding | Georgia | 13255 | 5 | 0 |
11153 | 11153 | 2020-03-25 | Spalding | Georgia | 13255 | 10 | 0 |
12705 | 12705 | 2020-03-26 | Spalding | Georgia | 13255 | 11 | 0 |
14379 | 14379 | 2020-03-27 | Spalding | Georgia | 13255 | 11 | 0 |
16168 | 16168 | 2020-03-28 | Spalding | Georgia | 13255 | 11 | 0 |
18065 | 18065 | 2020-03-29 | Spalding | Georgia | 13255 | 12 | 0 |
20059 | 20059 | 2020-03-30 | Spalding | Georgia | 13255 | 14 | 0 |
22143 | 22143 | 2020-03-31 | Spalding | Georgia | 13255 | 15 | 0 |
24308 | 24308 | 2020-04-01 | Spalding | Georgia | 13255 | 17 | 1 |
26539 | 26539 | 2020-04-02 | Spalding | Georgia | 13255 | 17 | 1 |
28845 | 28845 | 2020-04-03 | Spalding | Georgia | 13255 | 23 | 1 |
31205 | 31205 | 2020-04-04 | Spalding | Georgia | 13255 | 26 | 2 |
33612 | 33612 | 2020-04-05 | Spalding | Georgia | 13255 | 26 | 2 |
36062 | 36062 | 2020-04-06 | Spalding | Georgia | 13255 | 44 | 4 |
38555 | 38555 | 2020-04-07 | Spalding | Georgia | 13255 | 54 | 4 |
41099 | 41099 | 2020-04-08 | Spalding | Georgia | 13255 | 56 | 4 |
43673 | 43673 | 2020-04-09 | Spalding | Georgia | 13255 | 60 | 4 |
46275 | 46275 | 2020-04-10 | Spalding | Georgia | 13255 | 65 | 4 |
48906 | 48906 | 2020-04-11 | Spalding | Georgia | 13255 | 69 | 4 |
51568 | 51568 | 2020-04-12 | Spalding | Georgia | 13255 | 73 | 4 |
54248 | 54248 | 2020-04-13 | Spalding | Georgia | 13255 | 78 | 4 |
56940 | 56940 | 2020-04-14 | Spalding | Georgia | 13255 | 83 | 4 |
59647 | 59647 | 2020-04-15 | Spalding | Georgia | 13255 | 96 | 5 |
62367 | 62367 | 2020-04-16 | Spalding | Georgia | 13255 | 122 | 5 |
65100 | 65100 | 2020-04-17 | Spalding | Georgia | 13255 | 124 | 7 |
67848 | 67848 | 2020-04-18 | Spalding | Georgia | 13255 | 126 | 7 |
70610 | 70610 | 2020-04-19 | Spalding | Georgia | 13255 | 128 | 7 |
73379 | 73379 | 2020-04-20 | Spalding | Georgia | 13255 | 135 | 7 |
76155 | 76155 | 2020-04-21 | Spalding | Georgia | 13255 | 136 | 8 |
78939 | 78939 | 2020-04-22 | Spalding | Georgia | 13255 | 136 | 8 |
81732 | 81732 | 2020-04-23 | Spalding | Georgia | 13255 | 140 | 8 |
84532 | 84532 | 2020-04-24 | Spalding | Georgia | 13255 | 144 | 8 |
87341 | 87341 | 2020-04-25 | Spalding | Georgia | 13255 | 189 | 8 |
90157 | 90157 | 2020-04-26 | Spalding | Georgia | 13255 | 190 | 8 |
92976 | 92976 | 2020-04-27 | Spalding | Georgia | 13255 | 197 | 8 |
95808 | 95808 | 2020-04-28 | Spalding | Georgia | 13255 | 201 | 8 |
98653 | 98653 | 2020-04-29 | Spalding | Georgia | 13255 | 205 | 9 |
101503 | 101503 | 2020-04-30 | Spalding | Georgia | 13255 | 210 | 9 |
104358 | 104358 | 2020-05-01 | Spalding | Georgia | 13255 | 214 | 10 |
107223 | 107223 | 2020-05-02 | Spalding | Georgia | 13255 | 215 | 10 |
110092 | 110092 | 2020-05-03 | Spalding | Georgia | 13255 | 219 | 10 |
112967 | 112967 | 2020-05-04 | Spalding | Georgia | 13255 | 219 | 11 |
115850 | 115850 | 2020-05-05 | Spalding | Georgia | 13255 | 222 | 11 |
118810 | 118810 | 2020-05-06 | Spalding | Georgia | 13255 | 223 | 11 |
121780 | 121780 | 2020-05-07 | Spalding | Georgia | 13255 | 224 | 11 |
124759 | 124759 | 2020-05-08 | Spalding | Georgia | 13255 | 227 | 11 |
127746 | 127746 | 2020-05-09 | Spalding | Georgia | 13255 | 232 | 11 |
130737 | 130737 | 2020-05-10 | Spalding | Georgia | 13255 | 235 | 11 |
133728 | 133728 | 2020-05-11 | Spalding | Georgia | 13255 | 237 | 11 |
136717 | 136717 | 2020-05-12 | Spalding | Georgia | 13255 | 237 | 12 |
139708 | 139708 | 2020-05-13 | Spalding | Georgia | 13255 | 236 | 12 |
142704 | 142704 | 2020-05-14 | Spalding | Georgia | 13255 | 239 | 12 |
145704 | 145704 | 2020-05-15 | Spalding | Georgia | 13255 | 239 | 15 |
148707 | 148707 | 2020-05-16 | Spalding | Georgia | 13255 | 239 | 15 |
151716 | 151716 | 2020-05-17 | Spalding | Georgia | 13255 | 239 | 15 |
154728 | 154728 | 2020-05-18 | Spalding | Georgia | 13255 | 242 | 15 |
157744 | 157744 | 2020-05-19 | Spalding | Georgia | 13255 | 246 | 14 |
160770 | 160770 | 2020-05-20 | Spalding | Georgia | 13255 | 251 | 14 |
163798 | 163798 | 2020-05-21 | Spalding | Georgia | 13255 | 246 | 14 |
166831 | 166831 | 2020-05-22 | Spalding | Georgia | 13255 | 250 | 14 |
169868 | 169868 | 2020-05-23 | Spalding | Georgia | 13255 | 253 | 14 |
172909 | 172909 | 2020-05-24 | Spalding | Georgia | 13255 | 253 | 14 |
175952 | 175952 | 2020-05-25 | Spalding | Georgia | 13255 | 259 | 17 |
178996 | 178996 | 2020-05-26 | Spalding | Georgia | 13255 | 262 | 19 |
182040 | 182040 | 2020-05-27 | Spalding | Georgia | 13255 | 264 | 20 |
185094 | 185094 | 2020-05-28 | Spalding | Georgia | 13255 | 267 | 21 |
188150 | 188150 | 2020-05-29 | Spalding | Georgia | 13255 | 275 | 21 |
191215 | 191215 | 2020-05-30 | Spalding | Georgia | 13255 | 275 | 21 |
194282 | 194282 | 2020-05-31 | Spalding | Georgia | 13255 | 275 | 22 |
197352 | 197352 | 2020-06-01 | Spalding | Georgia | 13255 | 277 | 22 |
200425 | 200425 | 2020-06-02 | Spalding | Georgia | 13255 | 277 | 22 |
203501 | 203501 | 2020-06-03 | Spalding | Georgia | 13255 | 280 | 22 |
206581 | 206581 | 2020-06-04 | Spalding | Georgia | 13255 | 281 | 22 |
209662 | 209662 | 2020-06-05 | Spalding | Georgia | 13255 | 292 | 22 |
212747 | 212747 | 2020-06-06 | Spalding | Georgia | 13255 | 294 | 21 |
215834 | 215834 | 2020-06-07 | Spalding | Georgia | 13255 | 294 | 21 |
218925 | 218925 | 2020-06-08 | Spalding | Georgia | 13255 | 296 | 21 |
222020 | 222020 | 2020-06-09 | Spalding | Georgia | 13255 | 301 | 22 |
225115 | 225115 | 2020-06-10 | Spalding | Georgia | 13255 | 302 | 23 |
228217 | 228217 | 2020-06-11 | Spalding | Georgia | 13255 | 308 | 24 |
231320 | 231320 | 2020-06-12 | Spalding | Georgia | 13255 | 309 | 24 |
234426 | 234426 | 2020-06-13 | Spalding | Georgia | 13255 | 313 | 24 |
237533 | 237533 | 2020-06-14 | Spalding | Georgia | 13255 | 314 | 24 |
240641 | 240641 | 2020-06-15 | Spalding | Georgia | 13255 | 317 | 24 |
243752 | 243752 | 2020-06-16 | Spalding | Georgia | 13255 | 326 | 25 |
246865 | 246865 | 2020-06-17 | Spalding | Georgia | 13255 | 332 | 29 |
249977 | 249977 | 2020-06-18 | Spalding | Georgia | 13255 | 336 | 31 |
253092 | 253092 | 2020-06-19 | Spalding | Georgia | 13255 | 338 | 31 |
256211 | 256211 | 2020-06-20 | Spalding | Georgia | 13255 | 337 | 31 |
259338 | 259338 | 2020-06-21 | Spalding | Georgia | 13255 | 340 | 31 |
262465 | 262465 | 2020-06-22 | Spalding | Georgia | 13255 | 343 | 31 |
265593 | 265593 | 2020-06-23 | Spalding | Georgia | 13255 | 353 | 32 |
268723 | 268723 | 2020-06-24 | Spalding | Georgia | 13255 | 361 | 32 |
271859 | 271859 | 2020-06-25 | Spalding | Georgia | 13255 | 365 | 32 |
274999 | 274999 | 2020-06-26 | Spalding | Georgia | 13255 | 368 | 32 |
278147 | 278147 | 2020-06-27 | Spalding | Georgia | 13255 | 380 | 32 |
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);