ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 22097 sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 573 ✖
- 9057 7
- 22161 6
- 12418 5
- 14356 5
- 22064 5
- 22165 5
- 3 4
- 8555 4
- 9108 4
- 9223 4
- 12746 4
- 14594 4
- 14894 4
- 17275 4
- 22126 4
- 22190 4
- 22204 4
- 10 3
- 244 3
- 247 3
- 252 3
- 6286 3
- 6576 3
- 8444 3
- 8514 3
- 8591 3
- 8649 3
- 8757 3
- 8813 3
- 8896 3
- 8935 3
- 8992 3
- 9151 3
- 9167 3
- 9283 3
- 9401 3
- 9661 3
- 10098 3
- 10661 3
- 11261 3
- 11901 3
- 13083 3
- 13427 3
- 13630 3
- 13763 3
- 13848 3
- 13904 3
- 14006 3
- 14103 3
- 14188 3
- 14258 3
- 14313 3
- 14417 3
- 14469 3
- 14523 3
- 15881 3
- 16488 3
- 18520 3
- 20553 3
- 21303 3
- 21782 3
- 21972 3
- 22102 3
- 22143 3
- 22154 3
- 22221 3
- 22245 3
- 2 2
- 45 2
- 136 2
- 163 2
- 215 2
- 237 2
- 309 2
- 393 2
- 578 2
- 716 2
- 1345 2
- 1774 2
- 2082 2
- 2631 2
- 2866 2
- 2976 2
- 3032 2
- 3141 2
- 3220 2
- 3230 2
- 3248 2
- 3260 2
- 3299 2
- 3391 2
- 3439 2
- 3510 2
- 3616 2
- 3681 2
- 3798 2
- 3880 2
- 4157 2
- 4597 2
- 4844 2
- 5004 2
- 5332 2
- 5646 2
- 6036 2
- 7010 2
- 7355 2
- 7587 2
- 7830 2
- 7990 2
- 8130 2
- 8163 2
- 8175 2
- 8271 2
- 8346 2
- 8394 2
- 8427 2
- 8568 2
- 8734 2
- 14242 2
- 22163 2
- 4 1
- 5 1
- 15 1
- 31 1
- 47 1
- 52 1
- 56 1
- 60 1
- 68 1
- 86 1
- 90 1
- 103 1
- 109 1
- 113 1
- 114 1
- 115 1
- 116 1
- 118 1
- 119 1
- 133 1
- 134 1
- 140 1
- 154 1
- 157 1
- 167 1
- 170 1
- 172 1
- 180 1
- 181 1
- 185 1
- 186 1
- 191 1
- 198 1
- 202 1
- 203 1
- 204 1
- 211 1
- 214 1
- 230 1
- 231 1
- 235 1
- 241 1
- 248 1
- 249 1
- 255 1
- 257 1
- 263 1
- 266 1
- 269 1
- 272 1
- 308 1
- 311 1
- 316 1
- 323 1
- 324 1
- 326 1
- 358 1
- 360 1
- 370 1
- 379 1
- 453 1
- 462 1
- 465 1
- 484 1
- 517 1
- 530 1
- 540 1
- 605 1
- 619 1
- 626 1
- 653 1
- 672 1
- 763 1
- 797 1
- 850 1
- 887 1
- 944 1
- 1023 1
- 1080 1
- 1128 1
- 1159 1
- 1198 1
- 1243 1
- 1308 1
- 1437 1
- 1527 1
- 1552 1
- 1655 1
- 1737 1
- 1880 1
- 1927 1
- 1981 1
- 2034 1
- 2054 1
- 2183 1
- 2226 1
- 2530 1
- 2556 1
- 2583 1
- 2727 1
- 2735 1
- 2778 1
- 2824 1
- 2841 1
- 2895 1
- 2908 1
- 2925 1
- 2950 1
- 2968 1
- 3000 1
- 3001 1
- 3006 1
- 3021 1
- 3026 1
- 3096 1
- 3098 1
- 3110 1
- 3130 1
- 3139 1
- 3156 1
- 3160 1
- 3161 1
- 3205 1
- 3209 1
- 3232 1
- 3235 1
- 3239 1
- 3271 1
- 3272 1
- 3279 1
- 3307 1
- 3312 1
- 3314 1
- 3317 1
- 3337 1
- 3382 1
- 3390 1
- 3403 1
- 3423 1
- 3433 1
- 3480 1
- 3485 1
- 3486 1
- 3495 1
- 3503 1
- 3529 1
- 3532 1
- 3551 1
- 3565 1
- 3597 1
- 3625 1
- 3637 1
- 3675 1
- 3678 1
- 3679 1
- 3702 1
- 3704 1
- 3745 1
- 3761 1
- 3785 1
- 3837 1
- 3847 1
- 3925 1
- 4261 1
- 4276 1
- 4355 1
- 4410 1
- 4487 1
- 4747 1
- 4765 1
- 4799 1
- 5034 1
- 5038 1
- 5184 1
- 5215 1
- 5265 1
- 5430 1
- 5439 1
- 5482 1
- 5517 1
- 5561 1
- 5747 1
- 5775 1
- 5820 1
- 5896 1
- 5957 1
- 6102 1
- 6113 1
- 6174 1
- 6256 1
- 6325 1
- 6340 1
- 6365 1
- 6509 1
- 6663 1
- 6677 1
- 6758 1
- 6882 1
- 6961 1
- 7122 1
- 7125 1
- 7213 1
- 7247 1
- 7295 1
- 7416 1
- 7432 1
- 7466 1
- 7518 1
- 7562 1
- 7663 1
- 7678 1
- 7706 1
- 7757 1
- 7794 1
- 7870 1
- 7902 1
- 7920 1
- 7948 1
- 7968 1
- 8047 1
- 8064 1
- 8068 1
- 8072 1
- 8121 1
- 8128 1
- 8155 1
- 8172 1
- 8206 1
- 8230 1
- 8237 1
- 8252 1
- 8264 1
- 8291 1
- 8302 1
- 8311 1
- 8322 1
- 8332 1
- 8350 1
- 8352 1
- 8372 1
- 8375 1
- 8376 1
- 8410 1
- 8412 1
- 8449 1
- 8481 1
- 8485 1
- 8489 1
- 8501 1
- 8534 1
- 8544 1
- 8547 1
- 8556 1
- 8579 1
- 8602 1
- 8623 1
- 8625 1
- 8635 1
- 8724 1
- 8750 1
- 8779 1
- 8785 1
- 8792 1
- 8807 1
- 8825 1
- 8847 1
- 8864 1
- 8874 1
- 8911 1
- 8920 1
- 8932 1
- 8940 1
- 8960 1
- 8962 1
- 8967 1
- 8986 1
- 8998 1
- 9034 1
- 9038 1
- 9051 1
- 9053 1
- 9070 1
- 9071 1
- 9072 1
- 9081 1
- 9095 1
- 9118 1
- 9128 1
- 9133 1
- 9141 1
- 9155 1
- 9159 1
- 9162 1
- 9164 1
- 9183 1
- 9184 1
- 9190 1
- 9210 1
- 9229 1
- 9251 1
- 9261 1
- 9329 1
- 9339 1
- 9354 1
- 9377 1
- 9458 1
- 9492 1
- 9567 1
- 9616 1
- 9795 1
- 9867 1
- 9952 1
- 10004 1
- 10267 1
- 10339 1
- 10437 1
- 10506 1
- 10938 1
- 11038 1
- 11085 1
- 11166 1
- 11545 1
- 11589 1
- 11723 1
- 11814 1
- 12075 1
- 12160 1
- 12258 1
- 12379 1
- 12636 1
- 12678 1
- 12874 1
- 12966 1
- 13065 1
- 13208 1
- 13226 1
- 13322 1
- 13343 1
- 13513 1
- 13527 1
- 13570 1
- 13614 1
- 13684 1
- 13704 1
- 13717 1
- 13733 1
- 13790 1
- 13815 1
- 13822 1
- 13839 1
- 13868 1
- 13878 1
- 13882 1
- 13891 1
- 13924 1
- 13932 1
- 13937 1
- 13983 1
- 14039 1
- 14048 1
- 14081 1
- 14095 1
- 14134 1
- 14144 1
- 14161 1
- 14177 1
- 14221 1
- 14227 1
- 14277 1
- 14280 1
- 14296 1
- 14302 1
- 14325 1
- 14348 1
- 14389 1
- 14393 1
- 14410 1
- 14413 1
- 14432 1
- 14443 1
- 14453 1
- 14462 1
- 14483 1
- 14493 1
- 14503 1
- 14514 1
- 14547 1
- 14555 1
- 14577 1
- 14683 1
- 14703 1
- 14788 1
- 15214 1
- 15317 1
- 15435 1
- 15638 1
- 16337 1
- 17822 1
- 18010 1
- 18274 1
- 18883 1
- 19157 1
- 20177 1
- 20349 1
- 20811 1
- 20934 1
- 21055 1
- 21180 1
- 21546 1
- 21608 1
- 21666 1
- 21716 1
- 21858 1
- 21881 1
- 21912 1
- 21943 1
- 22027 1
- 22036 1
- 22042 1
- 22055 1
- 22089 1
- 22097 1
- 22113 1
- 22121 1
- 22123 1
- 22136 1
- 22139 1
- 22140 1
- 22141 1
- 22145 1
- 22146 1
- 22151 1
- 22153 1
- 22158 1
- 22170 1
- 22174 1
- 22186 1
- 22194 1
- 22200 1
- 22202 1
- 22206 1
- 22208 1
- 22211 1
- 22216 1
- 22227 1
- 22233 1
- 22238 1
- 22242 1
- 22252 1
- 22259 1
- 22264 1
- 22275 1
- 22279 1
state 1
- Louisiana 786
fips 1
- 22097 · 786 ✖
county 1
- St. Landry 786
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4701 | 4701 | 2020-03-19 | St. Landry | Louisiana | 22097 | 2 | 0 |
5518 | 5518 | 2020-03-20 | St. Landry | Louisiana | 22097 | 2 | 0 |
6472 | 6472 | 2020-03-21 | St. Landry | Louisiana | 22097 | 3 | 0 |
7547 | 7547 | 2020-03-22 | St. Landry | Louisiana | 22097 | 3 | 0 |
8715 | 8715 | 2020-03-23 | St. Landry | Louisiana | 22097 | 3 | 0 |
10003 | 10003 | 2020-03-24 | St. Landry | Louisiana | 22097 | 3 | 0 |
11410 | 11410 | 2020-03-25 | St. Landry | Louisiana | 22097 | 4 | 0 |
12989 | 12989 | 2020-03-26 | St. Landry | Louisiana | 22097 | 5 | 0 |
14696 | 14696 | 2020-03-27 | St. Landry | Louisiana | 22097 | 10 | 0 |
16516 | 16516 | 2020-03-28 | St. Landry | Louisiana | 22097 | 10 | 0 |
18430 | 18430 | 2020-03-29 | St. Landry | Louisiana | 22097 | 10 | 0 |
20446 | 20446 | 2020-03-30 | St. Landry | Louisiana | 22097 | 15 | 1 |
22555 | 22555 | 2020-03-31 | St. Landry | Louisiana | 22097 | 31 | 1 |
24731 | 24731 | 2020-04-01 | St. Landry | Louisiana | 22097 | 45 | 1 |
26982 | 26982 | 2020-04-02 | St. Landry | Louisiana | 22097 | 56 | 1 |
29299 | 29299 | 2020-04-03 | St. Landry | Louisiana | 22097 | 68 | 2 |
31677 | 31677 | 2020-04-04 | St. Landry | Louisiana | 22097 | 45 | 2 |
34102 | 34102 | 2020-04-05 | St. Landry | Louisiana | 22097 | 47 | 4 |
36560 | 36560 | 2020-04-06 | St. Landry | Louisiana | 22097 | 52 | 4 |
39068 | 39068 | 2020-04-07 | St. Landry | Louisiana | 22097 | 60 | 4 |
41620 | 41620 | 2020-04-08 | St. Landry | Louisiana | 22097 | 86 | 4 |
44196 | 44196 | 2020-04-09 | St. Landry | Louisiana | 22097 | 90 | 4 |
46804 | 46804 | 2020-04-10 | St. Landry | Louisiana | 22097 | 103 | 6 |
49445 | 49445 | 2020-04-11 | St. Landry | Louisiana | 22097 | 109 | 11 |
52115 | 52115 | 2020-04-12 | St. Landry | Louisiana | 22097 | 113 | 13 |
54796 | 54796 | 2020-04-13 | St. Landry | Louisiana | 22097 | 114 | 13 |
57494 | 57494 | 2020-04-14 | St. Landry | Louisiana | 22097 | 115 | 16 |
60202 | 60202 | 2020-04-15 | St. Landry | Louisiana | 22097 | 116 | 16 |
62923 | 62923 | 2020-04-16 | St. Landry | Louisiana | 22097 | 118 | 17 |
65662 | 65662 | 2020-04-17 | St. Landry | Louisiana | 22097 | 119 | 18 |
68411 | 68411 | 2020-04-18 | St. Landry | Louisiana | 22097 | 133 | 20 |
71174 | 71174 | 2020-04-19 | St. Landry | Louisiana | 22097 | 134 | 20 |
73946 | 73946 | 2020-04-20 | St. Landry | Louisiana | 22097 | 136 | 20 |
76726 | 76726 | 2020-04-21 | St. Landry | Louisiana | 22097 | 136 | 26 |
79512 | 79512 | 2020-04-22 | St. Landry | Louisiana | 22097 | 140 | 29 |
82308 | 82308 | 2020-04-23 | St. Landry | Louisiana | 22097 | 154 | 31 |
85112 | 85112 | 2020-04-24 | St. Landry | Louisiana | 22097 | 157 | 34 |
87921 | 87921 | 2020-04-25 | St. Landry | Louisiana | 22097 | 163 | 34 |
90737 | 90737 | 2020-04-26 | St. Landry | Louisiana | 22097 | 163 | 34 |
93558 | 93558 | 2020-04-27 | St. Landry | Louisiana | 22097 | 167 | 35 |
96393 | 96393 | 2020-04-28 | St. Landry | Louisiana | 22097 | 170 | 37 |
99239 | 99239 | 2020-04-29 | St. Landry | Louisiana | 22097 | 172 | 39 |
102091 | 102091 | 2020-04-30 | St. Landry | Louisiana | 22097 | 180 | 42 |
104952 | 104952 | 2020-05-01 | St. Landry | Louisiana | 22097 | 181 | 44 |
107816 | 107816 | 2020-05-02 | St. Landry | Louisiana | 22097 | 185 | 44 |
110688 | 110688 | 2020-05-03 | St. Landry | Louisiana | 22097 | 186 | 45 |
113565 | 113565 | 2020-05-04 | St. Landry | Louisiana | 22097 | 191 | 45 |
116447 | 116447 | 2020-05-05 | St. Landry | Louisiana | 22097 | 198 | 47 |
119408 | 119408 | 2020-05-06 | St. Landry | Louisiana | 22097 | 202 | 48 |
122379 | 122379 | 2020-05-07 | St. Landry | Louisiana | 22097 | 203 | 49 |
125361 | 125361 | 2020-05-08 | St. Landry | Louisiana | 22097 | 204 | 49 |
128348 | 128348 | 2020-05-09 | St. Landry | Louisiana | 22097 | 211 | 49 |
131338 | 131338 | 2020-05-10 | St. Landry | Louisiana | 22097 | 215 | 50 |
134329 | 134329 | 2020-05-11 | St. Landry | Louisiana | 22097 | 214 | 50 |
137319 | 137319 | 2020-05-12 | St. Landry | Louisiana | 22097 | 215 | 51 |
140313 | 140313 | 2020-05-13 | St. Landry | Louisiana | 22097 | 241 | 51 |
143308 | 143308 | 2020-05-14 | St. Landry | Louisiana | 22097 | 244 | 51 |
146308 | 146308 | 2020-05-15 | St. Landry | Louisiana | 22097 | 244 | 51 |
149313 | 149313 | 2020-05-16 | St. Landry | Louisiana | 22097 | 230 | 51 |
152324 | 152324 | 2020-05-17 | St. Landry | Louisiana | 22097 | 231 | 51 |
155338 | 155338 | 2020-05-18 | St. Landry | Louisiana | 22097 | 235 | 51 |
158356 | 158356 | 2020-05-19 | St. Landry | Louisiana | 22097 | 237 | 51 |
161382 | 161382 | 2020-05-20 | St. Landry | Louisiana | 22097 | 237 | 52 |
164411 | 164411 | 2020-05-21 | St. Landry | Louisiana | 22097 | 244 | 52 |
167447 | 167447 | 2020-05-22 | St. Landry | Louisiana | 22097 | 247 | 52 |
170485 | 170485 | 2020-05-23 | St. Landry | Louisiana | 22097 | 247 | 52 |
173526 | 173526 | 2020-05-24 | St. Landry | Louisiana | 22097 | 247 | 52 |
176570 | 176570 | 2020-05-25 | St. Landry | Louisiana | 22097 | 248 | 52 |
179614 | 179614 | 2020-05-26 | St. Landry | Louisiana | 22097 | 249 | 52 |
182659 | 182659 | 2020-05-27 | St. Landry | Louisiana | 22097 | 252 | 52 |
185714 | 185714 | 2020-05-28 | St. Landry | Louisiana | 22097 | 252 | 54 |
188772 | 188772 | 2020-05-29 | St. Landry | Louisiana | 22097 | 252 | 54 |
191836 | 191836 | 2020-05-30 | St. Landry | Louisiana | 22097 | 255 | 54 |
194904 | 194904 | 2020-05-31 | St. Landry | Louisiana | 22097 | 257 | 54 |
197975 | 197975 | 2020-06-01 | St. Landry | Louisiana | 22097 | 263 | 54 |
201047 | 201047 | 2020-06-02 | St. Landry | Louisiana | 22097 | 266 | 54 |
204124 | 204124 | 2020-06-03 | St. Landry | Louisiana | 22097 | 269 | 54 |
207205 | 207205 | 2020-06-04 | St. Landry | Louisiana | 22097 | 272 | 54 |
210286 | 210286 | 2020-06-05 | St. Landry | Louisiana | 22097 | 308 | 54 |
213371 | 213371 | 2020-06-06 | St. Landry | Louisiana | 22097 | 309 | 54 |
216458 | 216458 | 2020-06-07 | St. Landry | Louisiana | 22097 | 309 | 54 |
219550 | 219550 | 2020-06-08 | St. Landry | Louisiana | 22097 | 311 | 54 |
222645 | 222645 | 2020-06-09 | St. Landry | Louisiana | 22097 | 316 | 54 |
225741 | 225741 | 2020-06-10 | St. Landry | Louisiana | 22097 | 323 | 54 |
228843 | 228843 | 2020-06-11 | St. Landry | Louisiana | 22097 | 324 | 55 |
231947 | 231947 | 2020-06-12 | St. Landry | Louisiana | 22097 | 326 | 55 |
235052 | 235052 | 2020-06-13 | St. Landry | Louisiana | 22097 | 358 | 55 |
238159 | 238159 | 2020-06-14 | St. Landry | Louisiana | 22097 | 360 | 55 |
241268 | 241268 | 2020-06-15 | St. Landry | Louisiana | 22097 | 370 | 55 |
244379 | 244379 | 2020-06-16 | St. Landry | Louisiana | 22097 | 379 | 55 |
247492 | 247492 | 2020-06-17 | St. Landry | Louisiana | 22097 | 393 | 55 |
250604 | 250604 | 2020-06-18 | St. Landry | Louisiana | 22097 | 393 | 55 |
253719 | 253719 | 2020-06-19 | St. Landry | Louisiana | 22097 | 453 | 55 |
256839 | 256839 | 2020-06-20 | St. Landry | Louisiana | 22097 | 462 | 55 |
259965 | 259965 | 2020-06-21 | St. Landry | Louisiana | 22097 | 465 | 55 |
263094 | 263094 | 2020-06-22 | St. Landry | Louisiana | 22097 | 484 | 55 |
266221 | 266221 | 2020-06-23 | St. Landry | Louisiana | 22097 | 517 | 57 |
269354 | 269354 | 2020-06-24 | St. Landry | Louisiana | 22097 | 530 | 57 |
272490 | 272490 | 2020-06-25 | St. Landry | Louisiana | 22097 | 540 | 57 |
275633 | 275633 | 2020-06-26 | St. Landry | Louisiana | 22097 | 578 | 57 |
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);