ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lincoln" and state = "Louisiana" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
8703 | 8703 | 2020-03-23 | Lincoln | Louisiana | 22061 | 2 | 0 |
9991 | 9991 | 2020-03-24 | Lincoln | Louisiana | 22061 | 2 | 0 |
11397 | 11397 | 2020-03-25 | Lincoln | Louisiana | 22061 | 2 | 0 |
12974 | 12974 | 2020-03-26 | Lincoln | Louisiana | 22061 | 3 | 0 |
14681 | 14681 | 2020-03-27 | Lincoln | Louisiana | 22061 | 7 | 0 |
16501 | 16501 | 2020-03-28 | Lincoln | Louisiana | 22061 | 6 | 0 |
18413 | 18413 | 2020-03-29 | Lincoln | Louisiana | 22061 | 7 | 0 |
20429 | 20429 | 2020-03-30 | Lincoln | Louisiana | 22061 | 8 | 0 |
22537 | 22537 | 2020-03-31 | Lincoln | Louisiana | 22061 | 12 | 0 |
24713 | 24713 | 2020-04-01 | Lincoln | Louisiana | 22061 | 13 | 0 |
26964 | 26964 | 2020-04-02 | Lincoln | Louisiana | 22061 | 13 | 0 |
29281 | 29281 | 2020-04-03 | Lincoln | Louisiana | 22061 | 17 | 0 |
31659 | 31659 | 2020-04-04 | Lincoln | Louisiana | 22061 | 17 | 0 |
34084 | 34084 | 2020-04-05 | Lincoln | Louisiana | 22061 | 18 | 0 |
36542 | 36542 | 2020-04-06 | Lincoln | Louisiana | 22061 | 19 | 0 |
39050 | 39050 | 2020-04-07 | Lincoln | Louisiana | 22061 | 22 | 0 |
41602 | 41602 | 2020-04-08 | Lincoln | Louisiana | 22061 | 24 | 0 |
44178 | 44178 | 2020-04-09 | Lincoln | Louisiana | 22061 | 28 | 0 |
46786 | 46786 | 2020-04-10 | Lincoln | Louisiana | 22061 | 33 | 0 |
49427 | 49427 | 2020-04-11 | Lincoln | Louisiana | 22061 | 37 | 0 |
52097 | 52097 | 2020-04-12 | Lincoln | Louisiana | 22061 | 39 | 0 |
54778 | 54778 | 2020-04-13 | Lincoln | Louisiana | 22061 | 39 | 0 |
57476 | 57476 | 2020-04-14 | Lincoln | Louisiana | 22061 | 42 | 0 |
60184 | 60184 | 2020-04-15 | Lincoln | Louisiana | 22061 | 41 | 0 |
62905 | 62905 | 2020-04-16 | Lincoln | Louisiana | 22061 | 43 | 0 |
65644 | 65644 | 2020-04-17 | Lincoln | Louisiana | 22061 | 47 | 2 |
68393 | 68393 | 2020-04-18 | Lincoln | Louisiana | 22061 | 49 | 2 |
71156 | 71156 | 2020-04-19 | Lincoln | Louisiana | 22061 | 49 | 2 |
73928 | 73928 | 2020-04-20 | Lincoln | Louisiana | 22061 | 51 | 2 |
76708 | 76708 | 2020-04-21 | Lincoln | Louisiana | 22061 | 52 | 2 |
79494 | 79494 | 2020-04-22 | Lincoln | Louisiana | 22061 | 58 | 2 |
82290 | 82290 | 2020-04-23 | Lincoln | Louisiana | 22061 | 62 | 3 |
85094 | 85094 | 2020-04-24 | Lincoln | Louisiana | 22061 | 64 | 4 |
87903 | 87903 | 2020-04-25 | Lincoln | Louisiana | 22061 | 69 | 4 |
90719 | 90719 | 2020-04-26 | Lincoln | Louisiana | 22061 | 72 | 4 |
93540 | 93540 | 2020-04-27 | Lincoln | Louisiana | 22061 | 79 | 4 |
96375 | 96375 | 2020-04-28 | Lincoln | Louisiana | 22061 | 80 | 5 |
99221 | 99221 | 2020-04-29 | Lincoln | Louisiana | 22061 | 83 | 7 |
102073 | 102073 | 2020-04-30 | Lincoln | Louisiana | 22061 | 85 | 8 |
104934 | 104934 | 2020-05-01 | Lincoln | Louisiana | 22061 | 85 | 8 |
107798 | 107798 | 2020-05-02 | Lincoln | Louisiana | 22061 | 88 | 9 |
110670 | 110670 | 2020-05-03 | Lincoln | Louisiana | 22061 | 90 | 9 |
113547 | 113547 | 2020-05-04 | Lincoln | Louisiana | 22061 | 94 | 9 |
116429 | 116429 | 2020-05-05 | Lincoln | Louisiana | 22061 | 96 | 10 |
119390 | 119390 | 2020-05-06 | Lincoln | Louisiana | 22061 | 99 | 11 |
122361 | 122361 | 2020-05-07 | Lincoln | Louisiana | 22061 | 101 | 11 |
125343 | 125343 | 2020-05-08 | Lincoln | Louisiana | 22061 | 103 | 11 |
128330 | 128330 | 2020-05-09 | Lincoln | Louisiana | 22061 | 106 | 11 |
131320 | 131320 | 2020-05-10 | Lincoln | Louisiana | 22061 | 106 | 11 |
134311 | 134311 | 2020-05-11 | Lincoln | Louisiana | 22061 | 107 | 11 |
137301 | 137301 | 2020-05-12 | Lincoln | Louisiana | 22061 | 107 | 12 |
140295 | 140295 | 2020-05-13 | Lincoln | Louisiana | 22061 | 115 | 13 |
143290 | 143290 | 2020-05-14 | Lincoln | Louisiana | 22061 | 116 | 13 |
146290 | 146290 | 2020-05-15 | Lincoln | Louisiana | 22061 | 122 | 13 |
149295 | 149295 | 2020-05-16 | Lincoln | Louisiana | 22061 | 119 | 13 |
152306 | 152306 | 2020-05-17 | Lincoln | Louisiana | 22061 | 121 | 13 |
155320 | 155320 | 2020-05-18 | Lincoln | Louisiana | 22061 | 121 | 13 |
158338 | 158338 | 2020-05-19 | Lincoln | Louisiana | 22061 | 122 | 14 |
161364 | 161364 | 2020-05-20 | Lincoln | Louisiana | 22061 | 122 | 14 |
164393 | 164393 | 2020-05-21 | Lincoln | Louisiana | 22061 | 130 | 14 |
167429 | 167429 | 2020-05-22 | Lincoln | Louisiana | 22061 | 133 | 14 |
170467 | 170467 | 2020-05-23 | Lincoln | Louisiana | 22061 | 133 | 14 |
173508 | 173508 | 2020-05-24 | Lincoln | Louisiana | 22061 | 133 | 14 |
176552 | 176552 | 2020-05-25 | Lincoln | Louisiana | 22061 | 135 | 14 |
179596 | 179596 | 2020-05-26 | Lincoln | Louisiana | 22061 | 138 | 14 |
182641 | 182641 | 2020-05-27 | Lincoln | Louisiana | 22061 | 142 | 14 |
185696 | 185696 | 2020-05-28 | Lincoln | Louisiana | 22061 | 144 | 14 |
188754 | 188754 | 2020-05-29 | Lincoln | Louisiana | 22061 | 144 | 14 |
191818 | 191818 | 2020-05-30 | Lincoln | Louisiana | 22061 | 152 | 14 |
194886 | 194886 | 2020-05-31 | Lincoln | Louisiana | 22061 | 157 | 14 |
197957 | 197957 | 2020-06-01 | Lincoln | Louisiana | 22061 | 160 | 14 |
201029 | 201029 | 2020-06-02 | Lincoln | Louisiana | 22061 | 160 | 14 |
204106 | 204106 | 2020-06-03 | Lincoln | Louisiana | 22061 | 161 | 16 |
207187 | 207187 | 2020-06-04 | Lincoln | Louisiana | 22061 | 163 | 16 |
210268 | 210268 | 2020-06-05 | Lincoln | Louisiana | 22061 | 165 | 17 |
213353 | 213353 | 2020-06-06 | Lincoln | Louisiana | 22061 | 169 | 17 |
216440 | 216440 | 2020-06-07 | Lincoln | Louisiana | 22061 | 173 | 17 |
219532 | 219532 | 2020-06-08 | Lincoln | Louisiana | 22061 | 175 | 17 |
222627 | 222627 | 2020-06-09 | Lincoln | Louisiana | 22061 | 184 | 18 |
225723 | 225723 | 2020-06-10 | Lincoln | Louisiana | 22061 | 193 | 18 |
228825 | 228825 | 2020-06-11 | Lincoln | Louisiana | 22061 | 196 | 18 |
231929 | 231929 | 2020-06-12 | Lincoln | Louisiana | 22061 | 202 | 18 |
235034 | 235034 | 2020-06-13 | Lincoln | Louisiana | 22061 | 227 | 18 |
238141 | 238141 | 2020-06-14 | Lincoln | Louisiana | 22061 | 235 | 18 |
241250 | 241250 | 2020-06-15 | Lincoln | Louisiana | 22061 | 241 | 18 |
244361 | 244361 | 2020-06-16 | Lincoln | Louisiana | 22061 | 248 | 18 |
247474 | 247474 | 2020-06-17 | Lincoln | Louisiana | 22061 | 259 | 18 |
250586 | 250586 | 2020-06-18 | Lincoln | Louisiana | 22061 | 259 | 18 |
253701 | 253701 | 2020-06-19 | Lincoln | Louisiana | 22061 | 269 | 19 |
256821 | 256821 | 2020-06-20 | Lincoln | Louisiana | 22061 | 273 | 19 |
259947 | 259947 | 2020-06-21 | Lincoln | Louisiana | 22061 | 274 | 19 |
263076 | 263076 | 2020-06-22 | Lincoln | Louisiana | 22061 | 274 | 18 |
266203 | 266203 | 2020-06-23 | Lincoln | Louisiana | 22061 | 281 | 18 |
269336 | 269336 | 2020-06-24 | Lincoln | Louisiana | 22061 | 290 | 18 |
272472 | 272472 | 2020-06-25 | Lincoln | Louisiana | 22061 | 294 | 18 |
275615 | 275615 | 2020-06-26 | Lincoln | Louisiana | 22061 | 300 | 18 |
278763 | 278763 | 2020-06-27 | Lincoln | Louisiana | 22061 | 300 | 18 |
281911 | 281911 | 2020-06-28 | Lincoln | Louisiana | 22061 | 312 | 18 |
285057 | 285057 | 2020-06-29 | Lincoln | Louisiana | 22061 | 314 | 18 |
288206 | 288206 | 2020-06-30 | Lincoln | Louisiana | 22061 | 323 | 18 |
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);