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: deaths, date (date)
cases 593 ✖
- 30036 5
- 34894 5
- 54375 5
- 21287 4
- 22828 4
- 22956 4
- 23292 4
- 30939 4
- 35616 4
- 36906 4
- 43421 4
- 54662 4
- 4 3
- 13043 3
- 13933 3
- 20689 3
- 21011 3
- 21664 3
- 21956 3
- 22167 3
- 22340 3
- 22484 3
- 22615 3
- 22710 3
- 22849 3
- 23069 3
- 23181 3
- 23426 3
- 23638 3
- 24068 3
- 24824 3
- 25775 3
- 27372 3
- 28778 3
- 32113 3
- 32730 3
- 33184 3
- 33542 3
- 33838 3
- 34107 3
- 34331 3
- 34467 3
- 34556 3
- 34666 3
- 34803 3
- 35010 3
- 35137 3
- 35297 3
- 39813 3
- 41198 3
- 45999 3
- 50008 3
- 53008 3
- 53791 3
- 54131 3
- 54447 3
- 54515 3
- 54573 3
- 54588 3
- 54610 3
- 54639 3
- 54689 3
- 54731 3
- 54780 3
- 309 2
- 496 2
- 521 2
- 568 2
- 588 2
- 824 2
- 1138 2
- 2000 2
- 4028 2
- 5127 2
- 6278 2
- 6752 2
- 6815 2
- 7013 2
- 7235 2
- 7298 2
- 7465 2
- 7592 2
- 7632 2
- 7708 2
- 7831 2
- 7907 2
- 7947 2
- 8028 2
- 8044 2
- 8138 2
- 8302 2
- 8461 2
- 8643 2
- 8736 2
- 9353 2
- 9924 2
- 10254 2
- 10393 2
- 10939 2
- 11677 2
- 12400 2
- 15076 2
- 15949 2
- 16736 2
- 17614 2
- 18186 2
- 18656 2
- 18725 2
- 18778 2
- 19299 2
- 19723 2
- 20232 2
- 21441 2
- 34644 2
- 1 1
- 3 1
- 5 1
- 11 1
- 15 1
- 22 1
- 28 1
- 35 1
- 42 1
- 65 1
- 90 1
- 108 1
- 119 1
- 135 1
- 139 1
- 159 1
- 186 1
- 191 1
- 209 1
- 228 1
- 248 1
- 259 1
- 268 1
- 273 1
- 282 1
- 300 1
- 323 1
- 324 1
- 334 1
- 341 1
- 352 1
- 356 1
- 360 1
- 363 1
- 369 1
- 377 1
- 386 1
- 389 1
- 437 1
- 449 1
- 455 1
- 464 1
- 470 1
- 475 1
- 478 1
- 481 1
- 490 1
- 493 1
- 505 1
- 507 1
- 513 1
- 514 1
- 517 1
- 520 1
- 548 1
- 567 1
- 572 1
- 578 1
- 581 1
- 596 1
- 599 1
- 608 1
- 611 1
- 613 1
- 621 1
- 625 1
- 632 1
- 637 1
- 642 1
- 661 1
- 673 1
- 684 1
- 701 1
- 741 1
- 755 1
- 772 1
- 789 1
- 831 1
- 876 1
- 888 1
- 921 1
- 971 1
- 1010 1
- 1061 1
- 1205 1
- 1257 1
- 1300 1
- 1729 1
- 1852 1
- 2153 1
- 2289 1
- 2408 1
- 2701 1
- 2797 1
- 2975 1
- 3061 1
- 3127 1
- 3236 1
- 3435 1
- 3705 1
- 3864 1
- 4231 1
- 4481 1
- 4578 1
- 4742 1
- 4995 1
- 5459 1
- 5626 1
- 5709 1
- 5810 1
- 5913 1
- 6440 1
- 6527 1
- 6594 1
- 6641 1
- 6695 1
- 6862 1
- 6924 1
- 6960 1
- 7044 1
- 7045 1
- 7093 1
- 7154 1
- 7194 1
- 7256 1
- 7269 1
- 7277 1
- 7284 1
- 7285 1
- 7438 1
- 7439 1
- 7441 1
- 7442 1
- 7445 1
- 7474 1
- 7476 1
- 7487 1
- 7549 1
- 7580 1
- 7623 1
- 7645 1
- 7698 1
- 7744 1
- 7745 1
- 7773 1
- 7794 1
- 7812 1
- 7854 1
- 7856 1
- 7869 1
- 7892 1
- 7899 1
- 7954 1
- 7986 1
- 8005 1
- 8068 1
- 8095 1
- 8106 1
- 8185 1
- 8187 1
- 8198 1
- 8256 1
- 8284 1
- 8353 1
- 8366 1
- 8402 1
- 8419 1
- 8441 1
- 8530 1
- 8531 1
- 8544 1
- 8549 1
- 8605 1
- 8700 1
- 8713 1
- 8806 1
- 9520 1
- 9542 1
- 9664 1
- 9743 1
- 9826 1
- 10032 1
- 10058 1
- 10200 1
- 10449 1
- 10460 1
- 10730 1
- 10764 1
- 10856 1
- 11056 1
- 11087 1
- 11183 1
- 11447 1
- 11532 1
- 11822 1
- 11868 1
- 11934 1
- 12121 1
- 12244 1
- 12562 1
- 12586 1
- 12812 1
- 12959 1
- 13092 1
- 13105 1
- 13305 1
- 13766 1
- 14096 1
- 14106 1
- 14161 1
- 14772 1
- 14955 1
- 15260 1
- 15294 1
- 15528 1
- 15641 1
- 15809 1
- 16156 1
- 16176 1
- 16266 1
- 16456 1
- 16676 1
- 16928 1
- 16970 1
- 17076 1
- 17385 1
- 17525 1
- 17786 1
- 17809 1
- 18004 1
- 18094 1
- 18169 1
- 18292 1
- 18327 1
- 18436 1
- 18443 1
- 18589 1
- 18710 1
- 18718 1
- 18748 1
- 18919 1
- 18923 1
- 19096 1
- 19137 1
- 19181 1
- 19459 1
- 19491 1
- 19584 1
- 19640 1
- 19697 1
- 19822 1
- 19882 1
- 20060 1
- 20126 1
- 20174 1
- 20299 1
- 20323 1
- 20480 1
- 20551 1
- 20654 1
- 20857 1
- 20919 1
- 20945 1
- 20955 1
- 21120 1
- 21161 1
- 21220 1
- 21512 1
- 21564 1
- 21764 1
- 21792 1
- 21823 1
- 21911 1
- 22033 1
- 22057 1
- 22111 1
- 22138 1
- 22230 1
- 22263 1
- 22265 1
- 22300 1
- 22372 1
- 22422 1
- 22449 1
- 22466 1
- 22538 1
- 22582 1
- 22592 1
- 22607 1
- 22645 1
- 22665 1
- 22681 1
- 22702 1
- 22743 1
- 22780 1
- 22790 1
- 22807 1
- 22836 1
- 22837 1
- 22851 1
- 22859 1
- 22899 1
- 22925 1
- 22991 1
- 23015 1
- 23037 1
- 23054 1
- 23122 1
- 23131 1
- 23154 1
- 23175 1
- 23232 1
- 23239 1
- 23263 1
- 23279 1
- 23348 1
- 23387 1
- 23409 1
- 23476 1
- 23497 1
- 23546 1
- 23580 1
- 23727 1
- 23743 1
- 23910 1
- 23981 1
- 24210 1
- 24471 1
- 24580 1
- 24679 1
- 25148 1
- 25289 1
- 25458 1
- 25602 1
- 26427 1
- 26647 1
- 26830 1
- 26953 1
- 27919 1
- 28019 1
- 28286 1
- 28495 1
- 29288 1
- 29369 1
- 29738 1
- 29890 1
- 30685 1
- 30815 1
- 31201 1
- 31581 1
- 32009 1
- 32317 1
- 32466 1
- 32554 1
- 32612 1
- 32888 1
- 32917 1
- 33073 1
- 33142 1
- 33326 1
- 33403 1
- 33445 1
- 33479 1
- 33622 1
- 33685 1
- 33742 1
- 33791 1
- 33914 1
- 33968 1
- 34011 1
- 34061 1
- 34170 1
- 34222 1
- 34252 1
- 34290 1
- 34378 1
- 34395 1
- 34439 1
- 34454 1
- 34494 1
- 34507 1
- 34520 1
- 34548 1
- 34598 1
- 34620 1
- 34709 1
- 34732 1
- 34759 1
- 34780 1
- 34846 1
- 34875 1
- 34942 1
- 34953 1
- 34981 1
- 34988 1
- 35045 1
- 35068 1
- 35106 1
- 35128 1
- 35182 1
- 35203 1
- 35232 1
- 35261 1
- 35400 1
- 35468 1
- 35540 1
- 36008 1
- 36180 1
- 36490 1
- 37985 1
- 38363 1
- 38741 1
- 39312 1
- 40822 1
- 44686 1
- 45121 1
- 45635 1
- 46676 1
- 46983 1
- 49466 1
- 49746 1
- 50378 1
- 50596 1
- 50804 1
- 51013 1
- 53342 1
- 53421 1
- 53509 1
- 53607 1
- 53894 1
- 53970 1
- 54030 1
- 54072 1
- 54183 1
- 54298 1
- 54333 1
- 54354 1
- 54410 1
- 54436 1
- 54466 1
- 54479 1
- 54502 1
- 54508 1
- 54532 1
- 54539 1
- 54545 1
- 54564 1
- 54576 1
- 54577 1
- 54579 1
- 54584 1
- 54590 1
- 54592 1
- 54596 1
- 54605 1
- 54617 1
- 54618 1
- 54628 1
- 54635 1
- 54645 1
- 54653 1
- 54658 1
- 54670 1
- 54675 1
- 54679 1
- 54683 1
- 54701 1
- 54707 1
- 54713 1
- 54726 1
- 54745 1
- 54754 1
- 54764 1
- 54774 1
- 54799 1
- 54816 1
- 54825 1
- 54851 1
- 54862 1
state 1
- Louisiana 786
fips 1
- 22019 · 786 ✖
county 1
- Calcasieu 786
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);