ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
6,225 rows where county = "Jasper" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 8
- Missouri 784
- South Carolina 784
- Georgia 781
- Iowa 781
- Indiana 780
- Mississippi 773
- Texas 772
- Illinois 770
county 1
- Jasper · 6,225 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9745 | 9745 | 2020-03-24 | Jasper | Georgia | 13159 | 1 | 0 |
11123 | 11123 | 2020-03-25 | Jasper | Georgia | 13159 | 2 | 0 |
12674 | 12674 | 2020-03-26 | Jasper | Georgia | 13159 | 2 | 0 |
14348 | 14348 | 2020-03-27 | Jasper | Georgia | 13159 | 2 | 0 |
16134 | 16134 | 2020-03-28 | Jasper | Georgia | 13159 | 2 | 0 |
18031 | 18031 | 2020-03-29 | Jasper | Georgia | 13159 | 2 | 0 |
20021 | 20021 | 2020-03-30 | Jasper | Georgia | 13159 | 2 | 0 |
22102 | 22102 | 2020-03-31 | Jasper | Georgia | 13159 | 2 | 0 |
24265 | 24265 | 2020-04-01 | Jasper | Georgia | 13159 | 2 | 0 |
26496 | 26496 | 2020-04-02 | Jasper | Georgia | 13159 | 2 | 0 |
28800 | 28800 | 2020-04-03 | Jasper | Georgia | 13159 | 2 | 0 |
31160 | 31160 | 2020-04-04 | Jasper | Georgia | 13159 | 4 | 0 |
33567 | 33567 | 2020-04-05 | Jasper | Georgia | 13159 | 3 | 0 |
36016 | 36016 | 2020-04-06 | Jasper | Georgia | 13159 | 4 | 0 |
38509 | 38509 | 2020-04-07 | Jasper | Georgia | 13159 | 6 | 0 |
41053 | 41053 | 2020-04-08 | Jasper | Georgia | 13159 | 5 | 0 |
43627 | 43627 | 2020-04-09 | Jasper | Georgia | 13159 | 6 | 0 |
46229 | 46229 | 2020-04-10 | Jasper | Georgia | 13159 | 6 | 0 |
48859 | 48859 | 2020-04-11 | Jasper | Georgia | 13159 | 6 | 0 |
51521 | 51521 | 2020-04-12 | Jasper | Georgia | 13159 | 8 | 0 |
54201 | 54201 | 2020-04-13 | Jasper | Georgia | 13159 | 9 | 0 |
56893 | 56893 | 2020-04-14 | Jasper | Georgia | 13159 | 9 | 0 |
59600 | 59600 | 2020-04-15 | Jasper | Georgia | 13159 | 10 | 0 |
62320 | 62320 | 2020-04-16 | Jasper | Georgia | 13159 | 10 | 0 |
65053 | 65053 | 2020-04-17 | Jasper | Georgia | 13159 | 14 | 0 |
67801 | 67801 | 2020-04-18 | Jasper | Georgia | 13159 | 15 | 0 |
70563 | 70563 | 2020-04-19 | Jasper | Georgia | 13159 | 17 | 0 |
73332 | 73332 | 2020-04-20 | Jasper | Georgia | 13159 | 17 | 0 |
76108 | 76108 | 2020-04-21 | Jasper | Georgia | 13159 | 18 | 0 |
78892 | 78892 | 2020-04-22 | Jasper | Georgia | 13159 | 18 | 0 |
81685 | 81685 | 2020-04-23 | Jasper | Georgia | 13159 | 19 | 0 |
84485 | 84485 | 2020-04-24 | Jasper | Georgia | 13159 | 20 | 0 |
87294 | 87294 | 2020-04-25 | Jasper | Georgia | 13159 | 20 | 0 |
90110 | 90110 | 2020-04-26 | Jasper | Georgia | 13159 | 20 | 0 |
92929 | 92929 | 2020-04-27 | Jasper | Georgia | 13159 | 20 | 0 |
95761 | 95761 | 2020-04-28 | Jasper | Georgia | 13159 | 22 | 0 |
98606 | 98606 | 2020-04-29 | Jasper | Georgia | 13159 | 22 | 0 |
101456 | 101456 | 2020-04-30 | Jasper | Georgia | 13159 | 21 | 0 |
104311 | 104311 | 2020-05-01 | Jasper | Georgia | 13159 | 22 | 0 |
107176 | 107176 | 2020-05-02 | Jasper | Georgia | 13159 | 23 | 0 |
110045 | 110045 | 2020-05-03 | Jasper | Georgia | 13159 | 24 | 0 |
112920 | 112920 | 2020-05-04 | Jasper | Georgia | 13159 | 25 | 0 |
115803 | 115803 | 2020-05-05 | Jasper | Georgia | 13159 | 25 | 0 |
118763 | 118763 | 2020-05-06 | Jasper | Georgia | 13159 | 26 | 0 |
121733 | 121733 | 2020-05-07 | Jasper | Georgia | 13159 | 26 | 0 |
124712 | 124712 | 2020-05-08 | Jasper | Georgia | 13159 | 26 | 0 |
127699 | 127699 | 2020-05-09 | Jasper | Georgia | 13159 | 25 | 0 |
130690 | 130690 | 2020-05-10 | Jasper | Georgia | 13159 | 25 | 0 |
133681 | 133681 | 2020-05-11 | Jasper | Georgia | 13159 | 25 | 0 |
136670 | 136670 | 2020-05-12 | Jasper | Georgia | 13159 | 26 | 0 |
139661 | 139661 | 2020-05-13 | Jasper | Georgia | 13159 | 26 | 0 |
142657 | 142657 | 2020-05-14 | Jasper | Georgia | 13159 | 26 | 0 |
145657 | 145657 | 2020-05-15 | Jasper | Georgia | 13159 | 26 | 0 |
148660 | 148660 | 2020-05-16 | Jasper | Georgia | 13159 | 26 | 0 |
151669 | 151669 | 2020-05-17 | Jasper | Georgia | 13159 | 26 | 0 |
154681 | 154681 | 2020-05-18 | Jasper | Georgia | 13159 | 26 | 0 |
157697 | 157697 | 2020-05-19 | Jasper | Georgia | 13159 | 26 | 0 |
160723 | 160723 | 2020-05-20 | Jasper | Georgia | 13159 | 26 | 0 |
163751 | 163751 | 2020-05-21 | Jasper | Georgia | 13159 | 26 | 1 |
166784 | 166784 | 2020-05-22 | Jasper | Georgia | 13159 | 31 | 1 |
169821 | 169821 | 2020-05-23 | Jasper | Georgia | 13159 | 31 | 1 |
172862 | 172862 | 2020-05-24 | Jasper | Georgia | 13159 | 31 | 1 |
175905 | 175905 | 2020-05-25 | Jasper | Georgia | 13159 | 31 | 1 |
178949 | 178949 | 2020-05-26 | Jasper | Georgia | 13159 | 32 | 1 |
181993 | 181993 | 2020-05-27 | Jasper | Georgia | 13159 | 32 | 1 |
185047 | 185047 | 2020-05-28 | Jasper | Georgia | 13159 | 32 | 1 |
188103 | 188103 | 2020-05-29 | Jasper | Georgia | 13159 | 33 | 1 |
191168 | 191168 | 2020-05-30 | Jasper | Georgia | 13159 | 36 | 1 |
194235 | 194235 | 2020-05-31 | Jasper | Georgia | 13159 | 36 | 1 |
197305 | 197305 | 2020-06-01 | Jasper | Georgia | 13159 | 40 | 1 |
200378 | 200378 | 2020-06-02 | Jasper | Georgia | 13159 | 39 | 1 |
203454 | 203454 | 2020-06-03 | Jasper | Georgia | 13159 | 40 | 1 |
206534 | 206534 | 2020-06-04 | Jasper | Georgia | 13159 | 45 | 1 |
209615 | 209615 | 2020-06-05 | Jasper | Georgia | 13159 | 46 | 1 |
212700 | 212700 | 2020-06-06 | Jasper | Georgia | 13159 | 47 | 1 |
215787 | 215787 | 2020-06-07 | Jasper | Georgia | 13159 | 48 | 1 |
218878 | 218878 | 2020-06-08 | Jasper | Georgia | 13159 | 49 | 1 |
221973 | 221973 | 2020-06-09 | Jasper | Georgia | 13159 | 51 | 1 |
225068 | 225068 | 2020-06-10 | Jasper | Georgia | 13159 | 51 | 1 |
228170 | 228170 | 2020-06-11 | Jasper | Georgia | 13159 | 55 | 1 |
231273 | 231273 | 2020-06-12 | Jasper | Georgia | 13159 | 56 | 1 |
234379 | 234379 | 2020-06-13 | Jasper | Georgia | 13159 | 56 | 1 |
237486 | 237486 | 2020-06-14 | Jasper | Georgia | 13159 | 56 | 1 |
240594 | 240594 | 2020-06-15 | Jasper | Georgia | 13159 | 56 | 1 |
243705 | 243705 | 2020-06-16 | Jasper | Georgia | 13159 | 56 | 1 |
246818 | 246818 | 2020-06-17 | Jasper | Georgia | 13159 | 59 | 1 |
249930 | 249930 | 2020-06-18 | Jasper | Georgia | 13159 | 61 | 1 |
253045 | 253045 | 2020-06-19 | Jasper | Georgia | 13159 | 61 | 1 |
256164 | 256164 | 2020-06-20 | Jasper | Georgia | 13159 | 61 | 1 |
259291 | 259291 | 2020-06-21 | Jasper | Georgia | 13159 | 61 | 1 |
262418 | 262418 | 2020-06-22 | Jasper | Georgia | 13159 | 63 | 1 |
265546 | 265546 | 2020-06-23 | Jasper | Georgia | 13159 | 65 | 1 |
268676 | 268676 | 2020-06-24 | Jasper | Georgia | 13159 | 65 | 1 |
271812 | 271812 | 2020-06-25 | Jasper | Georgia | 13159 | 64 | 1 |
274952 | 274952 | 2020-06-26 | Jasper | Georgia | 13159 | 65 | 1 |
278100 | 278100 | 2020-06-27 | Jasper | Georgia | 13159 | 67 | 1 |
281247 | 281247 | 2020-06-28 | Jasper | Georgia | 13159 | 66 | 1 |
284393 | 284393 | 2020-06-29 | Jasper | Georgia | 13159 | 66 | 1 |
287539 | 287539 | 2020-06-30 | Jasper | Georgia | 13159 | 68 | 1 |
290690 | 290690 | 2020-07-01 | Jasper | Georgia | 13159 | 69 | 1 |
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);