ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22121 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 |
---|---|---|---|---|---|---|---|
4707 | 4707 | 2020-03-19 | West Baton Rouge | Louisiana | 22121 | 2 | 0 |
5525 | 5525 | 2020-03-20 | West Baton Rouge | Louisiana | 22121 | 3 | 0 |
6480 | 6480 | 2020-03-21 | West Baton Rouge | Louisiana | 22121 | 3 | 0 |
7555 | 7555 | 2020-03-22 | West Baton Rouge | Louisiana | 22121 | 3 | 0 |
8724 | 8724 | 2020-03-23 | West Baton Rouge | Louisiana | 22121 | 4 | 1 |
10013 | 10013 | 2020-03-24 | West Baton Rouge | Louisiana | 22121 | 5 | 1 |
11421 | 11421 | 2020-03-25 | West Baton Rouge | Louisiana | 22121 | 7 | 1 |
13001 | 13001 | 2020-03-26 | West Baton Rouge | Louisiana | 22121 | 8 | 1 |
14708 | 14708 | 2020-03-27 | West Baton Rouge | Louisiana | 22121 | 11 | 1 |
16528 | 16528 | 2020-03-28 | West Baton Rouge | Louisiana | 22121 | 12 | 1 |
18442 | 18442 | 2020-03-29 | West Baton Rouge | Louisiana | 22121 | 12 | 1 |
20458 | 20458 | 2020-03-30 | West Baton Rouge | Louisiana | 22121 | 12 | 1 |
22567 | 22567 | 2020-03-31 | West Baton Rouge | Louisiana | 22121 | 13 | 1 |
24743 | 24743 | 2020-04-01 | West Baton Rouge | Louisiana | 22121 | 14 | 1 |
26994 | 26994 | 2020-04-02 | West Baton Rouge | Louisiana | 22121 | 19 | 1 |
29311 | 29311 | 2020-04-03 | West Baton Rouge | Louisiana | 22121 | 23 | 3 |
31689 | 31689 | 2020-04-04 | West Baton Rouge | Louisiana | 22121 | 40 | 4 |
34114 | 34114 | 2020-04-05 | West Baton Rouge | Louisiana | 22121 | 40 | 7 |
36572 | 36572 | 2020-04-06 | West Baton Rouge | Louisiana | 22121 | 45 | 7 |
39080 | 39080 | 2020-04-07 | West Baton Rouge | Louisiana | 22121 | 52 | 7 |
41632 | 41632 | 2020-04-08 | West Baton Rouge | Louisiana | 22121 | 54 | 9 |
44208 | 44208 | 2020-04-09 | West Baton Rouge | Louisiana | 22121 | 57 | 9 |
46816 | 46816 | 2020-04-10 | West Baton Rouge | Louisiana | 22121 | 61 | 9 |
49458 | 49458 | 2020-04-11 | West Baton Rouge | Louisiana | 22121 | 66 | 9 |
52128 | 52128 | 2020-04-12 | West Baton Rouge | Louisiana | 22121 | 68 | 9 |
54809 | 54809 | 2020-04-13 | West Baton Rouge | Louisiana | 22121 | 72 | 9 |
57507 | 57507 | 2020-04-14 | West Baton Rouge | Louisiana | 22121 | 76 | 9 |
60215 | 60215 | 2020-04-15 | West Baton Rouge | Louisiana | 22121 | 78 | 9 |
62936 | 62936 | 2020-04-16 | West Baton Rouge | Louisiana | 22121 | 81 | 9 |
65675 | 65675 | 2020-04-17 | West Baton Rouge | Louisiana | 22121 | 83 | 9 |
68424 | 68424 | 2020-04-18 | West Baton Rouge | Louisiana | 22121 | 86 | 10 |
71187 | 71187 | 2020-04-19 | West Baton Rouge | Louisiana | 22121 | 88 | 10 |
73959 | 73959 | 2020-04-20 | West Baton Rouge | Louisiana | 22121 | 90 | 10 |
76739 | 76739 | 2020-04-21 | West Baton Rouge | Louisiana | 22121 | 90 | 12 |
79525 | 79525 | 2020-04-22 | West Baton Rouge | Louisiana | 22121 | 90 | 12 |
82321 | 82321 | 2020-04-23 | West Baton Rouge | Louisiana | 22121 | 90 | 12 |
85125 | 85125 | 2020-04-24 | West Baton Rouge | Louisiana | 22121 | 93 | 13 |
87934 | 87934 | 2020-04-25 | West Baton Rouge | Louisiana | 22121 | 92 | 15 |
90750 | 90750 | 2020-04-26 | West Baton Rouge | Louisiana | 22121 | 91 | 15 |
93571 | 93571 | 2020-04-27 | West Baton Rouge | Louisiana | 22121 | 94 | 16 |
96406 | 96406 | 2020-04-28 | West Baton Rouge | Louisiana | 22121 | 94 | 16 |
99252 | 99252 | 2020-04-29 | West Baton Rouge | Louisiana | 22121 | 96 | 16 |
102104 | 102104 | 2020-04-30 | West Baton Rouge | Louisiana | 22121 | 98 | 18 |
104965 | 104965 | 2020-05-01 | West Baton Rouge | Louisiana | 22121 | 108 | 19 |
107829 | 107829 | 2020-05-02 | West Baton Rouge | Louisiana | 22121 | 110 | 19 |
110701 | 110701 | 2020-05-03 | West Baton Rouge | Louisiana | 22121 | 110 | 22 |
113578 | 113578 | 2020-05-04 | West Baton Rouge | Louisiana | 22121 | 111 | 22 |
116460 | 116460 | 2020-05-05 | West Baton Rouge | Louisiana | 22121 | 115 | 23 |
119421 | 119421 | 2020-05-06 | West Baton Rouge | Louisiana | 22121 | 118 | 24 |
122392 | 122392 | 2020-05-07 | West Baton Rouge | Louisiana | 22121 | 118 | 24 |
125374 | 125374 | 2020-05-08 | West Baton Rouge | Louisiana | 22121 | 119 | 24 |
128361 | 128361 | 2020-05-09 | West Baton Rouge | Louisiana | 22121 | 122 | 25 |
131351 | 131351 | 2020-05-10 | West Baton Rouge | Louisiana | 22121 | 123 | 26 |
134342 | 134342 | 2020-05-11 | West Baton Rouge | Louisiana | 22121 | 123 | 29 |
137332 | 137332 | 2020-05-12 | West Baton Rouge | Louisiana | 22121 | 124 | 28 |
140326 | 140326 | 2020-05-13 | West Baton Rouge | Louisiana | 22121 | 124 | 30 |
143321 | 143321 | 2020-05-14 | West Baton Rouge | Louisiana | 22121 | 150 | 30 |
146321 | 146321 | 2020-05-15 | West Baton Rouge | Louisiana | 22121 | 150 | 30 |
149326 | 149326 | 2020-05-16 | West Baton Rouge | Louisiana | 22121 | 148 | 30 |
152337 | 152337 | 2020-05-17 | West Baton Rouge | Louisiana | 22121 | 148 | 30 |
155351 | 155351 | 2020-05-18 | West Baton Rouge | Louisiana | 22121 | 148 | 30 |
158369 | 158369 | 2020-05-19 | West Baton Rouge | Louisiana | 22121 | 148 | 30 |
161395 | 161395 | 2020-05-20 | West Baton Rouge | Louisiana | 22121 | 149 | 30 |
164424 | 164424 | 2020-05-21 | West Baton Rouge | Louisiana | 22121 | 152 | 30 |
167460 | 167460 | 2020-05-22 | West Baton Rouge | Louisiana | 22121 | 154 | 30 |
170498 | 170498 | 2020-05-23 | West Baton Rouge | Louisiana | 22121 | 154 | 30 |
173539 | 173539 | 2020-05-24 | West Baton Rouge | Louisiana | 22121 | 154 | 30 |
176583 | 176583 | 2020-05-25 | West Baton Rouge | Louisiana | 22121 | 156 | 30 |
179627 | 179627 | 2020-05-26 | West Baton Rouge | Louisiana | 22121 | 157 | 30 |
182672 | 182672 | 2020-05-27 | West Baton Rouge | Louisiana | 22121 | 158 | 30 |
185727 | 185727 | 2020-05-28 | West Baton Rouge | Louisiana | 22121 | 159 | 31 |
188785 | 188785 | 2020-05-29 | West Baton Rouge | Louisiana | 22121 | 159 | 31 |
191849 | 191849 | 2020-05-30 | West Baton Rouge | Louisiana | 22121 | 161 | 30 |
194917 | 194917 | 2020-05-31 | West Baton Rouge | Louisiana | 22121 | 166 | 30 |
197988 | 197988 | 2020-06-01 | West Baton Rouge | Louisiana | 22121 | 175 | 30 |
201060 | 201060 | 2020-06-02 | West Baton Rouge | Louisiana | 22121 | 176 | 31 |
204137 | 204137 | 2020-06-03 | West Baton Rouge | Louisiana | 22121 | 176 | 31 |
207218 | 207218 | 2020-06-04 | West Baton Rouge | Louisiana | 22121 | 180 | 31 |
210299 | 210299 | 2020-06-05 | West Baton Rouge | Louisiana | 22121 | 180 | 31 |
213384 | 213384 | 2020-06-06 | West Baton Rouge | Louisiana | 22121 | 183 | 31 |
216471 | 216471 | 2020-06-07 | West Baton Rouge | Louisiana | 22121 | 185 | 31 |
219563 | 219563 | 2020-06-08 | West Baton Rouge | Louisiana | 22121 | 186 | 31 |
222658 | 222658 | 2020-06-09 | West Baton Rouge | Louisiana | 22121 | 192 | 31 |
225754 | 225754 | 2020-06-10 | West Baton Rouge | Louisiana | 22121 | 195 | 31 |
228856 | 228856 | 2020-06-11 | West Baton Rouge | Louisiana | 22121 | 197 | 31 |
231960 | 231960 | 2020-06-12 | West Baton Rouge | Louisiana | 22121 | 200 | 31 |
235065 | 235065 | 2020-06-13 | West Baton Rouge | Louisiana | 22121 | 202 | 31 |
238172 | 238172 | 2020-06-14 | West Baton Rouge | Louisiana | 22121 | 204 | 31 |
241281 | 241281 | 2020-06-15 | West Baton Rouge | Louisiana | 22121 | 204 | 31 |
244392 | 244392 | 2020-06-16 | West Baton Rouge | Louisiana | 22121 | 204 | 31 |
247505 | 247505 | 2020-06-17 | West Baton Rouge | Louisiana | 22121 | 205 | 30 |
250617 | 250617 | 2020-06-18 | West Baton Rouge | Louisiana | 22121 | 205 | 30 |
253732 | 253732 | 2020-06-19 | West Baton Rouge | Louisiana | 22121 | 231 | 30 |
256852 | 256852 | 2020-06-20 | West Baton Rouge | Louisiana | 22121 | 232 | 30 |
259978 | 259978 | 2020-06-21 | West Baton Rouge | Louisiana | 22121 | 234 | 30 |
263107 | 263107 | 2020-06-22 | West Baton Rouge | Louisiana | 22121 | 234 | 30 |
266234 | 266234 | 2020-06-23 | West Baton Rouge | Louisiana | 22121 | 232 | 30 |
269367 | 269367 | 2020-06-24 | West Baton Rouge | Louisiana | 22121 | 239 | 30 |
272503 | 272503 | 2020-06-25 | West Baton Rouge | Louisiana | 22121 | 243 | 30 |
275646 | 275646 | 2020-06-26 | West Baton Rouge | Louisiana | 22121 | 243 | 30 |
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);