ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Jackson" and fips = 13157 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- …
state 1
- Georgia 780
fips 1
- 13157 · 780 ✖
county 1
- Jackson · 780 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
11122 | 11122 | 2020-03-25 | Jackson | Georgia | 13157 | 1 | 0 |
12673 | 12673 | 2020-03-26 | Jackson | Georgia | 13157 | 2 | 0 |
14347 | 14347 | 2020-03-27 | Jackson | Georgia | 13157 | 2 | 0 |
16133 | 16133 | 2020-03-28 | Jackson | Georgia | 13157 | 2 | 0 |
18030 | 18030 | 2020-03-29 | Jackson | Georgia | 13157 | 2 | 0 |
20020 | 20020 | 2020-03-30 | Jackson | Georgia | 13157 | 2 | 0 |
22101 | 22101 | 2020-03-31 | Jackson | Georgia | 13157 | 8 | 0 |
24264 | 24264 | 2020-04-01 | Jackson | Georgia | 13157 | 10 | 0 |
26495 | 26495 | 2020-04-02 | Jackson | Georgia | 13157 | 11 | 0 |
28799 | 28799 | 2020-04-03 | Jackson | Georgia | 13157 | 13 | 0 |
31159 | 31159 | 2020-04-04 | Jackson | Georgia | 13157 | 15 | 0 |
33566 | 33566 | 2020-04-05 | Jackson | Georgia | 13157 | 15 | 0 |
36015 | 36015 | 2020-04-06 | Jackson | Georgia | 13157 | 18 | 0 |
38508 | 38508 | 2020-04-07 | Jackson | Georgia | 13157 | 23 | 0 |
41052 | 41052 | 2020-04-08 | Jackson | Georgia | 13157 | 23 | 1 |
43626 | 43626 | 2020-04-09 | Jackson | Georgia | 13157 | 26 | 1 |
46228 | 46228 | 2020-04-10 | Jackson | Georgia | 13157 | 26 | 1 |
48858 | 48858 | 2020-04-11 | Jackson | Georgia | 13157 | 26 | 1 |
51520 | 51520 | 2020-04-12 | Jackson | Georgia | 13157 | 27 | 1 |
54200 | 54200 | 2020-04-13 | Jackson | Georgia | 13157 | 29 | 1 |
56892 | 56892 | 2020-04-14 | Jackson | Georgia | 13157 | 32 | 1 |
59599 | 59599 | 2020-04-15 | Jackson | Georgia | 13157 | 35 | 1 |
62319 | 62319 | 2020-04-16 | Jackson | Georgia | 13157 | 43 | 1 |
65052 | 65052 | 2020-04-17 | Jackson | Georgia | 13157 | 46 | 1 |
67800 | 67800 | 2020-04-18 | Jackson | Georgia | 13157 | 47 | 1 |
70562 | 70562 | 2020-04-19 | Jackson | Georgia | 13157 | 48 | 1 |
73331 | 73331 | 2020-04-20 | Jackson | Georgia | 13157 | 55 | 1 |
76107 | 76107 | 2020-04-21 | Jackson | Georgia | 13157 | 57 | 1 |
78891 | 78891 | 2020-04-22 | Jackson | Georgia | 13157 | 63 | 1 |
81684 | 81684 | 2020-04-23 | Jackson | Georgia | 13157 | 69 | 1 |
84484 | 84484 | 2020-04-24 | Jackson | Georgia | 13157 | 75 | 1 |
87293 | 87293 | 2020-04-25 | Jackson | Georgia | 13157 | 75 | 1 |
90109 | 90109 | 2020-04-26 | Jackson | Georgia | 13157 | 73 | 1 |
92928 | 92928 | 2020-04-27 | Jackson | Georgia | 13157 | 77 | 1 |
95760 | 95760 | 2020-04-28 | Jackson | Georgia | 13157 | 78 | 1 |
98605 | 98605 | 2020-04-29 | Jackson | Georgia | 13157 | 85 | 1 |
101455 | 101455 | 2020-04-30 | Jackson | Georgia | 13157 | 94 | 2 |
104310 | 104310 | 2020-05-01 | Jackson | Georgia | 13157 | 97 | 2 |
107175 | 107175 | 2020-05-02 | Jackson | Georgia | 13157 | 108 | 2 |
110044 | 110044 | 2020-05-03 | Jackson | Georgia | 13157 | 108 | 2 |
112919 | 112919 | 2020-05-04 | Jackson | Georgia | 13157 | 111 | 2 |
115802 | 115802 | 2020-05-05 | Jackson | Georgia | 13157 | 113 | 3 |
118762 | 118762 | 2020-05-06 | Jackson | Georgia | 13157 | 117 | 3 |
121732 | 121732 | 2020-05-07 | Jackson | Georgia | 13157 | 119 | 3 |
124711 | 124711 | 2020-05-08 | Jackson | Georgia | 13157 | 122 | 3 |
127698 | 127698 | 2020-05-09 | Jackson | Georgia | 13157 | 123 | 3 |
130689 | 130689 | 2020-05-10 | Jackson | Georgia | 13157 | 123 | 3 |
133680 | 133680 | 2020-05-11 | Jackson | Georgia | 13157 | 124 | 3 |
136669 | 136669 | 2020-05-12 | Jackson | Georgia | 13157 | 125 | 3 |
139660 | 139660 | 2020-05-13 | Jackson | Georgia | 13157 | 126 | 3 |
142656 | 142656 | 2020-05-14 | Jackson | Georgia | 13157 | 126 | 3 |
145656 | 145656 | 2020-05-15 | Jackson | Georgia | 13157 | 127 | 3 |
148659 | 148659 | 2020-05-16 | Jackson | Georgia | 13157 | 127 | 3 |
151668 | 151668 | 2020-05-17 | Jackson | Georgia | 13157 | 127 | 3 |
154680 | 154680 | 2020-05-18 | Jackson | Georgia | 13157 | 132 | 3 |
157696 | 157696 | 2020-05-19 | Jackson | Georgia | 13157 | 134 | 3 |
160722 | 160722 | 2020-05-20 | Jackson | Georgia | 13157 | 137 | 3 |
163750 | 163750 | 2020-05-21 | Jackson | Georgia | 13157 | 139 | 3 |
166783 | 166783 | 2020-05-22 | Jackson | Georgia | 13157 | 145 | 4 |
169820 | 169820 | 2020-05-23 | Jackson | Georgia | 13157 | 147 | 4 |
172861 | 172861 | 2020-05-24 | Jackson | Georgia | 13157 | 147 | 4 |
175904 | 175904 | 2020-05-25 | Jackson | Georgia | 13157 | 148 | 4 |
178948 | 178948 | 2020-05-26 | Jackson | Georgia | 13157 | 153 | 5 |
181992 | 181992 | 2020-05-27 | Jackson | Georgia | 13157 | 171 | 5 |
185046 | 185046 | 2020-05-28 | Jackson | Georgia | 13157 | 175 | 5 |
188102 | 188102 | 2020-05-29 | Jackson | Georgia | 13157 | 184 | 5 |
191167 | 191167 | 2020-05-30 | Jackson | Georgia | 13157 | 184 | 5 |
194234 | 194234 | 2020-05-31 | Jackson | Georgia | 13157 | 184 | 5 |
197304 | 197304 | 2020-06-01 | Jackson | Georgia | 13157 | 195 | 6 |
200377 | 200377 | 2020-06-02 | Jackson | Georgia | 13157 | 198 | 6 |
203453 | 203453 | 2020-06-03 | Jackson | Georgia | 13157 | 199 | 6 |
206533 | 206533 | 2020-06-04 | Jackson | Georgia | 13157 | 210 | 6 |
209614 | 209614 | 2020-06-05 | Jackson | Georgia | 13157 | 221 | 7 |
212699 | 212699 | 2020-06-06 | Jackson | Georgia | 13157 | 226 | 7 |
215786 | 215786 | 2020-06-07 | Jackson | Georgia | 13157 | 226 | 7 |
218877 | 218877 | 2020-06-08 | Jackson | Georgia | 13157 | 232 | 7 |
221972 | 221972 | 2020-06-09 | Jackson | Georgia | 13157 | 237 | 7 |
225067 | 225067 | 2020-06-10 | Jackson | Georgia | 13157 | 239 | 7 |
228169 | 228169 | 2020-06-11 | Jackson | Georgia | 13157 | 247 | 7 |
231272 | 231272 | 2020-06-12 | Jackson | Georgia | 13157 | 256 | 7 |
234378 | 234378 | 2020-06-13 | Jackson | Georgia | 13157 | 260 | 7 |
237485 | 237485 | 2020-06-14 | Jackson | Georgia | 13157 | 260 | 7 |
240593 | 240593 | 2020-06-15 | Jackson | Georgia | 13157 | 262 | 7 |
243704 | 243704 | 2020-06-16 | Jackson | Georgia | 13157 | 266 | 7 |
246817 | 246817 | 2020-06-17 | Jackson | Georgia | 13157 | 276 | 7 |
249929 | 249929 | 2020-06-18 | Jackson | Georgia | 13157 | 283 | 7 |
253044 | 253044 | 2020-06-19 | Jackson | Georgia | 13157 | 294 | 7 |
256163 | 256163 | 2020-06-20 | Jackson | Georgia | 13157 | 297 | 7 |
259290 | 259290 | 2020-06-21 | Jackson | Georgia | 13157 | 300 | 7 |
262417 | 262417 | 2020-06-22 | Jackson | Georgia | 13157 | 305 | 7 |
265545 | 265545 | 2020-06-23 | Jackson | Georgia | 13157 | 314 | 7 |
268675 | 268675 | 2020-06-24 | Jackson | Georgia | 13157 | 329 | 7 |
271811 | 271811 | 2020-06-25 | Jackson | Georgia | 13157 | 337 | 9 |
274951 | 274951 | 2020-06-26 | Jackson | Georgia | 13157 | 341 | 10 |
278099 | 278099 | 2020-06-27 | Jackson | Georgia | 13157 | 347 | 10 |
281246 | 281246 | 2020-06-28 | Jackson | Georgia | 13157 | 354 | 10 |
284392 | 284392 | 2020-06-29 | Jackson | Georgia | 13157 | 355 | 10 |
287538 | 287538 | 2020-06-30 | Jackson | Georgia | 13157 | 370 | 10 |
290689 | 290689 | 2020-07-01 | Jackson | Georgia | 13157 | 390 | 10 |
293843 | 293843 | 2020-07-02 | Jackson | Georgia | 13157 | 391 | 10 |
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);