ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Lawrence" and fips = 47099 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1039851 | 1039851 | 2021-02-17 | Lawrence | Tennessee | 47099 | 5524 | 79 |
1036606 | 1036606 | 2021-02-16 | Lawrence | Tennessee | 47099 | 5524 | 79 |
1033361 | 1033361 | 2021-02-15 | Lawrence | Tennessee | 47099 | 5510 | 79 |
1030115 | 1030115 | 2021-02-14 | Lawrence | Tennessee | 47099 | 5502 | 79 |
1026868 | 1026868 | 2021-02-13 | Lawrence | Tennessee | 47099 | 5491 | 79 |
1023623 | 1023623 | 2021-02-12 | Lawrence | Tennessee | 47099 | 5480 | 78 |
1020378 | 1020378 | 2021-02-11 | Lawrence | Tennessee | 47099 | 5472 | 78 |
1017133 | 1017133 | 2021-02-10 | Lawrence | Tennessee | 47099 | 5444 | 77 |
1013888 | 1013888 | 2021-02-09 | Lawrence | Tennessee | 47099 | 5465 | 78 |
1010643 | 1010643 | 2021-02-08 | Lawrence | Tennessee | 47099 | 5469 | 78 |
1007397 | 1007397 | 2021-02-07 | Lawrence | Tennessee | 47099 | 5467 | 78 |
1004151 | 1004151 | 2021-02-06 | Lawrence | Tennessee | 47099 | 5447 | 78 |
1000905 | 1000905 | 2021-02-05 | Lawrence | Tennessee | 47099 | 5436 | 76 |
997659 | 997659 | 2021-02-04 | Lawrence | Tennessee | 47099 | 5412 | 75 |
994413 | 994413 | 2021-02-03 | Lawrence | Tennessee | 47099 | 5399 | 75 |
991167 | 991167 | 2021-02-02 | Lawrence | Tennessee | 47099 | 5377 | 74 |
987921 | 987921 | 2021-02-01 | Lawrence | Tennessee | 47099 | 5373 | 74 |
984674 | 984674 | 2021-01-31 | Lawrence | Tennessee | 47099 | 5370 | 73 |
981427 | 981427 | 2021-01-30 | Lawrence | Tennessee | 47099 | 5339 | 73 |
978181 | 978181 | 2021-01-29 | Lawrence | Tennessee | 47099 | 5326 | 73 |
974936 | 974936 | 2021-01-28 | Lawrence | Tennessee | 47099 | 5289 | 73 |
971691 | 971691 | 2021-01-27 | Lawrence | Tennessee | 47099 | 5279 | 72 |
968446 | 968446 | 2021-01-26 | Lawrence | Tennessee | 47099 | 5258 | 70 |
965202 | 965202 | 2021-01-25 | Lawrence | Tennessee | 47099 | 5243 | 69 |
961957 | 961957 | 2021-01-24 | Lawrence | Tennessee | 47099 | 5233 | 69 |
958712 | 958712 | 2021-01-23 | Lawrence | Tennessee | 47099 | 5221 | 69 |
955466 | 955466 | 2021-01-22 | Lawrence | Tennessee | 47099 | 5188 | 69 |
952221 | 952221 | 2021-01-21 | Lawrence | Tennessee | 47099 | 5168 | 69 |
948976 | 948976 | 2021-01-20 | Lawrence | Tennessee | 47099 | 5142 | 69 |
945730 | 945730 | 2021-01-19 | Lawrence | Tennessee | 47099 | 5114 | 69 |
942483 | 942483 | 2021-01-18 | Lawrence | Tennessee | 47099 | 5089 | 69 |
939238 | 939238 | 2021-01-17 | Lawrence | Tennessee | 47099 | 5075 | 69 |
935993 | 935993 | 2021-01-16 | Lawrence | Tennessee | 47099 | 5063 | 69 |
932748 | 932748 | 2021-01-15 | Lawrence | Tennessee | 47099 | 5028 | 69 |
929503 | 929503 | 2021-01-14 | Lawrence | Tennessee | 47099 | 5001 | 69 |
926258 | 926258 | 2021-01-13 | Lawrence | Tennessee | 47099 | 4956 | 69 |
923012 | 923012 | 2021-01-12 | Lawrence | Tennessee | 47099 | 4938 | 68 |
919767 | 919767 | 2021-01-11 | Lawrence | Tennessee | 47099 | 4916 | 67 |
916522 | 916522 | 2021-01-10 | Lawrence | Tennessee | 47099 | 4885 | 66 |
913277 | 913277 | 2021-01-09 | Lawrence | Tennessee | 47099 | 4822 | 66 |
910032 | 910032 | 2021-01-08 | Lawrence | Tennessee | 47099 | 4801 | 66 |
906787 | 906787 | 2021-01-07 | Lawrence | Tennessee | 47099 | 4767 | 64 |
903541 | 903541 | 2021-01-06 | Lawrence | Tennessee | 47099 | 4676 | 64 |
900296 | 900296 | 2021-01-05 | Lawrence | Tennessee | 47099 | 4630 | 63 |
897051 | 897051 | 2021-01-04 | Lawrence | Tennessee | 47099 | 4600 | 62 |
893805 | 893805 | 2021-01-03 | Lawrence | Tennessee | 47099 | 4551 | 59 |
890559 | 890559 | 2021-01-02 | Lawrence | Tennessee | 47099 | 4519 | 59 |
887312 | 887312 | 2021-01-01 | Lawrence | Tennessee | 47099 | 4416 | 58 |
884067 | 884067 | 2020-12-31 | Lawrence | Tennessee | 47099 | 4416 | 58 |
880822 | 880822 | 2020-12-30 | Lawrence | Tennessee | 47099 | 4369 | 57 |
877577 | 877577 | 2020-12-29 | Lawrence | Tennessee | 47099 | 4310 | 57 |
874332 | 874332 | 2020-12-28 | Lawrence | Tennessee | 47099 | 4294 | 57 |
871087 | 871087 | 2020-12-27 | Lawrence | Tennessee | 47099 | 4266 | 57 |
867842 | 867842 | 2020-12-26 | Lawrence | Tennessee | 47099 | 4243 | 55 |
864597 | 864597 | 2020-12-25 | Lawrence | Tennessee | 47099 | 4223 | 55 |
861352 | 861352 | 2020-12-24 | Lawrence | Tennessee | 47099 | 4149 | 55 |
858107 | 858107 | 2020-12-23 | Lawrence | Tennessee | 47099 | 4112 | 54 |
854862 | 854862 | 2020-12-22 | Lawrence | Tennessee | 47099 | 4070 | 54 |
851617 | 851617 | 2020-12-21 | Lawrence | Tennessee | 47099 | 4016 | 52 |
848372 | 848372 | 2020-12-20 | Lawrence | Tennessee | 47099 | 3960 | 52 |
845127 | 845127 | 2020-12-19 | Lawrence | Tennessee | 47099 | 3859 | 52 |
841881 | 841881 | 2020-12-18 | Lawrence | Tennessee | 47099 | 3834 | 51 |
838636 | 838636 | 2020-12-17 | Lawrence | Tennessee | 47099 | 3778 | 51 |
835390 | 835390 | 2020-12-16 | Lawrence | Tennessee | 47099 | 3721 | 48 |
832144 | 832144 | 2020-12-15 | Lawrence | Tennessee | 47099 | 3604 | 47 |
828897 | 828897 | 2020-12-14 | Lawrence | Tennessee | 47099 | 3480 | 45 |
825651 | 825651 | 2020-12-13 | Lawrence | Tennessee | 47099 | 3455 | 44 |
822404 | 822404 | 2020-12-12 | Lawrence | Tennessee | 47099 | 3369 | 43 |
819158 | 819158 | 2020-12-11 | Lawrence | Tennessee | 47099 | 3291 | 41 |
815912 | 815912 | 2020-12-10 | Lawrence | Tennessee | 47099 | 3227 | 39 |
812666 | 812666 | 2020-12-09 | Lawrence | Tennessee | 47099 | 3182 | 39 |
809422 | 809422 | 2020-12-08 | Lawrence | Tennessee | 47099 | 3128 | 38 |
806177 | 806177 | 2020-12-07 | Lawrence | Tennessee | 47099 | 3055 | 38 |
802932 | 802932 | 2020-12-06 | Lawrence | Tennessee | 47099 | 2996 | 38 |
799687 | 799687 | 2020-12-05 | Lawrence | Tennessee | 47099 | 2987 | 38 |
796442 | 796442 | 2020-12-04 | Lawrence | Tennessee | 47099 | 2937 | 38 |
793197 | 793197 | 2020-12-03 | Lawrence | Tennessee | 47099 | 2902 | 37 |
789952 | 789952 | 2020-12-02 | Lawrence | Tennessee | 47099 | 2885 | 36 |
786707 | 786707 | 2020-12-01 | Lawrence | Tennessee | 47099 | 2841 | 34 |
783463 | 783463 | 2020-11-30 | Lawrence | Tennessee | 47099 | 2761 | 34 |
780218 | 780218 | 2020-11-29 | Lawrence | Tennessee | 47099 | 2701 | 34 |
776972 | 776972 | 2020-11-28 | Lawrence | Tennessee | 47099 | 2700 | 34 |
773727 | 773727 | 2020-11-27 | Lawrence | Tennessee | 47099 | 2639 | 34 |
770482 | 770482 | 2020-11-26 | Lawrence | Tennessee | 47099 | 2600 | 34 |
767236 | 767236 | 2020-11-25 | Lawrence | Tennessee | 47099 | 2535 | 33 |
763991 | 763991 | 2020-11-24 | Lawrence | Tennessee | 47099 | 2515 | 32 |
760746 | 760746 | 2020-11-23 | Lawrence | Tennessee | 47099 | 2507 | 32 |
757501 | 757501 | 2020-11-22 | Lawrence | Tennessee | 47099 | 2496 | 32 |
754254 | 754254 | 2020-11-21 | Lawrence | Tennessee | 47099 | 2457 | 32 |
751008 | 751008 | 2020-11-20 | Lawrence | Tennessee | 47099 | 2430 | 32 |
747762 | 747762 | 2020-11-19 | Lawrence | Tennessee | 47099 | 2399 | 31 |
744516 | 744516 | 2020-11-18 | Lawrence | Tennessee | 47099 | 2364 | 28 |
741269 | 741269 | 2020-11-17 | Lawrence | Tennessee | 47099 | 2339 | 26 |
738023 | 738023 | 2020-11-16 | Lawrence | Tennessee | 47099 | 2315 | 26 |
734779 | 734779 | 2020-11-15 | Lawrence | Tennessee | 47099 | 2253 | 25 |
731533 | 731533 | 2020-11-14 | Lawrence | Tennessee | 47099 | 2217 | 25 |
728289 | 728289 | 2020-11-13 | Lawrence | Tennessee | 47099 | 2169 | 25 |
725045 | 725045 | 2020-11-12 | Lawrence | Tennessee | 47099 | 2134 | 24 |
721802 | 721802 | 2020-11-11 | Lawrence | Tennessee | 47099 | 2103 | 24 |
718559 | 718559 | 2020-11-10 | Lawrence | Tennessee | 47099 | 2065 | 24 |
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);