ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
50 rows where county = "Brown", deaths = 39 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1272383 | 1272383 | 2021-04-30 | Brown | Minnesota | 27015 | 3015 | 39 |
1269136 | 1269136 | 2021-04-29 | Brown | Minnesota | 27015 | 3010 | 39 |
1265889 | 1265889 | 2021-04-28 | Brown | Minnesota | 27015 | 2998 | 39 |
1262642 | 1262642 | 2021-04-27 | Brown | Minnesota | 27015 | 2988 | 39 |
1259395 | 1259395 | 2021-04-26 | Brown | Minnesota | 27015 | 2987 | 39 |
1256148 | 1256148 | 2021-04-25 | Brown | Minnesota | 27015 | 2984 | 39 |
1252901 | 1252901 | 2021-04-24 | Brown | Minnesota | 27015 | 2981 | 39 |
1249654 | 1249654 | 2021-04-23 | Brown | Minnesota | 27015 | 2971 | 39 |
1246407 | 1246407 | 2021-04-22 | Brown | Minnesota | 27015 | 2964 | 39 |
1243160 | 1243160 | 2021-04-21 | Brown | Minnesota | 27015 | 2956 | 39 |
1239913 | 1239913 | 2021-04-20 | Brown | Minnesota | 27015 | 2949 | 39 |
1236666 | 1236666 | 2021-04-19 | Brown | Minnesota | 27015 | 2948 | 39 |
1233419 | 1233419 | 2021-04-18 | Brown | Minnesota | 27015 | 2947 | 39 |
1230171 | 1230171 | 2021-04-17 | Brown | Minnesota | 27015 | 2944 | 39 |
1226923 | 1226923 | 2021-04-16 | Brown | Minnesota | 27015 | 2938 | 39 |
1223675 | 1223675 | 2021-04-15 | Brown | Minnesota | 27015 | 2931 | 39 |
1220428 | 1220428 | 2021-04-14 | Brown | Minnesota | 27015 | 2922 | 39 |
1217180 | 1217180 | 2021-04-13 | Brown | Minnesota | 27015 | 2917 | 39 |
1213933 | 1213933 | 2021-04-12 | Brown | Minnesota | 27015 | 2912 | 39 |
1210685 | 1210685 | 2021-04-11 | Brown | Minnesota | 27015 | 2906 | 39 |
1207436 | 1207436 | 2021-04-10 | Brown | Minnesota | 27015 | 2891 | 39 |
1204188 | 1204188 | 2021-04-09 | Brown | Minnesota | 27015 | 2884 | 39 |
1200940 | 1200940 | 2021-04-08 | Brown | Minnesota | 27015 | 2866 | 39 |
1197691 | 1197691 | 2021-04-07 | Brown | Minnesota | 27015 | 2838 | 39 |
1194442 | 1194442 | 2021-04-06 | Brown | Minnesota | 27015 | 2831 | 39 |
1191193 | 1191193 | 2021-04-05 | Brown | Minnesota | 27015 | 2816 | 39 |
1187945 | 1187945 | 2021-04-04 | Brown | Minnesota | 27015 | 2811 | 39 |
1184698 | 1184698 | 2021-04-03 | Brown | Minnesota | 27015 | 2811 | 39 |
1181452 | 1181452 | 2021-04-02 | Brown | Minnesota | 27015 | 2794 | 39 |
1178205 | 1178205 | 2021-04-01 | Brown | Minnesota | 27015 | 2776 | 39 |
1174958 | 1174958 | 2021-03-31 | Brown | Minnesota | 27015 | 2761 | 39 |
1171711 | 1171711 | 2021-03-30 | Brown | Minnesota | 27015 | 2749 | 39 |
1168463 | 1168463 | 2021-03-29 | Brown | Minnesota | 27015 | 2735 | 39 |
1165215 | 1165215 | 2021-03-28 | Brown | Minnesota | 27015 | 2720 | 39 |
1161967 | 1161967 | 2021-03-27 | Brown | Minnesota | 27015 | 2712 | 39 |
1158719 | 1158719 | 2021-03-26 | Brown | Minnesota | 27015 | 2698 | 39 |
1155472 | 1155472 | 2021-03-25 | Brown | Minnesota | 27015 | 2680 | 39 |
1152225 | 1152225 | 2021-03-24 | Brown | Minnesota | 27015 | 2659 | 39 |
1148978 | 1148978 | 2021-03-23 | Brown | Minnesota | 27015 | 2653 | 39 |
1145731 | 1145731 | 2021-03-22 | Brown | Minnesota | 27015 | 2643 | 39 |
1142484 | 1142484 | 2021-03-21 | Brown | Minnesota | 27015 | 2640 | 39 |
1139237 | 1139237 | 2021-03-20 | Brown | Minnesota | 27015 | 2633 | 39 |
1135991 | 1135991 | 2021-03-19 | Brown | Minnesota | 27015 | 2626 | 39 |
1132745 | 1132745 | 2021-03-18 | Brown | Minnesota | 27015 | 2596 | 39 |
1129497 | 1129497 | 2021-03-17 | Brown | Minnesota | 27015 | 2577 | 39 |
1126250 | 1126250 | 2021-03-16 | Brown | Minnesota | 27015 | 2570 | 39 |
1123004 | 1123004 | 2021-03-15 | Brown | Minnesota | 27015 | 2558 | 39 |
1119757 | 1119757 | 2021-03-14 | Brown | Minnesota | 27015 | 2542 | 39 |
1116510 | 1116510 | 2021-03-13 | Brown | Minnesota | 27015 | 2535 | 39 |
1113264 | 1113264 | 2021-03-12 | Brown | Minnesota | 27015 | 2523 | 39 |
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);