ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where county = "DeKalb" and state = "Georgia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
281211 | 281211 | 2020-06-28 | DeKalb | Georgia | 13089 | 5448 | 171 |
278064 | 278064 | 2020-06-27 | DeKalb | Georgia | 13089 | 5404 | 171 |
274916 | 274916 | 2020-06-26 | DeKalb | Georgia | 13089 | 5322 | 171 |
271776 | 271776 | 2020-06-25 | DeKalb | Georgia | 13089 | 5258 | 168 |
268640 | 268640 | 2020-06-24 | DeKalb | Georgia | 13089 | 5158 | 166 |
265510 | 265510 | 2020-06-23 | DeKalb | Georgia | 13089 | 5042 | 166 |
262382 | 262382 | 2020-06-22 | DeKalb | Georgia | 13089 | 4791 | 165 |
259255 | 259255 | 2020-06-21 | DeKalb | Georgia | 13089 | 4694 | 165 |
256128 | 256128 | 2020-06-20 | DeKalb | Georgia | 13089 | 4666 | 165 |
253009 | 253009 | 2020-06-19 | DeKalb | Georgia | 13089 | 4637 | 164 |
249894 | 249894 | 2020-06-18 | DeKalb | Georgia | 13089 | 4541 | 158 |
246782 | 246782 | 2020-06-17 | DeKalb | Georgia | 13089 | 4489 | 155 |
243669 | 243669 | 2020-06-16 | DeKalb | Georgia | 13089 | 4411 | 152 |
240558 | 240558 | 2020-06-15 | DeKalb | Georgia | 13089 | 4355 | 148 |
237450 | 237450 | 2020-06-14 | DeKalb | Georgia | 13089 | 4311 | 145 |
234343 | 234343 | 2020-06-13 | DeKalb | Georgia | 13089 | 4303 | 145 |
231237 | 231237 | 2020-06-12 | DeKalb | Georgia | 13089 | 4282 | 142 |
228134 | 228134 | 2020-06-11 | DeKalb | Georgia | 13089 | 4229 | 139 |
225032 | 225032 | 2020-06-10 | DeKalb | Georgia | 13089 | 4186 | 136 |
221937 | 221937 | 2020-06-09 | DeKalb | Georgia | 13089 | 4120 | 135 |
218842 | 218842 | 2020-06-08 | DeKalb | Georgia | 13089 | 4054 | 125 |
215751 | 215751 | 2020-06-07 | DeKalb | Georgia | 13089 | 4012 | 125 |
212664 | 212664 | 2020-06-06 | DeKalb | Georgia | 13089 | 4008 | 125 |
209579 | 209579 | 2020-06-05 | DeKalb | Georgia | 13089 | 3986 | 124 |
206498 | 206498 | 2020-06-04 | DeKalb | Georgia | 13089 | 3939 | 122 |
203418 | 203418 | 2020-06-03 | DeKalb | Georgia | 13089 | 3874 | 122 |
200342 | 200342 | 2020-06-02 | DeKalb | Georgia | 13089 | 3803 | 121 |
197269 | 197269 | 2020-06-01 | DeKalb | Georgia | 13089 | 3795 | 121 |
194199 | 194199 | 2020-05-31 | DeKalb | Georgia | 13089 | 3734 | 120 |
191132 | 191132 | 2020-05-30 | DeKalb | Georgia | 13089 | 3731 | 112 |
188067 | 188067 | 2020-05-29 | DeKalb | Georgia | 13089 | 3718 | 112 |
185011 | 185011 | 2020-05-28 | DeKalb | Georgia | 13089 | 3635 | 112 |
181957 | 181957 | 2020-05-27 | DeKalb | Georgia | 13089 | 3573 | 111 |
178913 | 178913 | 2020-05-26 | DeKalb | Georgia | 13089 | 3421 | 107 |
175869 | 175869 | 2020-05-25 | DeKalb | Georgia | 13089 | 3305 | 104 |
172826 | 172826 | 2020-05-24 | DeKalb | Georgia | 13089 | 3257 | 102 |
169785 | 169785 | 2020-05-23 | DeKalb | Georgia | 13089 | 3146 | 102 |
166748 | 166748 | 2020-05-22 | DeKalb | Georgia | 13089 | 3080 | 100 |
163715 | 163715 | 2020-05-21 | DeKalb | Georgia | 13089 | 3038 | 96 |
160687 | 160687 | 2020-05-20 | DeKalb | Georgia | 13089 | 2979 | 88 |
157661 | 157661 | 2020-05-19 | DeKalb | Georgia | 13089 | 2918 | 87 |
154645 | 154645 | 2020-05-18 | DeKalb | Georgia | 13089 | 2856 | 86 |
151633 | 151633 | 2020-05-17 | DeKalb | Georgia | 13089 | 2802 | 82 |
148624 | 148624 | 2020-05-16 | DeKalb | Georgia | 13089 | 2800 | 81 |
145621 | 145621 | 2020-05-15 | DeKalb | Georgia | 13089 | 2751 | 80 |
142621 | 142621 | 2020-05-14 | DeKalb | Georgia | 13089 | 2664 | 75 |
139625 | 139625 | 2020-05-13 | DeKalb | Georgia | 13089 | 2632 | 73 |
136634 | 136634 | 2020-05-12 | DeKalb | Georgia | 13089 | 2605 | 72 |
133645 | 133645 | 2020-05-11 | DeKalb | Georgia | 13089 | 2555 | 71 |
130654 | 130654 | 2020-05-10 | DeKalb | Georgia | 13089 | 2536 | 69 |
127663 | 127663 | 2020-05-09 | DeKalb | Georgia | 13089 | 2489 | 69 |
124676 | 124676 | 2020-05-08 | DeKalb | Georgia | 13089 | 2445 | 69 |
121697 | 121697 | 2020-05-07 | DeKalb | Georgia | 13089 | 2396 | 62 |
118728 | 118728 | 2020-05-06 | DeKalb | Georgia | 13089 | 2357 | 61 |
115768 | 115768 | 2020-05-05 | DeKalb | Georgia | 13089 | 2284 | 59 |
112885 | 112885 | 2020-05-04 | DeKalb | Georgia | 13089 | 2255 | 57 |
110010 | 110010 | 2020-05-03 | DeKalb | Georgia | 13089 | 2184 | 53 |
107141 | 107141 | 2020-05-02 | DeKalb | Georgia | 13089 | 2148 | 52 |
104276 | 104276 | 2020-05-01 | DeKalb | Georgia | 13089 | 2073 | 49 |
101421 | 101421 | 2020-04-30 | DeKalb | Georgia | 13089 | 2027 | 47 |
98571 | 98571 | 2020-04-29 | DeKalb | Georgia | 13089 | 1980 | 46 |
95726 | 95726 | 2020-04-28 | DeKalb | Georgia | 13089 | 1907 | 44 |
92894 | 92894 | 2020-04-27 | DeKalb | Georgia | 13089 | 1855 | 42 |
90075 | 90075 | 2020-04-26 | DeKalb | Georgia | 13089 | 1800 | 36 |
87259 | 87259 | 2020-04-25 | DeKalb | Georgia | 13089 | 1788 | 36 |
84450 | 84450 | 2020-04-24 | DeKalb | Georgia | 13089 | 1721 | 36 |
81650 | 81650 | 2020-04-23 | DeKalb | Georgia | 13089 | 1689 | 34 |
78857 | 78857 | 2020-04-22 | DeKalb | Georgia | 13089 | 1609 | 31 |
76073 | 76073 | 2020-04-21 | DeKalb | Georgia | 13089 | 1563 | 30 |
73297 | 73297 | 2020-04-20 | DeKalb | Georgia | 13089 | 1520 | 26 |
70528 | 70528 | 2020-04-19 | DeKalb | Georgia | 13089 | 1473 | 24 |
67766 | 67766 | 2020-04-18 | DeKalb | Georgia | 13089 | 1408 | 24 |
65018 | 65018 | 2020-04-17 | DeKalb | Georgia | 13089 | 1366 | 23 |
62285 | 62285 | 2020-04-16 | DeKalb | Georgia | 13089 | 1260 | 21 |
59565 | 59565 | 2020-04-15 | DeKalb | Georgia | 13089 | 1225 | 16 |
56858 | 56858 | 2020-04-14 | DeKalb | Georgia | 13089 | 1144 | 15 |
54166 | 54166 | 2020-04-13 | DeKalb | Georgia | 13089 | 1006 | 15 |
51486 | 51486 | 2020-04-12 | DeKalb | Georgia | 13089 | 893 | 14 |
48825 | 48825 | 2020-04-11 | DeKalb | Georgia | 13089 | 848 | 14 |
46195 | 46195 | 2020-04-10 | DeKalb | Georgia | 13089 | 826 | 13 |
43593 | 43593 | 2020-04-09 | DeKalb | Georgia | 13089 | 766 | 13 |
41019 | 41019 | 2020-04-08 | DeKalb | Georgia | 13089 | 732 | 12 |
38475 | 38475 | 2020-04-07 | DeKalb | Georgia | 13089 | 673 | 11 |
35983 | 35983 | 2020-04-06 | DeKalb | Georgia | 13089 | 600 | 11 |
33535 | 33535 | 2020-04-05 | DeKalb | Georgia | 13089 | 549 | 9 |
31128 | 31128 | 2020-04-04 | DeKalb | Georgia | 13089 | 539 | 9 |
28768 | 28768 | 2020-04-03 | DeKalb | Georgia | 13089 | 483 | 8 |
26465 | 26465 | 2020-04-02 | DeKalb | Georgia | 13089 | 409 | 8 |
24234 | 24234 | 2020-04-01 | DeKalb | Georgia | 13089 | 360 | 4 |
22071 | 22071 | 2020-03-31 | DeKalb | Georgia | 13089 | 360 | 4 |
19992 | 19992 | 2020-03-30 | DeKalb | Georgia | 13089 | 294 | 3 |
18004 | 18004 | 2020-03-29 | DeKalb | Georgia | 13089 | 273 | 3 |
16107 | 16107 | 2020-03-28 | DeKalb | Georgia | 13089 | 246 | 3 |
14321 | 14321 | 2020-03-27 | DeKalb | Georgia | 13089 | 219 | 2 |
12649 | 12649 | 2020-03-26 | DeKalb | Georgia | 13089 | 137 | 0 |
11100 | 11100 | 2020-03-25 | DeKalb | Georgia | 13089 | 125 | 0 |
9725 | 9725 | 2020-03-24 | DeKalb | Georgia | 13089 | 107 | 0 |
8474 | 8474 | 2020-03-23 | DeKalb | Georgia | 13089 | 74 | 0 |
7326 | 7326 | 2020-03-22 | DeKalb | Georgia | 13089 | 53 | 0 |
6280 | 6280 | 2020-03-21 | DeKalb | Georgia | 13089 | 42 | 0 |
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);