ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22019 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4687 | 4687 | 2020-03-19 | Calcasieu | Louisiana | 22019 | 1 | 0 |
5501 | 5501 | 2020-03-20 | Calcasieu | Louisiana | 22019 | 3 | 0 |
6452 | 6452 | 2020-03-21 | Calcasieu | Louisiana | 22019 | 4 | 0 |
7527 | 7527 | 2020-03-22 | Calcasieu | Louisiana | 22019 | 4 | 0 |
8691 | 8691 | 2020-03-23 | Calcasieu | Louisiana | 22019 | 4 | 0 |
9979 | 9979 | 2020-03-24 | Calcasieu | Louisiana | 22019 | 5 | 1 |
11383 | 11383 | 2020-03-25 | Calcasieu | Louisiana | 22019 | 11 | 1 |
12958 | 12958 | 2020-03-26 | Calcasieu | Louisiana | 22019 | 15 | 1 |
14665 | 14665 | 2020-03-27 | Calcasieu | Louisiana | 22019 | 22 | 1 |
16483 | 16483 | 2020-03-28 | Calcasieu | Louisiana | 22019 | 28 | 1 |
18395 | 18395 | 2020-03-29 | Calcasieu | Louisiana | 22019 | 35 | 1 |
20411 | 20411 | 2020-03-30 | Calcasieu | Louisiana | 22019 | 42 | 1 |
22518 | 22518 | 2020-03-31 | Calcasieu | Louisiana | 22019 | 65 | 1 |
24694 | 24694 | 2020-04-01 | Calcasieu | Louisiana | 22019 | 90 | 1 |
26944 | 26944 | 2020-04-02 | Calcasieu | Louisiana | 22019 | 108 | 1 |
29261 | 29261 | 2020-04-03 | Calcasieu | Louisiana | 22019 | 119 | 1 |
31639 | 31639 | 2020-04-04 | Calcasieu | Louisiana | 22019 | 135 | 3 |
34064 | 34064 | 2020-04-05 | Calcasieu | Louisiana | 22019 | 139 | 3 |
36522 | 36522 | 2020-04-06 | Calcasieu | Louisiana | 22019 | 159 | 3 |
39029 | 39029 | 2020-04-07 | Calcasieu | Louisiana | 22019 | 186 | 3 |
41581 | 41581 | 2020-04-08 | Calcasieu | Louisiana | 22019 | 191 | 4 |
44157 | 44157 | 2020-04-09 | Calcasieu | Louisiana | 22019 | 209 | 4 |
46765 | 46765 | 2020-04-10 | Calcasieu | Louisiana | 22019 | 228 | 5 |
49406 | 49406 | 2020-04-11 | Calcasieu | Louisiana | 22019 | 248 | 8 |
52076 | 52076 | 2020-04-12 | Calcasieu | Louisiana | 22019 | 259 | 12 |
54757 | 54757 | 2020-04-13 | Calcasieu | Louisiana | 22019 | 268 | 13 |
57455 | 57455 | 2020-04-14 | Calcasieu | Louisiana | 22019 | 273 | 14 |
60163 | 60163 | 2020-04-15 | Calcasieu | Louisiana | 22019 | 282 | 15 |
62884 | 62884 | 2020-04-16 | Calcasieu | Louisiana | 22019 | 300 | 15 |
65623 | 65623 | 2020-04-17 | Calcasieu | Louisiana | 22019 | 309 | 16 |
68372 | 68372 | 2020-04-18 | Calcasieu | Louisiana | 22019 | 309 | 18 |
71135 | 71135 | 2020-04-19 | Calcasieu | Louisiana | 22019 | 323 | 19 |
73907 | 73907 | 2020-04-20 | Calcasieu | Louisiana | 22019 | 324 | 19 |
76687 | 76687 | 2020-04-21 | Calcasieu | Louisiana | 22019 | 334 | 20 |
79473 | 79473 | 2020-04-22 | Calcasieu | Louisiana | 22019 | 341 | 23 |
82269 | 82269 | 2020-04-23 | Calcasieu | Louisiana | 22019 | 352 | 24 |
85073 | 85073 | 2020-04-24 | Calcasieu | Louisiana | 22019 | 356 | 26 |
87882 | 87882 | 2020-04-25 | Calcasieu | Louisiana | 22019 | 360 | 26 |
90698 | 90698 | 2020-04-26 | Calcasieu | Louisiana | 22019 | 363 | 27 |
93519 | 93519 | 2020-04-27 | Calcasieu | Louisiana | 22019 | 369 | 27 |
96354 | 96354 | 2020-04-28 | Calcasieu | Louisiana | 22019 | 377 | 28 |
99200 | 99200 | 2020-04-29 | Calcasieu | Louisiana | 22019 | 386 | 29 |
102052 | 102052 | 2020-04-30 | Calcasieu | Louisiana | 22019 | 389 | 29 |
104913 | 104913 | 2020-05-01 | Calcasieu | Louisiana | 22019 | 437 | 29 |
107777 | 107777 | 2020-05-02 | Calcasieu | Louisiana | 22019 | 449 | 31 |
110649 | 110649 | 2020-05-03 | Calcasieu | Louisiana | 22019 | 455 | 31 |
113526 | 113526 | 2020-05-04 | Calcasieu | Louisiana | 22019 | 464 | 31 |
116408 | 116408 | 2020-05-05 | Calcasieu | Louisiana | 22019 | 470 | 34 |
119369 | 119369 | 2020-05-06 | Calcasieu | Louisiana | 22019 | 475 | 35 |
122340 | 122340 | 2020-05-07 | Calcasieu | Louisiana | 22019 | 478 | 37 |
125322 | 125322 | 2020-05-08 | Calcasieu | Louisiana | 22019 | 481 | 38 |
128309 | 128309 | 2020-05-09 | Calcasieu | Louisiana | 22019 | 490 | 37 |
131299 | 131299 | 2020-05-10 | Calcasieu | Louisiana | 22019 | 493 | 37 |
134290 | 134290 | 2020-05-11 | Calcasieu | Louisiana | 22019 | 496 | 37 |
137280 | 137280 | 2020-05-12 | Calcasieu | Louisiana | 22019 | 496 | 40 |
140274 | 140274 | 2020-05-13 | Calcasieu | Louisiana | 22019 | 505 | 40 |
143269 | 143269 | 2020-05-14 | Calcasieu | Louisiana | 22019 | 507 | 40 |
146269 | 146269 | 2020-05-15 | Calcasieu | Louisiana | 22019 | 513 | 40 |
149274 | 149274 | 2020-05-16 | Calcasieu | Louisiana | 22019 | 514 | 40 |
152285 | 152285 | 2020-05-17 | Calcasieu | Louisiana | 22019 | 517 | 40 |
155299 | 155299 | 2020-05-18 | Calcasieu | Louisiana | 22019 | 520 | 40 |
158317 | 158317 | 2020-05-19 | Calcasieu | Louisiana | 22019 | 521 | 40 |
161343 | 161343 | 2020-05-20 | Calcasieu | Louisiana | 22019 | 521 | 42 |
164372 | 164372 | 2020-05-21 | Calcasieu | Louisiana | 22019 | 548 | 42 |
167408 | 167408 | 2020-05-22 | Calcasieu | Louisiana | 22019 | 567 | 43 |
170446 | 170446 | 2020-05-23 | Calcasieu | Louisiana | 22019 | 568 | 43 |
173487 | 173487 | 2020-05-24 | Calcasieu | Louisiana | 22019 | 568 | 43 |
176531 | 176531 | 2020-05-25 | Calcasieu | Louisiana | 22019 | 572 | 43 |
179575 | 179575 | 2020-05-26 | Calcasieu | Louisiana | 22019 | 578 | 44 |
182620 | 182620 | 2020-05-27 | Calcasieu | Louisiana | 22019 | 581 | 44 |
185675 | 185675 | 2020-05-28 | Calcasieu | Louisiana | 22019 | 588 | 45 |
188733 | 188733 | 2020-05-29 | Calcasieu | Louisiana | 22019 | 588 | 46 |
191797 | 191797 | 2020-05-30 | Calcasieu | Louisiana | 22019 | 596 | 49 |
194865 | 194865 | 2020-05-31 | Calcasieu | Louisiana | 22019 | 599 | 49 |
197936 | 197936 | 2020-06-01 | Calcasieu | Louisiana | 22019 | 608 | 49 |
201008 | 201008 | 2020-06-02 | Calcasieu | Louisiana | 22019 | 611 | 49 |
204085 | 204085 | 2020-06-03 | Calcasieu | Louisiana | 22019 | 613 | 49 |
207166 | 207166 | 2020-06-04 | Calcasieu | Louisiana | 22019 | 621 | 49 |
210247 | 210247 | 2020-06-05 | Calcasieu | Louisiana | 22019 | 625 | 51 |
213332 | 213332 | 2020-06-06 | Calcasieu | Louisiana | 22019 | 632 | 51 |
216419 | 216419 | 2020-06-07 | Calcasieu | Louisiana | 22019 | 637 | 51 |
219511 | 219511 | 2020-06-08 | Calcasieu | Louisiana | 22019 | 642 | 51 |
222606 | 222606 | 2020-06-09 | Calcasieu | Louisiana | 22019 | 661 | 51 |
225702 | 225702 | 2020-06-10 | Calcasieu | Louisiana | 22019 | 673 | 51 |
228804 | 228804 | 2020-06-11 | Calcasieu | Louisiana | 22019 | 684 | 51 |
231908 | 231908 | 2020-06-12 | Calcasieu | Louisiana | 22019 | 701 | 51 |
235013 | 235013 | 2020-06-13 | Calcasieu | Louisiana | 22019 | 741 | 51 |
238120 | 238120 | 2020-06-14 | Calcasieu | Louisiana | 22019 | 755 | 51 |
241229 | 241229 | 2020-06-15 | Calcasieu | Louisiana | 22019 | 772 | 51 |
244340 | 244340 | 2020-06-16 | Calcasieu | Louisiana | 22019 | 789 | 51 |
247453 | 247453 | 2020-06-17 | Calcasieu | Louisiana | 22019 | 824 | 52 |
250565 | 250565 | 2020-06-18 | Calcasieu | Louisiana | 22019 | 824 | 52 |
253680 | 253680 | 2020-06-19 | Calcasieu | Louisiana | 22019 | 831 | 52 |
256800 | 256800 | 2020-06-20 | Calcasieu | Louisiana | 22019 | 876 | 53 |
259926 | 259926 | 2020-06-21 | Calcasieu | Louisiana | 22019 | 888 | 53 |
263055 | 263055 | 2020-06-22 | Calcasieu | Louisiana | 22019 | 921 | 53 |
266182 | 266182 | 2020-06-23 | Calcasieu | Louisiana | 22019 | 971 | 53 |
269315 | 269315 | 2020-06-24 | Calcasieu | Louisiana | 22019 | 1010 | 54 |
272451 | 272451 | 2020-06-25 | Calcasieu | Louisiana | 22019 | 1061 | 54 |
275594 | 275594 | 2020-06-26 | Calcasieu | Louisiana | 22019 | 1138 | 54 |
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);