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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
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);