ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 22033 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3415 | 3415 | 2020-03-17 | East Baton Rouge | Louisiana | 22033 | 1 | 0 |
3995 | 3995 | 2020-03-18 | East Baton Rouge | Louisiana | 22033 | 3 | 0 |
4688 | 4688 | 2020-03-19 | East Baton Rouge | Louisiana | 22033 | 6 | 0 |
5504 | 5504 | 2020-03-20 | East Baton Rouge | Louisiana | 22033 | 7 | 0 |
6456 | 6456 | 2020-03-21 | East Baton Rouge | Louisiana | 22033 | 18 | 0 |
7531 | 7531 | 2020-03-22 | East Baton Rouge | Louisiana | 22033 | 20 | 0 |
8695 | 8695 | 2020-03-23 | East Baton Rouge | Louisiana | 22033 | 43 | 1 |
9983 | 9983 | 2020-03-24 | East Baton Rouge | Louisiana | 22033 | 58 | 2 |
11387 | 11387 | 2020-03-25 | East Baton Rouge | Louisiana | 22033 | 75 | 3 |
12962 | 12962 | 2020-03-26 | East Baton Rouge | Louisiana | 22033 | 105 | 4 |
14669 | 14669 | 2020-03-27 | East Baton Rouge | Louisiana | 22033 | 124 | 4 |
16487 | 16487 | 2020-03-28 | East Baton Rouge | Louisiana | 22033 | 153 | 4 |
18399 | 18399 | 2020-03-29 | East Baton Rouge | Louisiana | 22033 | 164 | 7 |
20415 | 20415 | 2020-03-30 | East Baton Rouge | Louisiana | 22033 | 188 | 9 |
22523 | 22523 | 2020-03-31 | East Baton Rouge | Louisiana | 22033 | 228 | 9 |
24699 | 24699 | 2020-04-01 | East Baton Rouge | Louisiana | 22033 | 244 | 10 |
26950 | 26950 | 2020-04-02 | East Baton Rouge | Louisiana | 22033 | 325 | 11 |
29267 | 29267 | 2020-04-03 | East Baton Rouge | Louisiana | 22033 | 389 | 13 |
31645 | 31645 | 2020-04-04 | East Baton Rouge | Louisiana | 22033 | 621 | 14 |
34070 | 34070 | 2020-04-05 | East Baton Rouge | Louisiana | 22033 | 656 | 22 |
36528 | 36528 | 2020-04-06 | East Baton Rouge | Louisiana | 22033 | 816 | 25 |
39036 | 39036 | 2020-04-07 | East Baton Rouge | Louisiana | 22033 | 892 | 31 |
41588 | 41588 | 2020-04-08 | East Baton Rouge | Louisiana | 22033 | 935 | 33 |
44164 | 44164 | 2020-04-09 | East Baton Rouge | Louisiana | 22033 | 1000 | 36 |
46772 | 46772 | 2020-04-10 | East Baton Rouge | Louisiana | 22033 | 1088 | 39 |
49413 | 49413 | 2020-04-11 | East Baton Rouge | Louisiana | 22033 | 1158 | 45 |
52083 | 52083 | 2020-04-12 | East Baton Rouge | Louisiana | 22033 | 1223 | 49 |
54764 | 54764 | 2020-04-13 | East Baton Rouge | Louisiana | 22033 | 1273 | 52 |
57462 | 57462 | 2020-04-14 | East Baton Rouge | Louisiana | 22033 | 1295 | 58 |
60170 | 60170 | 2020-04-15 | East Baton Rouge | Louisiana | 22033 | 1325 | 62 |
62891 | 62891 | 2020-04-16 | East Baton Rouge | Louisiana | 22033 | 1389 | 66 |
65630 | 65630 | 2020-04-17 | East Baton Rouge | Louisiana | 22033 | 1424 | 66 |
68379 | 68379 | 2020-04-18 | East Baton Rouge | Louisiana | 22033 | 1476 | 72 |
71142 | 71142 | 2020-04-19 | East Baton Rouge | Louisiana | 22033 | 1512 | 72 |
73914 | 73914 | 2020-04-20 | East Baton Rouge | Louisiana | 22033 | 1534 | 74 |
76694 | 76694 | 2020-04-21 | East Baton Rouge | Louisiana | 22033 | 1560 | 90 |
79480 | 79480 | 2020-04-22 | East Baton Rouge | Louisiana | 22033 | 1603 | 95 |
82276 | 82276 | 2020-04-23 | East Baton Rouge | Louisiana | 22033 | 1636 | 100 |
85080 | 85080 | 2020-04-24 | East Baton Rouge | Louisiana | 22033 | 1697 | 109 |
87889 | 87889 | 2020-04-25 | East Baton Rouge | Louisiana | 22033 | 1720 | 114 |
90705 | 90705 | 2020-04-26 | East Baton Rouge | Louisiana | 22033 | 1739 | 120 |
93526 | 93526 | 2020-04-27 | East Baton Rouge | Louisiana | 22033 | 1771 | 124 |
96361 | 96361 | 2020-04-28 | East Baton Rouge | Louisiana | 22033 | 1787 | 125 |
99207 | 99207 | 2020-04-29 | East Baton Rouge | Louisiana | 22033 | 1830 | 129 |
102059 | 102059 | 2020-04-30 | East Baton Rouge | Louisiana | 22033 | 1874 | 137 |
104920 | 104920 | 2020-05-01 | East Baton Rouge | Louisiana | 22033 | 1989 | 146 |
107784 | 107784 | 2020-05-02 | East Baton Rouge | Louisiana | 22033 | 2054 | 148 |
110656 | 110656 | 2020-05-03 | East Baton Rouge | Louisiana | 22033 | 2086 | 153 |
113533 | 113533 | 2020-05-04 | East Baton Rouge | Louisiana | 22033 | 2131 | 156 |
116415 | 116415 | 2020-05-05 | East Baton Rouge | Louisiana | 22033 | 2175 | 163 |
119376 | 119376 | 2020-05-06 | East Baton Rouge | Louisiana | 22033 | 2224 | 165 |
122347 | 122347 | 2020-05-07 | East Baton Rouge | Louisiana | 22033 | 2256 | 170 |
125329 | 125329 | 2020-05-08 | East Baton Rouge | Louisiana | 22033 | 2284 | 171 |
128316 | 128316 | 2020-05-09 | East Baton Rouge | Louisiana | 22033 | 2348 | 179 |
131306 | 131306 | 2020-05-10 | East Baton Rouge | Louisiana | 22033 | 2374 | 182 |
134297 | 134297 | 2020-05-11 | East Baton Rouge | Louisiana | 22033 | 2398 | 188 |
137287 | 137287 | 2020-05-12 | East Baton Rouge | Louisiana | 22033 | 2445 | 190 |
140281 | 140281 | 2020-05-13 | East Baton Rouge | Louisiana | 22033 | 2487 | 199 |
143276 | 143276 | 2020-05-14 | East Baton Rouge | Louisiana | 22033 | 2898 | 201 |
146276 | 146276 | 2020-05-15 | East Baton Rouge | Louisiana | 22033 | 2953 | 205 |
149281 | 149281 | 2020-05-16 | East Baton Rouge | Louisiana | 22033 | 3009 | 208 |
152292 | 152292 | 2020-05-17 | East Baton Rouge | Louisiana | 22033 | 3034 | 212 |
155306 | 155306 | 2020-05-18 | East Baton Rouge | Louisiana | 22033 | 3056 | 216 |
158324 | 158324 | 2020-05-19 | East Baton Rouge | Louisiana | 22033 | 3145 | 219 |
161350 | 161350 | 2020-05-20 | East Baton Rouge | Louisiana | 22033 | 3213 | 221 |
164379 | 164379 | 2020-05-21 | East Baton Rouge | Louisiana | 22033 | 3319 | 225 |
167415 | 167415 | 2020-05-22 | East Baton Rouge | Louisiana | 22033 | 3370 | 227 |
170453 | 170453 | 2020-05-23 | East Baton Rouge | Louisiana | 22033 | 3382 | 227 |
173494 | 173494 | 2020-05-24 | East Baton Rouge | Louisiana | 22033 | 3386 | 227 |
176538 | 176538 | 2020-05-25 | East Baton Rouge | Louisiana | 22033 | 3438 | 227 |
179582 | 179582 | 2020-05-26 | East Baton Rouge | Louisiana | 22033 | 3462 | 230 |
182627 | 182627 | 2020-05-27 | East Baton Rouge | Louisiana | 22033 | 3491 | 230 |
185682 | 185682 | 2020-05-28 | East Baton Rouge | Louisiana | 22033 | 3526 | 233 |
188740 | 188740 | 2020-05-29 | East Baton Rouge | Louisiana | 22033 | 3526 | 236 |
191804 | 191804 | 2020-05-30 | East Baton Rouge | Louisiana | 22033 | 3591 | 239 |
194872 | 194872 | 2020-05-31 | East Baton Rouge | Louisiana | 22033 | 3618 | 239 |
197943 | 197943 | 2020-06-01 | East Baton Rouge | Louisiana | 22033 | 3666 | 239 |
201015 | 201015 | 2020-06-02 | East Baton Rouge | Louisiana | 22033 | 3730 | 240 |
204092 | 204092 | 2020-06-03 | East Baton Rouge | Louisiana | 22033 | 3773 | 242 |
207173 | 207173 | 2020-06-04 | East Baton Rouge | Louisiana | 22033 | 3820 | 246 |
210254 | 210254 | 2020-06-05 | East Baton Rouge | Louisiana | 22033 | 3874 | 250 |
213339 | 213339 | 2020-06-06 | East Baton Rouge | Louisiana | 22033 | 3911 | 250 |
216426 | 216426 | 2020-06-07 | East Baton Rouge | Louisiana | 22033 | 3949 | 252 |
219518 | 219518 | 2020-06-08 | East Baton Rouge | Louisiana | 22033 | 3963 | 252 |
222613 | 222613 | 2020-06-09 | East Baton Rouge | Louisiana | 22033 | 4023 | 252 |
225709 | 225709 | 2020-06-10 | East Baton Rouge | Louisiana | 22033 | 4054 | 254 |
228811 | 228811 | 2020-06-11 | East Baton Rouge | Louisiana | 22033 | 4088 | 254 |
231915 | 231915 | 2020-06-12 | East Baton Rouge | Louisiana | 22033 | 4150 | 256 |
235020 | 235020 | 2020-06-13 | East Baton Rouge | Louisiana | 22033 | 4197 | 256 |
238127 | 238127 | 2020-06-14 | East Baton Rouge | Louisiana | 22033 | 4226 | 258 |
241236 | 241236 | 2020-06-15 | East Baton Rouge | Louisiana | 22033 | 4284 | 259 |
244347 | 244347 | 2020-06-16 | East Baton Rouge | Louisiana | 22033 | 4301 | 260 |
247460 | 247460 | 2020-06-17 | East Baton Rouge | Louisiana | 22033 | 4357 | 260 |
250572 | 250572 | 2020-06-18 | East Baton Rouge | Louisiana | 22033 | 4357 | 260 |
253687 | 253687 | 2020-06-19 | East Baton Rouge | Louisiana | 22033 | 4218 | 262 |
256807 | 256807 | 2020-06-20 | East Baton Rouge | Louisiana | 22033 | 4332 | 263 |
259933 | 259933 | 2020-06-21 | East Baton Rouge | Louisiana | 22033 | 4374 | 263 |
263062 | 263062 | 2020-06-22 | East Baton Rouge | Louisiana | 22033 | 4398 | 265 |
266189 | 266189 | 2020-06-23 | East Baton Rouge | Louisiana | 22033 | 4514 | 265 |
269322 | 269322 | 2020-06-24 | East Baton Rouge | Louisiana | 22033 | 4637 | 266 |
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);