ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,584 rows where county = "Ramsey" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 486 ✖
- 30 226
- 1 80
- 2 80
- 0 74
- 57 63
- 47 23
- 4 22
- 31 22
- 38 22
- 33 21
- 42 15
- 3 14
- 8 13
- 55 13
- 37 12
- 910 12
- 54 9
- 6 8
- 28 8
- 39 8
- 41 8
- 888 7
- 911 7
- 917 7
- 1328 7
- 1336 7
- 9 6
- 13 6
- 29 6
- 44 6
- 46 6
- 52 6
- 217 6
- 859 6
- 895 6
- 1322 6
- 10 5
- 16 5
- 34 5
- 49 5
- 261 5
- 298 5
- 318 5
- 841 5
- 889 5
- 908 5
- 953 5
- 1337 5
- 5 4
- 7 4
- 17 4
- 18 4
- 21 4
- 32 4
- 35 4
- 56 4
- 326 4
- 335 4
- 780 4
- 870 4
- 886 4
- 905 4
- 913 4
- 918 4
- 930 4
- 936 4
- 964 4
- 1003 4
- 1012 4
- 1054 4
- 1111 4
- 1129 4
- 1174 4
- 1293 4
- 1301 4
- 1317 4
- 1325 4
- 1332 4
- 1333 4
- 15 3
- 26 3
- 36 3
- 48 3
- 253 3
- 254 3
- 302 3
- 313 3
- 698 3
- 787 3
- 833 3
- 835 3
- 837 3
- 847 3
- 864 3
- 875 3
- 876 3
- 887 3
- 898 3
- 902 3
- 907 3
- 912 3
- 923 3
- 924 3
- 944 3
- 950 3
- 957 3
- 972 3
- 980 3
- 993 3
- 1029 3
- 1040 3
- 1069 3
- 1096 3
- 1154 3
- 1201 3
- 1238 3
- 1258 3
- 1278 3
- 1308 3
- 1331 3
- 1335 3
- 1343 3
- 11 2
- 20 2
- 22 2
- 43 2
- 97 2
- 190 2
- 226 2
- 230 2
- 233 2
- 246 2
- 265 2
- 270 2
- 274 2
- 285 2
- 299 2
- 303 2
- 314 2
- 319 2
- 320 2
- 328 2
- 341 2
- 347 2
- 384 2
- 487 2
- 505 2
- 654 2
- 688 2
- 722 2
- 748 2
- 790 2
- 794 2
- 795 2
- 796 2
- 800 2
- 801 2
- 825 2
- 828 2
- 829 2
- 845 2
- 851 2
- 856 2
- 858 2
- 897 2
- 916 2
- 922 2
- 934 2
- 942 2
- 955 2
- 978 2
- 995 2
- 1036 2
- 1043 2
- 1065 2
- 1305 2
- 1313 2
- 1320 2
- 1323 2
- 1327 2
- 1348 2
- 12 1
- 14 1
- 19 1
- 24 1
- 45 1
- 51 1
- 61 1
- 67 1
- 71 1
- 72 1
- 74 1
- 80 1
- 86 1
- 93 1
- 94 1
- 98 1
- 103 1
- 110 1
- 115 1
- 122 1
- 124 1
- 128 1
- 133 1
- 134 1
- 140 1
- 149 1
- 152 1
- 155 1
- 158 1
- 164 1
- 167 1
- 169 1
- 180 1
- 182 1
- 192 1
- 199 1
- 205 1
- 207 1
- 209 1
- 210 1
- 211 1
- 213 1
- 215 1
- 218 1
- 222 1
- 227 1
- 228 1
- 229 1
- 232 1
- 234 1
- 237 1
- 238 1
- 247 1
- 248 1
- 249 1
- 250 1
- 251 1
- 257 1
- 258 1
- 259 1
- 260 1
- 263 1
- 267 1
- 268 1
- 269 1
- 272 1
- 275 1
- 279 1
- 280 1
- 282 1
- 286 1
- 287 1
- 291 1
- 296 1
- 301 1
- 305 1
- 308 1
- 310 1
- 316 1
- 322 1
- 323 1
- 325 1
- 330 1
- 331 1
- 333 1
- 337 1
- 338 1
- 346 1
- 352 1
- 355 1
- 357 1
- 358 1
- 360 1
- 361 1
- 362 1
- 364 1
- 372 1
- 377 1
- 380 1
- 383 1
- 388 1
- 390 1
- 392 1
- 399 1
- 406 1
- 407 1
- 413 1
- 419 1
- 423 1
- 424 1
- 429 1
- 430 1
- 433 1
- 434 1
- 441 1
- 450 1
- 457 1
- 461 1
- 470 1
- 472 1
- 477 1
- 493 1
- 502 1
- 507 1
- 512 1
- 521 1
- 526 1
- 535 1
- 540 1
- 545 1
- 548 1
- 554 1
- 566 1
- 576 1
- 585 1
- 590 1
- 592 1
- 593 1
- 607 1
- 613 1
- 618 1
- 623 1
- 631 1
- 633 1
- 636 1
- 649 1
- 661 1
- 663 1
- 665 1
- 672 1
- 680 1
- 694 1
- 708 1
- 710 1
- 713 1
- 718 1
- 723 1
- 726 1
- 729 1
- 730 1
- 735 1
- 736 1
- 738 1
- 739 1
- 741 1
- 742 1
- 746 1
- 749 1
- 750 1
- 753 1
- 756 1
- 760 1
- 762 1
- 764 1
- 765 1
- 767 1
- 770 1
- 773 1
- 776 1
- 778 1
- 783 1
- 784 1
- 788 1
- 792 1
- 798 1
- 803 1
- 805 1
- 808 1
- 810 1
- 811 1
- 812 1
- 826 1
- 827 1
- 830 1
- 831 1
- 832 1
- 834 1
- 836 1
- 840 1
- 842 1
- 843 1
- 846 1
- 850 1
- 853 1
- 860 1
- 861 1
- 863 1
- 865 1
- 867 1
- 868 1
- 871 1
- 873 1
- 879 1
- 881 1
- 885 1
- 890 1
- 893 1
- 894 1
- 896 1
- 899 1
- 901 1
- 903 1
- 904 1
- 909 1
- 915 1
- 921 1
- 929 1
- 932 1
- 938 1
- 945 1
- 958 1
- 959 1
- 960 1
- 963 1
- 966 1
- 969 1
- 971 1
- 976 1
- 977 1
- 983 1
- 985 1
- 986 1
- 991 1
- 999 1
- 1000 1
- 1002 1
- 1007 1
- 1009 1
- 1017 1
- 1020 1
- 1025 1
- 1030 1
- 1034 1
- 1046 1
- 1052 1
- 1059 1
- 1076 1
- 1082 1
- 1086 1
- 1090 1
- 1100 1
- 1103 1
- 1106 1
- 1112 1
- 1117 1
- 1123 1
- 1132 1
- 1136 1
- 1146 1
- 1149 1
- 1158 1
- 1162 1
- 1166 1
- 1172 1
- 1176 1
- 1181 1
- 1193 1
- 1205 1
- 1212 1
- 1219 1
- 1230 1
- 1240 1
- 1247 1
- 1253 1
- 1257 1
- 1263 1
- 1265 1
- 1269 1
- 1275 1
- 1279 1
- 1280 1
- 1287 1
- 1291 1
- 1298 1
- 1300 1
- 1302 1
- 1303 1
- 1310 1
- 1329 1
- 1330 1
- 1339 1
- 1341 1
- 1344 1
- 1345 1
- 1346 1
state 2
- Minnesota 799
- North Dakota 785
county 1
- Ramsey · 1,584 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
620 | 620 | 2020-03-06 | Ramsey | Minnesota | 27123 | 1 | 0 |
706 | 706 | 2020-03-07 | Ramsey | Minnesota | 27123 | 1 | 0 |
810 | 810 | 2020-03-08 | Ramsey | Minnesota | 27123 | 1 | 0 |
934 | 934 | 2020-03-09 | Ramsey | Minnesota | 27123 | 1 | 0 |
1084 | 1084 | 2020-03-10 | Ramsey | Minnesota | 27123 | 1 | 0 |
1265 | 1265 | 2020-03-11 | Ramsey | Minnesota | 27123 | 2 | 0 |
1490 | 1490 | 2020-03-12 | Ramsey | Minnesota | 27123 | 2 | 0 |
1773 | 1773 | 2020-03-13 | Ramsey | Minnesota | 27123 | 3 | 0 |
2117 | 2117 | 2020-03-14 | Ramsey | Minnesota | 27123 | 4 | 0 |
2521 | 2521 | 2020-03-15 | Ramsey | Minnesota | 27123 | 8 | 0 |
2973 | 2973 | 2020-03-16 | Ramsey | Minnesota | 27123 | 8 | 0 |
3478 | 3478 | 2020-03-17 | Ramsey | Minnesota | 27123 | 8 | 0 |
4061 | 4061 | 2020-03-18 | Ramsey | Minnesota | 27123 | 8 | 0 |
4772 | 4772 | 2020-03-19 | Ramsey | Minnesota | 27123 | 12 | 0 |
5594 | 5594 | 2020-03-20 | Ramsey | Minnesota | 27123 | 16 | 0 |
5785 | 5785 | 2020-03-20 | Ramsey | North Dakota | 38071 | 1 | 0 |
6782 | 6782 | 2020-03-21 | Ramsey | North Dakota | 38071 | 1 | 0 |
7888 | 7888 | 2020-03-22 | Ramsey | North Dakota | 38071 | 1 | 0 |
9090 | 9090 | 2020-03-23 | Ramsey | North Dakota | 38071 | 1 | 0 |
10402 | 10402 | 2020-03-24 | Ramsey | North Dakota | 38071 | 1 | 0 |
11848 | 11848 | 2020-03-25 | Ramsey | North Dakota | 38071 | 3 | 0 |
13454 | 13454 | 2020-03-26 | Ramsey | North Dakota | 38071 | 3 | 0 |
15191 | 15191 | 2020-03-27 | Ramsey | North Dakota | 38071 | 3 | 0 |
17029 | 17029 | 2020-03-28 | Ramsey | North Dakota | 38071 | 3 | 0 |
18963 | 18963 | 2020-03-29 | Ramsey | North Dakota | 38071 | 3 | 0 |
21006 | 21006 | 2020-03-30 | Ramsey | North Dakota | 38071 | 3 | 0 |
23137 | 23137 | 2020-03-31 | Ramsey | North Dakota | 38071 | 3 | 0 |
25332 | 25332 | 2020-04-01 | Ramsey | North Dakota | 38071 | 3 | 0 |
27598 | 27598 | 2020-04-02 | Ramsey | North Dakota | 38071 | 3 | 0 |
29926 | 29926 | 2020-04-03 | Ramsey | North Dakota | 38071 | 3 | 0 |
32314 | 32314 | 2020-04-04 | Ramsey | North Dakota | 38071 | 3 | 0 |
34747 | 34747 | 2020-04-05 | Ramsey | North Dakota | 38071 | 3 | 0 |
37216 | 37216 | 2020-04-06 | Ramsey | North Dakota | 38071 | 3 | 0 |
39733 | 39733 | 2020-04-07 | Ramsey | North Dakota | 38071 | 3 | 0 |
42290 | 42290 | 2020-04-08 | Ramsey | North Dakota | 38071 | 3 | 0 |
44874 | 44874 | 2020-04-09 | Ramsey | North Dakota | 38071 | 3 | 0 |
47487 | 47487 | 2020-04-10 | Ramsey | North Dakota | 38071 | 3 | 0 |
50142 | 50142 | 2020-04-11 | Ramsey | North Dakota | 38071 | 3 | 0 |
52815 | 52815 | 2020-04-12 | Ramsey | North Dakota | 38071 | 3 | 0 |
55499 | 55499 | 2020-04-13 | Ramsey | North Dakota | 38071 | 3 | 0 |
58200 | 58200 | 2020-04-14 | Ramsey | North Dakota | 38071 | 3 | 0 |
60914 | 60914 | 2020-04-15 | Ramsey | North Dakota | 38071 | 3 | 0 |
63640 | 63640 | 2020-04-16 | Ramsey | North Dakota | 38071 | 3 | 0 |
66383 | 66383 | 2020-04-17 | Ramsey | North Dakota | 38071 | 3 | 0 |
69140 | 69140 | 2020-04-18 | Ramsey | North Dakota | 38071 | 3 | 0 |
71907 | 71907 | 2020-04-19 | Ramsey | North Dakota | 38071 | 3 | 0 |
74682 | 74682 | 2020-04-20 | Ramsey | North Dakota | 38071 | 3 | 0 |
77463 | 77463 | 2020-04-21 | Ramsey | North Dakota | 38071 | 3 | 0 |
80252 | 80252 | 2020-04-22 | Ramsey | North Dakota | 38071 | 3 | 0 |
83051 | 83051 | 2020-04-23 | Ramsey | North Dakota | 38071 | 3 | 0 |
85855 | 85855 | 2020-04-24 | Ramsey | North Dakota | 38071 | 3 | 0 |
88669 | 88669 | 2020-04-25 | Ramsey | North Dakota | 38071 | 3 | 0 |
91484 | 91484 | 2020-04-26 | Ramsey | North Dakota | 38071 | 3 | 0 |
94310 | 94310 | 2020-04-27 | Ramsey | North Dakota | 38071 | 4 | 0 |
97147 | 97147 | 2020-04-28 | Ramsey | North Dakota | 38071 | 4 | 0 |
99996 | 99996 | 2020-04-29 | Ramsey | North Dakota | 38071 | 3 | 0 |
102849 | 102849 | 2020-04-30 | Ramsey | North Dakota | 38071 | 3 | 0 |
105711 | 105711 | 2020-05-01 | Ramsey | North Dakota | 38071 | 3 | 0 |
108578 | 108578 | 2020-05-02 | Ramsey | North Dakota | 38071 | 3 | 0 |
111452 | 111452 | 2020-05-03 | Ramsey | North Dakota | 38071 | 3 | 0 |
114333 | 114333 | 2020-05-04 | Ramsey | North Dakota | 38071 | 3 | 0 |
117214 | 117214 | 2020-05-05 | Ramsey | North Dakota | 38071 | 3 | 0 |
120175 | 120175 | 2020-05-06 | Ramsey | North Dakota | 38071 | 3 | 0 |
123151 | 123151 | 2020-05-07 | Ramsey | North Dakota | 38071 | 5 | 0 |
126134 | 126134 | 2020-05-08 | Ramsey | North Dakota | 38071 | 5 | 0 |
129123 | 129123 | 2020-05-09 | Ramsey | North Dakota | 38071 | 7 | 0 |
132112 | 132112 | 2020-05-10 | Ramsey | North Dakota | 38071 | 7 | 0 |
135103 | 135103 | 2020-05-11 | Ramsey | North Dakota | 38071 | 7 | 0 |
138093 | 138093 | 2020-05-12 | Ramsey | North Dakota | 38071 | 7 | 0 |
141089 | 141089 | 2020-05-13 | Ramsey | North Dakota | 38071 | 7 | 0 |
144084 | 144084 | 2020-05-14 | Ramsey | North Dakota | 38071 | 7 | 0 |
147085 | 147085 | 2020-05-15 | Ramsey | North Dakota | 38071 | 7 | 0 |
150092 | 150092 | 2020-05-16 | Ramsey | North Dakota | 38071 | 7 | 0 |
153102 | 153102 | 2020-05-17 | Ramsey | North Dakota | 38071 | 7 | 0 |
6564 | 6564 | 2020-03-21 | Ramsey | Minnesota | 27123 | 17 | 1 |
7646 | 7646 | 2020-03-22 | Ramsey | Minnesota | 27123 | 18 | 1 |
8825 | 8825 | 2020-03-23 | Ramsey | Minnesota | 27123 | 24 | 1 |
10120 | 10120 | 2020-03-24 | Ramsey | Minnesota | 27123 | 26 | 1 |
11538 | 11538 | 2020-03-25 | Ramsey | Minnesota | 27123 | 27 | 1 |
13127 | 13127 | 2020-03-26 | Ramsey | Minnesota | 27123 | 32 | 1 |
14843 | 14843 | 2020-03-27 | Ramsey | Minnesota | 27123 | 34 | 1 |
156119 | 156119 | 2020-05-18 | Ramsey | North Dakota | 38071 | 7 | 1 |
159139 | 159139 | 2020-05-19 | Ramsey | North Dakota | 38071 | 8 | 1 |
162166 | 162166 | 2020-05-20 | Ramsey | North Dakota | 38071 | 8 | 1 |
165195 | 165195 | 2020-05-21 | Ramsey | North Dakota | 38071 | 9 | 1 |
168231 | 168231 | 2020-05-22 | Ramsey | North Dakota | 38071 | 9 | 1 |
171270 | 171270 | 2020-05-23 | Ramsey | North Dakota | 38071 | 9 | 1 |
174312 | 174312 | 2020-05-24 | Ramsey | North Dakota | 38071 | 9 | 1 |
177356 | 177356 | 2020-05-25 | Ramsey | North Dakota | 38071 | 9 | 1 |
180399 | 180399 | 2020-05-26 | Ramsey | North Dakota | 38071 | 8 | 1 |
183447 | 183447 | 2020-05-27 | Ramsey | North Dakota | 38071 | 8 | 1 |
186504 | 186504 | 2020-05-28 | Ramsey | North Dakota | 38071 | 8 | 1 |
189564 | 189564 | 2020-05-29 | Ramsey | North Dakota | 38071 | 8 | 1 |
192628 | 192628 | 2020-05-30 | Ramsey | North Dakota | 38071 | 8 | 1 |
195698 | 195698 | 2020-05-31 | Ramsey | North Dakota | 38071 | 8 | 1 |
198771 | 198771 | 2020-06-01 | Ramsey | North Dakota | 38071 | 8 | 1 |
201846 | 201846 | 2020-06-02 | Ramsey | North Dakota | 38071 | 8 | 1 |
204923 | 204923 | 2020-06-03 | Ramsey | North Dakota | 38071 | 8 | 1 |
208004 | 208004 | 2020-06-04 | Ramsey | North Dakota | 38071 | 8 | 1 |
211086 | 211086 | 2020-06-05 | Ramsey | North Dakota | 38071 | 8 | 1 |
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);