ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Johnson" and fips = 13167 sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
20024 | 20024 | 2020-03-30 | Johnson | Georgia | 13167 | 1 | 0 |
22105 | 22105 | 2020-03-31 | Johnson | Georgia | 13167 | 1 | 0 |
24268 | 24268 | 2020-04-01 | Johnson | Georgia | 13167 | 1 | 0 |
26499 | 26499 | 2020-04-02 | Johnson | Georgia | 13167 | 1 | 0 |
28803 | 28803 | 2020-04-03 | Johnson | Georgia | 13167 | 1 | 0 |
31163 | 31163 | 2020-04-04 | Johnson | Georgia | 13167 | 2 | 0 |
33570 | 33570 | 2020-04-05 | Johnson | Georgia | 13167 | 3 | 0 |
36020 | 36020 | 2020-04-06 | Johnson | Georgia | 13167 | 5 | 0 |
38513 | 38513 | 2020-04-07 | Johnson | Georgia | 13167 | 6 | 0 |
41057 | 41057 | 2020-04-08 | Johnson | Georgia | 13167 | 13 | 0 |
43631 | 43631 | 2020-04-09 | Johnson | Georgia | 13167 | 14 | 1 |
46233 | 46233 | 2020-04-10 | Johnson | Georgia | 13167 | 15 | 1 |
48863 | 48863 | 2020-04-11 | Johnson | Georgia | 13167 | 15 | 1 |
51525 | 51525 | 2020-04-12 | Johnson | Georgia | 13167 | 19 | 1 |
54205 | 54205 | 2020-04-13 | Johnson | Georgia | 13167 | 20 | 1 |
56897 | 56897 | 2020-04-14 | Johnson | Georgia | 13167 | 20 | 1 |
59604 | 59604 | 2020-04-15 | Johnson | Georgia | 13167 | 21 | 1 |
62324 | 62324 | 2020-04-16 | Johnson | Georgia | 13167 | 33 | 1 |
65057 | 65057 | 2020-04-17 | Johnson | Georgia | 13167 | 33 | 1 |
67805 | 67805 | 2020-04-18 | Johnson | Georgia | 13167 | 33 | 1 |
70567 | 70567 | 2020-04-19 | Johnson | Georgia | 13167 | 33 | 1 |
73336 | 73336 | 2020-04-20 | Johnson | Georgia | 13167 | 34 | 1 |
76112 | 76112 | 2020-04-21 | Johnson | Georgia | 13167 | 35 | 1 |
78896 | 78896 | 2020-04-22 | Johnson | Georgia | 13167 | 37 | 1 |
81689 | 81689 | 2020-04-23 | Johnson | Georgia | 13167 | 38 | 1 |
84489 | 84489 | 2020-04-24 | Johnson | Georgia | 13167 | 36 | 1 |
87298 | 87298 | 2020-04-25 | Johnson | Georgia | 13167 | 36 | 2 |
90114 | 90114 | 2020-04-26 | Johnson | Georgia | 13167 | 36 | 2 |
92933 | 92933 | 2020-04-27 | Johnson | Georgia | 13167 | 39 | 2 |
95765 | 95765 | 2020-04-28 | Johnson | Georgia | 13167 | 39 | 2 |
98610 | 98610 | 2020-04-29 | Johnson | Georgia | 13167 | 39 | 2 |
101460 | 101460 | 2020-04-30 | Johnson | Georgia | 13167 | 49 | 2 |
104315 | 104315 | 2020-05-01 | Johnson | Georgia | 13167 | 51 | 2 |
107180 | 107180 | 2020-05-02 | Johnson | Georgia | 13167 | 59 | 2 |
110049 | 110049 | 2020-05-03 | Johnson | Georgia | 13167 | 59 | 2 |
112924 | 112924 | 2020-05-04 | Johnson | Georgia | 13167 | 63 | 2 |
115807 | 115807 | 2020-05-05 | Johnson | Georgia | 13167 | 64 | 2 |
118767 | 118767 | 2020-05-06 | Johnson | Georgia | 13167 | 64 | 2 |
121737 | 121737 | 2020-05-07 | Johnson | Georgia | 13167 | 64 | 2 |
124716 | 124716 | 2020-05-08 | Johnson | Georgia | 13167 | 63 | 2 |
127703 | 127703 | 2020-05-09 | Johnson | Georgia | 13167 | 66 | 2 |
130694 | 130694 | 2020-05-10 | Johnson | Georgia | 13167 | 66 | 2 |
133685 | 133685 | 2020-05-11 | Johnson | Georgia | 13167 | 67 | 2 |
136674 | 136674 | 2020-05-12 | Johnson | Georgia | 13167 | 69 | 2 |
139665 | 139665 | 2020-05-13 | Johnson | Georgia | 13167 | 70 | 2 |
142661 | 142661 | 2020-05-14 | Johnson | Georgia | 13167 | 70 | 2 |
145661 | 145661 | 2020-05-15 | Johnson | Georgia | 13167 | 71 | 2 |
148664 | 148664 | 2020-05-16 | Johnson | Georgia | 13167 | 71 | 2 |
151673 | 151673 | 2020-05-17 | Johnson | Georgia | 13167 | 71 | 2 |
154685 | 154685 | 2020-05-18 | Johnson | Georgia | 13167 | 74 | 2 |
157701 | 157701 | 2020-05-19 | Johnson | Georgia | 13167 | 82 | 2 |
160727 | 160727 | 2020-05-20 | Johnson | Georgia | 13167 | 78 | 2 |
163755 | 163755 | 2020-05-21 | Johnson | Georgia | 13167 | 78 | 2 |
166788 | 166788 | 2020-05-22 | Johnson | Georgia | 13167 | 78 | 2 |
169825 | 169825 | 2020-05-23 | Johnson | Georgia | 13167 | 76 | 2 |
172866 | 172866 | 2020-05-24 | Johnson | Georgia | 13167 | 76 | 2 |
175909 | 175909 | 2020-05-25 | Johnson | Georgia | 13167 | 81 | 2 |
178953 | 178953 | 2020-05-26 | Johnson | Georgia | 13167 | 82 | 2 |
181997 | 181997 | 2020-05-27 | Johnson | Georgia | 13167 | 82 | 2 |
185051 | 185051 | 2020-05-28 | Johnson | Georgia | 13167 | 82 | 2 |
188107 | 188107 | 2020-05-29 | Johnson | Georgia | 13167 | 82 | 2 |
191172 | 191172 | 2020-05-30 | Johnson | Georgia | 13167 | 82 | 2 |
194239 | 194239 | 2020-05-31 | Johnson | Georgia | 13167 | 82 | 2 |
197309 | 197309 | 2020-06-01 | Johnson | Georgia | 13167 | 83 | 2 |
200382 | 200382 | 2020-06-02 | Johnson | Georgia | 13167 | 83 | 2 |
203458 | 203458 | 2020-06-03 | Johnson | Georgia | 13167 | 82 | 2 |
206538 | 206538 | 2020-06-04 | Johnson | Georgia | 13167 | 83 | 2 |
209619 | 209619 | 2020-06-05 | Johnson | Georgia | 13167 | 82 | 2 |
212704 | 212704 | 2020-06-06 | Johnson | Georgia | 13167 | 82 | 2 |
215791 | 215791 | 2020-06-07 | Johnson | Georgia | 13167 | 82 | 2 |
218882 | 218882 | 2020-06-08 | Johnson | Georgia | 13167 | 83 | 2 |
221977 | 221977 | 2020-06-09 | Johnson | Georgia | 13167 | 83 | 2 |
225072 | 225072 | 2020-06-10 | Johnson | Georgia | 13167 | 83 | 2 |
228174 | 228174 | 2020-06-11 | Johnson | Georgia | 13167 | 83 | 2 |
231277 | 231277 | 2020-06-12 | Johnson | Georgia | 13167 | 77 | 2 |
234383 | 234383 | 2020-06-13 | Johnson | Georgia | 13167 | 77 | 2 |
237490 | 237490 | 2020-06-14 | Johnson | Georgia | 13167 | 77 | 2 |
240598 | 240598 | 2020-06-15 | Johnson | Georgia | 13167 | 77 | 2 |
243709 | 243709 | 2020-06-16 | Johnson | Georgia | 13167 | 78 | 2 |
246822 | 246822 | 2020-06-17 | Johnson | Georgia | 13167 | 78 | 2 |
249934 | 249934 | 2020-06-18 | Johnson | Georgia | 13167 | 78 | 2 |
253049 | 253049 | 2020-06-19 | Johnson | Georgia | 13167 | 80 | 2 |
256168 | 256168 | 2020-06-20 | Johnson | Georgia | 13167 | 80 | 2 |
259295 | 259295 | 2020-06-21 | Johnson | Georgia | 13167 | 80 | 2 |
262422 | 262422 | 2020-06-22 | Johnson | Georgia | 13167 | 80 | 2 |
265550 | 265550 | 2020-06-23 | Johnson | Georgia | 13167 | 81 | 2 |
268680 | 268680 | 2020-06-24 | Johnson | Georgia | 13167 | 82 | 2 |
271816 | 271816 | 2020-06-25 | Johnson | Georgia | 13167 | 84 | 2 |
274956 | 274956 | 2020-06-26 | Johnson | Georgia | 13167 | 84 | 2 |
278104 | 278104 | 2020-06-27 | Johnson | Georgia | 13167 | 85 | 2 |
281251 | 281251 | 2020-06-28 | Johnson | Georgia | 13167 | 87 | 2 |
284397 | 284397 | 2020-06-29 | Johnson | Georgia | 13167 | 88 | 2 |
287543 | 287543 | 2020-06-30 | Johnson | Georgia | 13167 | 90 | 2 |
290694 | 290694 | 2020-07-01 | Johnson | Georgia | 13167 | 90 | 2 |
293848 | 293848 | 2020-07-02 | Johnson | Georgia | 13167 | 92 | 2 |
297004 | 297004 | 2020-07-03 | Johnson | Georgia | 13167 | 100 | 2 |
300166 | 300166 | 2020-07-04 | Johnson | Georgia | 13167 | 102 | 2 |
303330 | 303330 | 2020-07-05 | Johnson | Georgia | 13167 | 102 | 2 |
306494 | 306494 | 2020-07-06 | Johnson | Georgia | 13167 | 105 | 2 |
309662 | 309662 | 2020-07-07 | Johnson | Georgia | 13167 | 111 | 2 |
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);