ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Calcasieu" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
947530 | 947530 | 2021-01-20 | Calcasieu | Louisiana | 22019 | 16456 | 310 |
944283 | 944283 | 2021-01-19 | Calcasieu | Louisiana | 22019 | 16266 | 310 |
941038 | 941038 | 2021-01-18 | Calcasieu | Louisiana | 22019 | 16176 | 307 |
937793 | 937793 | 2021-01-17 | Calcasieu | Louisiana | 22019 | 16156 | 303 |
934548 | 934548 | 2021-01-16 | Calcasieu | Louisiana | 22019 | 15949 | 298 |
931303 | 931303 | 2021-01-15 | Calcasieu | Louisiana | 22019 | 15949 | 298 |
928058 | 928058 | 2021-01-14 | Calcasieu | Louisiana | 22019 | 15809 | 298 |
924812 | 924812 | 2021-01-13 | Calcasieu | Louisiana | 22019 | 15641 | 295 |
921567 | 921567 | 2021-01-12 | Calcasieu | Louisiana | 22019 | 15528 | 295 |
918322 | 918322 | 2021-01-11 | Calcasieu | Louisiana | 22019 | 15294 | 296 |
915077 | 915077 | 2021-01-10 | Calcasieu | Louisiana | 22019 | 15260 | 296 |
911832 | 911832 | 2021-01-09 | Calcasieu | Louisiana | 22019 | 15076 | 296 |
908587 | 908587 | 2021-01-08 | Calcasieu | Louisiana | 22019 | 15076 | 296 |
905341 | 905341 | 2021-01-07 | Calcasieu | Louisiana | 22019 | 14955 | 294 |
902096 | 902096 | 2021-01-06 | Calcasieu | Louisiana | 22019 | 14772 | 294 |
898851 | 898851 | 2021-01-05 | Calcasieu | Louisiana | 22019 | 14161 | 292 |
895606 | 895606 | 2021-01-04 | Calcasieu | Louisiana | 22019 | 14106 | 291 |
892359 | 892359 | 2021-01-03 | Calcasieu | Louisiana | 22019 | 14096 | 291 |
889113 | 889113 | 2021-01-02 | Calcasieu | Louisiana | 22019 | 13933 | 285 |
885867 | 885867 | 2021-01-01 | Calcasieu | Louisiana | 22019 | 13933 | 285 |
882622 | 882622 | 2020-12-31 | Calcasieu | Louisiana | 22019 | 13933 | 285 |
879377 | 879377 | 2020-12-30 | Calcasieu | Louisiana | 22019 | 13766 | 283 |
876132 | 876132 | 2020-12-29 | Calcasieu | Louisiana | 22019 | 13305 | 281 |
872887 | 872887 | 2020-12-28 | Calcasieu | Louisiana | 22019 | 13105 | 280 |
869642 | 869642 | 2020-12-27 | Calcasieu | Louisiana | 22019 | 13092 | 280 |
866397 | 866397 | 2020-12-26 | Calcasieu | Louisiana | 22019 | 13043 | 278 |
863152 | 863152 | 2020-12-25 | Calcasieu | Louisiana | 22019 | 13043 | 278 |
859907 | 859907 | 2020-12-24 | Calcasieu | Louisiana | 22019 | 13043 | 278 |
856662 | 856662 | 2020-12-23 | Calcasieu | Louisiana | 22019 | 12959 | 277 |
853417 | 853417 | 2020-12-22 | Calcasieu | Louisiana | 22019 | 12812 | 277 |
850172 | 850172 | 2020-12-21 | Calcasieu | Louisiana | 22019 | 12586 | 275 |
846927 | 846927 | 2020-12-20 | Calcasieu | Louisiana | 22019 | 12562 | 273 |
843681 | 843681 | 2020-12-19 | Calcasieu | Louisiana | 22019 | 12400 | 270 |
840436 | 840436 | 2020-12-18 | Calcasieu | Louisiana | 22019 | 12400 | 270 |
837191 | 837191 | 2020-12-17 | Calcasieu | Louisiana | 22019 | 12244 | 268 |
833945 | 833945 | 2020-12-16 | Calcasieu | Louisiana | 22019 | 12121 | 264 |
830698 | 830698 | 2020-12-15 | Calcasieu | Louisiana | 22019 | 11934 | 263 |
827452 | 827452 | 2020-12-14 | Calcasieu | Louisiana | 22019 | 11868 | 261 |
824205 | 824205 | 2020-12-13 | Calcasieu | Louisiana | 22019 | 11822 | 259 |
820959 | 820959 | 2020-12-12 | Calcasieu | Louisiana | 22019 | 11677 | 259 |
817713 | 817713 | 2020-12-11 | Calcasieu | Louisiana | 22019 | 11677 | 259 |
814467 | 814467 | 2020-12-10 | Calcasieu | Louisiana | 22019 | 11532 | 260 |
811222 | 811222 | 2020-12-09 | Calcasieu | Louisiana | 22019 | 11447 | 260 |
807977 | 807977 | 2020-12-08 | Calcasieu | Louisiana | 22019 | 11183 | 260 |
804732 | 804732 | 2020-12-07 | Calcasieu | Louisiana | 22019 | 11087 | 256 |
801487 | 801487 | 2020-12-06 | Calcasieu | Louisiana | 22019 | 11056 | 256 |
798242 | 798242 | 2020-12-05 | Calcasieu | Louisiana | 22019 | 10939 | 252 |
794997 | 794997 | 2020-12-04 | Calcasieu | Louisiana | 22019 | 10939 | 252 |
791752 | 791752 | 2020-12-03 | Calcasieu | Louisiana | 22019 | 10856 | 252 |
788507 | 788507 | 2020-12-02 | Calcasieu | Louisiana | 22019 | 10764 | 249 |
785263 | 785263 | 2020-12-01 | Calcasieu | Louisiana | 22019 | 10730 | 249 |
782018 | 782018 | 2020-11-30 | Calcasieu | Louisiana | 22019 | 10460 | 246 |
778772 | 778772 | 2020-11-29 | Calcasieu | Louisiana | 22019 | 10449 | 245 |
775527 | 775527 | 2020-11-28 | Calcasieu | Louisiana | 22019 | 10393 | 245 |
772282 | 772282 | 2020-11-27 | Calcasieu | Louisiana | 22019 | 10393 | 245 |
769037 | 769037 | 2020-11-26 | Calcasieu | Louisiana | 22019 | 10254 | 243 |
765791 | 765791 | 2020-11-25 | Calcasieu | Louisiana | 22019 | 10254 | 243 |
762546 | 762546 | 2020-11-24 | Calcasieu | Louisiana | 22019 | 10200 | 242 |
759301 | 759301 | 2020-11-23 | Calcasieu | Louisiana | 22019 | 10058 | 241 |
756054 | 756054 | 2020-11-22 | Calcasieu | Louisiana | 22019 | 10032 | 241 |
752808 | 752808 | 2020-11-21 | Calcasieu | Louisiana | 22019 | 9924 | 241 |
749562 | 749562 | 2020-11-20 | Calcasieu | Louisiana | 22019 | 9924 | 241 |
746316 | 746316 | 2020-11-19 | Calcasieu | Louisiana | 22019 | 9826 | 239 |
743069 | 743069 | 2020-11-18 | Calcasieu | Louisiana | 22019 | 9743 | 239 |
739822 | 739822 | 2020-11-17 | Calcasieu | Louisiana | 22019 | 9664 | 239 |
736578 | 736578 | 2020-11-16 | Calcasieu | Louisiana | 22019 | 9542 | 238 |
733332 | 733332 | 2020-11-15 | Calcasieu | Louisiana | 22019 | 9520 | 238 |
730087 | 730087 | 2020-11-14 | Calcasieu | Louisiana | 22019 | 9353 | 238 |
726844 | 726844 | 2020-11-13 | Calcasieu | Louisiana | 22019 | 9353 | 238 |
723601 | 723601 | 2020-11-12 | Calcasieu | Louisiana | 22019 | 8806 | 233 |
720358 | 720358 | 2020-11-11 | Calcasieu | Louisiana | 22019 | 8736 | 231 |
717115 | 717115 | 2020-11-10 | Calcasieu | Louisiana | 22019 | 8736 | 231 |
713871 | 713871 | 2020-11-09 | Calcasieu | Louisiana | 22019 | 8713 | 231 |
710627 | 710627 | 2020-11-08 | Calcasieu | Louisiana | 22019 | 8700 | 231 |
707383 | 707383 | 2020-11-07 | Calcasieu | Louisiana | 22019 | 8643 | 231 |
704140 | 704140 | 2020-11-06 | Calcasieu | Louisiana | 22019 | 8643 | 231 |
700898 | 700898 | 2020-11-05 | Calcasieu | Louisiana | 22019 | 8605 | 231 |
697654 | 697654 | 2020-11-04 | Calcasieu | Louisiana | 22019 | 8549 | 230 |
694411 | 694411 | 2020-11-03 | Calcasieu | Louisiana | 22019 | 8544 | 230 |
691169 | 691169 | 2020-11-02 | Calcasieu | Louisiana | 22019 | 8531 | 230 |
687924 | 687924 | 2020-11-01 | Calcasieu | Louisiana | 22019 | 8530 | 230 |
684680 | 684680 | 2020-10-31 | Calcasieu | Louisiana | 22019 | 8461 | 230 |
681437 | 681437 | 2020-10-30 | Calcasieu | Louisiana | 22019 | 8461 | 230 |
678193 | 678193 | 2020-10-29 | Calcasieu | Louisiana | 22019 | 8441 | 230 |
674951 | 674951 | 2020-10-28 | Calcasieu | Louisiana | 22019 | 8419 | 230 |
671708 | 671708 | 2020-10-27 | Calcasieu | Louisiana | 22019 | 8402 | 230 |
668466 | 668466 | 2020-10-26 | Calcasieu | Louisiana | 22019 | 8366 | 230 |
665222 | 665222 | 2020-10-25 | Calcasieu | Louisiana | 22019 | 8353 | 230 |
661977 | 661977 | 2020-10-24 | Calcasieu | Louisiana | 22019 | 8302 | 224 |
658733 | 658733 | 2020-10-23 | Calcasieu | Louisiana | 22019 | 8302 | 224 |
655488 | 655488 | 2020-10-22 | Calcasieu | Louisiana | 22019 | 8284 | 224 |
652243 | 652243 | 2020-10-21 | Calcasieu | Louisiana | 22019 | 8256 | 223 |
648998 | 648998 | 2020-10-20 | Calcasieu | Louisiana | 22019 | 8198 | 222 |
645754 | 645754 | 2020-10-19 | Calcasieu | Louisiana | 22019 | 8187 | 222 |
642507 | 642507 | 2020-10-18 | Calcasieu | Louisiana | 22019 | 8185 | 221 |
639260 | 639260 | 2020-10-17 | Calcasieu | Louisiana | 22019 | 8138 | 221 |
636014 | 636014 | 2020-10-16 | Calcasieu | Louisiana | 22019 | 8138 | 221 |
632768 | 632768 | 2020-10-15 | Calcasieu | Louisiana | 22019 | 8106 | 221 |
629524 | 629524 | 2020-10-14 | Calcasieu | Louisiana | 22019 | 8095 | 221 |
626280 | 626280 | 2020-10-13 | Calcasieu | Louisiana | 22019 | 8068 | 221 |
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);