ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Grant" and deaths = 7 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 11
- North Dakota 345
- Oklahoma 232
- Oregon 82
- Minnesota 35
- West Virginia 33
- Washington 14
- New Mexico 11
- Kansas 7
- Wisconsin 6
- Arkansas 4
- Kentucky 3
fips 11
county 1
- Grant · 772 ✖
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
803740 | 803740 | 2020-12-07 | Grant | Arkansas | 5053 | 681 | 7 |
806985 | 806985 | 2020-12-08 | Grant | Arkansas | 5053 | 693 | 7 |
810230 | 810230 | 2020-12-09 | Grant | Arkansas | 5053 | 706 | 7 |
813474 | 813474 | 2020-12-10 | Grant | Arkansas | 5053 | 715 | 7 |
603383 | 603383 | 2020-10-06 | Grant | Kansas | 20067 | 334 | 7 |
606625 | 606625 | 2020-10-07 | Grant | Kansas | 20067 | 336 | 7 |
609868 | 609868 | 2020-10-08 | Grant | Kansas | 20067 | 343 | 7 |
613110 | 613110 | 2020-10-09 | Grant | Kansas | 20067 | 343 | 7 |
616351 | 616351 | 2020-10-10 | Grant | Kansas | 20067 | 343 | 7 |
619593 | 619593 | 2020-10-11 | Grant | Kansas | 20067 | 352 | 7 |
622837 | 622837 | 2020-10-12 | Grant | Kansas | 20067 | 352 | 7 |
840347 | 840347 | 2020-12-18 | Grant | Kentucky | 21081 | 1125 | 7 |
843592 | 843592 | 2020-12-19 | Grant | Kentucky | 21081 | 1155 | 7 |
846838 | 846838 | 2020-12-20 | Grant | Kentucky | 21081 | 1169 | 7 |
824427 | 824427 | 2020-12-13 | Grant | Minnesota | 27051 | 343 | 7 |
827674 | 827674 | 2020-12-14 | Grant | Minnesota | 27051 | 346 | 7 |
830920 | 830920 | 2020-12-15 | Grant | Minnesota | 27051 | 347 | 7 |
834167 | 834167 | 2020-12-16 | Grant | Minnesota | 27051 | 347 | 7 |
837413 | 837413 | 2020-12-17 | Grant | Minnesota | 27051 | 348 | 7 |
840658 | 840658 | 2020-12-18 | Grant | Minnesota | 27051 | 350 | 7 |
843903 | 843903 | 2020-12-19 | Grant | Minnesota | 27051 | 354 | 7 |
847149 | 847149 | 2020-12-20 | Grant | Minnesota | 27051 | 359 | 7 |
850394 | 850394 | 2020-12-21 | Grant | Minnesota | 27051 | 361 | 7 |
853639 | 853639 | 2020-12-22 | Grant | Minnesota | 27051 | 363 | 7 |
856884 | 856884 | 2020-12-23 | Grant | Minnesota | 27051 | 365 | 7 |
860129 | 860129 | 2020-12-24 | Grant | Minnesota | 27051 | 369 | 7 |
863374 | 863374 | 2020-12-25 | Grant | Minnesota | 27051 | 369 | 7 |
866619 | 866619 | 2020-12-26 | Grant | Minnesota | 27051 | 373 | 7 |
869864 | 869864 | 2020-12-27 | Grant | Minnesota | 27051 | 375 | 7 |
873109 | 873109 | 2020-12-28 | Grant | Minnesota | 27051 | 378 | 7 |
876354 | 876354 | 2020-12-29 | Grant | Minnesota | 27051 | 383 | 7 |
879599 | 879599 | 2020-12-30 | Grant | Minnesota | 27051 | 386 | 7 |
882844 | 882844 | 2020-12-31 | Grant | Minnesota | 27051 | 390 | 7 |
886089 | 886089 | 2021-01-01 | Grant | Minnesota | 27051 | 390 | 7 |
889335 | 889335 | 2021-01-02 | Grant | Minnesota | 27051 | 393 | 7 |
892581 | 892581 | 2021-01-03 | Grant | Minnesota | 27051 | 394 | 7 |
895828 | 895828 | 2021-01-04 | Grant | Minnesota | 27051 | 403 | 7 |
899073 | 899073 | 2021-01-05 | Grant | Minnesota | 27051 | 409 | 7 |
902318 | 902318 | 2021-01-06 | Grant | Minnesota | 27051 | 408 | 7 |
905563 | 905563 | 2021-01-07 | Grant | Minnesota | 27051 | 412 | 7 |
908809 | 908809 | 2021-01-08 | Grant | Minnesota | 27051 | 414 | 7 |
912054 | 912054 | 2021-01-09 | Grant | Minnesota | 27051 | 417 | 7 |
915299 | 915299 | 2021-01-10 | Grant | Minnesota | 27051 | 422 | 7 |
918544 | 918544 | 2021-01-11 | Grant | Minnesota | 27051 | 423 | 7 |
921789 | 921789 | 2021-01-12 | Grant | Minnesota | 27051 | 423 | 7 |
925034 | 925034 | 2021-01-13 | Grant | Minnesota | 27051 | 422 | 7 |
928280 | 928280 | 2021-01-14 | Grant | Minnesota | 27051 | 424 | 7 |
931525 | 931525 | 2021-01-15 | Grant | Minnesota | 27051 | 425 | 7 |
934770 | 934770 | 2021-01-16 | Grant | Minnesota | 27051 | 425 | 7 |
785954 | 785954 | 2020-12-01 | Grant | New Mexico | 35017 | 513 | 7 |
789199 | 789199 | 2020-12-02 | Grant | New Mexico | 35017 | 523 | 7 |
792444 | 792444 | 2020-12-03 | Grant | New Mexico | 35017 | 534 | 7 |
795689 | 795689 | 2020-12-04 | Grant | New Mexico | 35017 | 540 | 7 |
798934 | 798934 | 2020-12-05 | Grant | New Mexico | 35017 | 551 | 7 |
802179 | 802179 | 2020-12-06 | Grant | New Mexico | 35017 | 554 | 7 |
805424 | 805424 | 2020-12-07 | Grant | New Mexico | 35017 | 569 | 7 |
808669 | 808669 | 2020-12-08 | Grant | New Mexico | 35017 | 580 | 7 |
811914 | 811914 | 2020-12-09 | Grant | New Mexico | 35017 | 590 | 7 |
815159 | 815159 | 2020-12-10 | Grant | New Mexico | 35017 | 599 | 7 |
818405 | 818405 | 2020-12-11 | Grant | New Mexico | 35017 | 623 | 7 |
802379 | 802379 | 2020-12-06 | Grant | North Dakota | 38037 | 160 | 7 |
805624 | 805624 | 2020-12-07 | Grant | North Dakota | 38037 | 160 | 7 |
808869 | 808869 | 2020-12-08 | Grant | North Dakota | 38037 | 160 | 7 |
812114 | 812114 | 2020-12-09 | Grant | North Dakota | 38037 | 162 | 7 |
815359 | 815359 | 2020-12-10 | Grant | North Dakota | 38037 | 164 | 7 |
818605 | 818605 | 2020-12-11 | Grant | North Dakota | 38037 | 164 | 7 |
821851 | 821851 | 2020-12-12 | Grant | North Dakota | 38037 | 166 | 7 |
825098 | 825098 | 2020-12-13 | Grant | North Dakota | 38037 | 166 | 7 |
828344 | 828344 | 2020-12-14 | Grant | North Dakota | 38037 | 166 | 7 |
831591 | 831591 | 2020-12-15 | Grant | North Dakota | 38037 | 167 | 7 |
834837 | 834837 | 2020-12-16 | Grant | North Dakota | 38037 | 167 | 7 |
838083 | 838083 | 2020-12-17 | Grant | North Dakota | 38037 | 167 | 7 |
841328 | 841328 | 2020-12-18 | Grant | North Dakota | 38037 | 169 | 7 |
844574 | 844574 | 2020-12-19 | Grant | North Dakota | 38037 | 169 | 7 |
847819 | 847819 | 2020-12-20 | Grant | North Dakota | 38037 | 169 | 7 |
851064 | 851064 | 2020-12-21 | Grant | North Dakota | 38037 | 169 | 7 |
854309 | 854309 | 2020-12-22 | Grant | North Dakota | 38037 | 171 | 7 |
857554 | 857554 | 2020-12-23 | Grant | North Dakota | 38037 | 171 | 7 |
860799 | 860799 | 2020-12-24 | Grant | North Dakota | 38037 | 171 | 7 |
864044 | 864044 | 2020-12-25 | Grant | North Dakota | 38037 | 172 | 7 |
867289 | 867289 | 2020-12-26 | Grant | North Dakota | 38037 | 172 | 7 |
870534 | 870534 | 2020-12-27 | Grant | North Dakota | 38037 | 172 | 7 |
873779 | 873779 | 2020-12-28 | Grant | North Dakota | 38037 | 172 | 7 |
877024 | 877024 | 2020-12-29 | Grant | North Dakota | 38037 | 172 | 7 |
880269 | 880269 | 2020-12-30 | Grant | North Dakota | 38037 | 172 | 7 |
883514 | 883514 | 2020-12-31 | Grant | North Dakota | 38037 | 172 | 7 |
886759 | 886759 | 2021-01-01 | Grant | North Dakota | 38037 | 172 | 7 |
890006 | 890006 | 2021-01-02 | Grant | North Dakota | 38037 | 172 | 7 |
893252 | 893252 | 2021-01-03 | Grant | North Dakota | 38037 | 172 | 7 |
896498 | 896498 | 2021-01-04 | Grant | North Dakota | 38037 | 173 | 7 |
899743 | 899743 | 2021-01-05 | Grant | North Dakota | 38037 | 173 | 7 |
902988 | 902988 | 2021-01-06 | Grant | North Dakota | 38037 | 174 | 7 |
906234 | 906234 | 2021-01-07 | Grant | North Dakota | 38037 | 175 | 7 |
909479 | 909479 | 2021-01-08 | Grant | North Dakota | 38037 | 178 | 7 |
912724 | 912724 | 2021-01-09 | Grant | North Dakota | 38037 | 178 | 7 |
915969 | 915969 | 2021-01-10 | Grant | North Dakota | 38037 | 178 | 7 |
919214 | 919214 | 2021-01-11 | Grant | North Dakota | 38037 | 178 | 7 |
922459 | 922459 | 2021-01-12 | Grant | North Dakota | 38037 | 178 | 7 |
925705 | 925705 | 2021-01-13 | Grant | North Dakota | 38037 | 178 | 7 |
928950 | 928950 | 2021-01-14 | Grant | North Dakota | 38037 | 178 | 7 |
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);