ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 40013 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195264 | 1195264 | 2021-04-06 | Bryan | Oklahoma | 40013 | 6039 | 59 |
1192016 | 1192016 | 2021-04-05 | Bryan | Oklahoma | 40013 | 6039 | 59 |
1188767 | 1188767 | 2021-04-04 | Bryan | Oklahoma | 40013 | 6039 | 59 |
1185520 | 1185520 | 2021-04-03 | Bryan | Oklahoma | 40013 | 6039 | 59 |
1182273 | 1182273 | 2021-04-02 | Bryan | Oklahoma | 40013 | 6039 | 59 |
1179026 | 1179026 | 2021-04-01 | Bryan | Oklahoma | 40013 | 6039 | 59 |
1175779 | 1175779 | 2021-03-31 | Bryan | Oklahoma | 40013 | 6039 | 59 |
1172532 | 1172532 | 2021-03-30 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1169285 | 1169285 | 2021-03-29 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1166037 | 1166037 | 2021-03-28 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1162789 | 1162789 | 2021-03-27 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1159540 | 1159540 | 2021-03-26 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1156293 | 1156293 | 2021-03-25 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1153046 | 1153046 | 2021-03-24 | Bryan | Oklahoma | 40013 | 6020 | 58 |
1149799 | 1149799 | 2021-03-23 | Bryan | Oklahoma | 40013 | 6006 | 57 |
1146552 | 1146552 | 2021-03-22 | Bryan | Oklahoma | 40013 | 6006 | 57 |
1143305 | 1143305 | 2021-03-21 | Bryan | Oklahoma | 40013 | 6006 | 57 |
1140058 | 1140058 | 2021-03-20 | Bryan | Oklahoma | 40013 | 6006 | 57 |
1136812 | 1136812 | 2021-03-19 | Bryan | Oklahoma | 40013 | 6006 | 57 |
1133566 | 1133566 | 2021-03-18 | Bryan | Oklahoma | 40013 | 6006 | 57 |
1130318 | 1130318 | 2021-03-17 | Bryan | Oklahoma | 40013 | 6006 | 57 |
1127071 | 1127071 | 2021-03-16 | Bryan | Oklahoma | 40013 | 6006 | 57 |
1123825 | 1123825 | 2021-03-15 | Bryan | Oklahoma | 40013 | 6006 | 57 |
1120579 | 1120579 | 2021-03-14 | Bryan | Oklahoma | 40013 | 6005 | 57 |
1117332 | 1117332 | 2021-03-13 | Bryan | Oklahoma | 40013 | 6002 | 57 |
1114085 | 1114085 | 2021-03-12 | Bryan | Oklahoma | 40013 | 5997 | 57 |
1110839 | 1110839 | 2021-03-11 | Bryan | Oklahoma | 40013 | 5996 | 57 |
1107593 | 1107593 | 2021-03-10 | Bryan | Oklahoma | 40013 | 5991 | 57 |
1104347 | 1104347 | 2021-03-09 | Bryan | Oklahoma | 40013 | 5987 | 57 |
1101101 | 1101101 | 2021-03-08 | Bryan | Oklahoma | 40013 | 5985 | 56 |
1097855 | 1097855 | 2021-03-07 | Bryan | Oklahoma | 40013 | 5983 | 56 |
1094607 | 1094607 | 2021-03-06 | Bryan | Oklahoma | 40013 | 5957 | 56 |
1091361 | 1091361 | 2021-03-05 | Bryan | Oklahoma | 40013 | 5933 | 56 |
1088115 | 1088115 | 2021-03-04 | Bryan | Oklahoma | 40013 | 5929 | 56 |
1084870 | 1084870 | 2021-03-03 | Bryan | Oklahoma | 40013 | 5917 | 56 |
1081624 | 1081624 | 2021-03-02 | Bryan | Oklahoma | 40013 | 5913 | 56 |
1078378 | 1078378 | 2021-03-01 | Bryan | Oklahoma | 40013 | 5911 | 55 |
1075133 | 1075133 | 2021-02-28 | Bryan | Oklahoma | 40013 | 5907 | 55 |
1071887 | 1071887 | 2021-02-27 | Bryan | Oklahoma | 40013 | 5886 | 55 |
1068641 | 1068641 | 2021-02-26 | Bryan | Oklahoma | 40013 | 5866 | 55 |
1065396 | 1065396 | 2021-02-25 | Bryan | Oklahoma | 40013 | 5857 | 55 |
1062152 | 1062152 | 2021-02-24 | Bryan | Oklahoma | 40013 | 5838 | 55 |
1058906 | 1058906 | 2021-02-23 | Bryan | Oklahoma | 40013 | 5814 | 54 |
1055660 | 1055660 | 2021-02-22 | Bryan | Oklahoma | 40013 | 5810 | 54 |
1052414 | 1052414 | 2021-02-21 | Bryan | Oklahoma | 40013 | 5802 | 54 |
1049167 | 1049167 | 2021-02-20 | Bryan | Oklahoma | 40013 | 5779 | 52 |
1045920 | 1045920 | 2021-02-19 | Bryan | Oklahoma | 40013 | 5769 | 52 |
1042675 | 1042675 | 2021-02-18 | Bryan | Oklahoma | 40013 | 5763 | 52 |
1039430 | 1039430 | 2021-02-17 | Bryan | Oklahoma | 40013 | 5746 | 52 |
1036185 | 1036185 | 2021-02-16 | Bryan | Oklahoma | 40013 | 5731 | 52 |
1032940 | 1032940 | 2021-02-15 | Bryan | Oklahoma | 40013 | 5712 | 52 |
1029694 | 1029694 | 2021-02-14 | Bryan | Oklahoma | 40013 | 5707 | 52 |
1026447 | 1026447 | 2021-02-13 | Bryan | Oklahoma | 40013 | 5686 | 52 |
1023202 | 1023202 | 2021-02-12 | Bryan | Oklahoma | 40013 | 5658 | 51 |
1019957 | 1019957 | 2021-02-11 | Bryan | Oklahoma | 40013 | 5634 | 51 |
1016712 | 1016712 | 2021-02-10 | Bryan | Oklahoma | 40013 | 5611 | 51 |
1013467 | 1013467 | 2021-02-09 | Bryan | Oklahoma | 40013 | 5552 | 51 |
1010222 | 1010222 | 2021-02-08 | Bryan | Oklahoma | 40013 | 5544 | 51 |
1006976 | 1006976 | 2021-02-07 | Bryan | Oklahoma | 40013 | 5511 | 51 |
1003730 | 1003730 | 2021-02-06 | Bryan | Oklahoma | 40013 | 5476 | 51 |
1000484 | 1000484 | 2021-02-05 | Bryan | Oklahoma | 40013 | 5427 | 50 |
997238 | 997238 | 2021-02-04 | Bryan | Oklahoma | 40013 | 5392 | 50 |
993992 | 993992 | 2021-02-03 | Bryan | Oklahoma | 40013 | 5372 | 50 |
990746 | 990746 | 2021-02-02 | Bryan | Oklahoma | 40013 | 5340 | 45 |
987500 | 987500 | 2021-02-01 | Bryan | Oklahoma | 40013 | 5330 | 45 |
984253 | 984253 | 2021-01-31 | Bryan | Oklahoma | 40013 | 5315 | 45 |
981006 | 981006 | 2021-01-30 | Bryan | Oklahoma | 40013 | 5269 | 45 |
977760 | 977760 | 2021-01-29 | Bryan | Oklahoma | 40013 | 5246 | 45 |
974515 | 974515 | 2021-01-28 | Bryan | Oklahoma | 40013 | 5219 | 45 |
971270 | 971270 | 2021-01-27 | Bryan | Oklahoma | 40013 | 5177 | 44 |
968025 | 968025 | 2021-01-26 | Bryan | Oklahoma | 40013 | 5142 | 44 |
964781 | 964781 | 2021-01-25 | Bryan | Oklahoma | 40013 | 5131 | 44 |
961536 | 961536 | 2021-01-24 | Bryan | Oklahoma | 40013 | 5099 | 44 |
958291 | 958291 | 2021-01-23 | Bryan | Oklahoma | 40013 | 5051 | 44 |
955045 | 955045 | 2021-01-22 | Bryan | Oklahoma | 40013 | 5011 | 44 |
951800 | 951800 | 2021-01-21 | Bryan | Oklahoma | 40013 | 4945 | 44 |
948555 | 948555 | 2021-01-20 | Bryan | Oklahoma | 40013 | 4907 | 44 |
945309 | 945309 | 2021-01-19 | Bryan | Oklahoma | 40013 | 4858 | 44 |
942062 | 942062 | 2021-01-18 | Bryan | Oklahoma | 40013 | 4847 | 44 |
938817 | 938817 | 2021-01-17 | Bryan | Oklahoma | 40013 | 4837 | 44 |
935572 | 935572 | 2021-01-16 | Bryan | Oklahoma | 40013 | 4803 | 44 |
932327 | 932327 | 2021-01-15 | Bryan | Oklahoma | 40013 | 4758 | 44 |
929082 | 929082 | 2021-01-14 | Bryan | Oklahoma | 40013 | 4705 | 44 |
925837 | 925837 | 2021-01-13 | Bryan | Oklahoma | 40013 | 4642 | 41 |
922591 | 922591 | 2021-01-12 | Bryan | Oklahoma | 40013 | 4578 | 40 |
919346 | 919346 | 2021-01-11 | Bryan | Oklahoma | 40013 | 4564 | 40 |
916101 | 916101 | 2021-01-10 | Bryan | Oklahoma | 40013 | 4541 | 40 |
912856 | 912856 | 2021-01-09 | Bryan | Oklahoma | 40013 | 4487 | 39 |
909611 | 909611 | 2021-01-08 | Bryan | Oklahoma | 40013 | 4420 | 39 |
906366 | 906366 | 2021-01-07 | Bryan | Oklahoma | 40013 | 4367 | 39 |
903120 | 903120 | 2021-01-06 | Bryan | Oklahoma | 40013 | 4293 | 39 |
899875 | 899875 | 2021-01-05 | Bryan | Oklahoma | 40013 | 4184 | 33 |
896630 | 896630 | 2021-01-04 | Bryan | Oklahoma | 40013 | 4161 | 33 |
893384 | 893384 | 2021-01-03 | Bryan | Oklahoma | 40013 | 4153 | 33 |
890138 | 890138 | 2021-01-02 | Bryan | Oklahoma | 40013 | 4055 | 33 |
886891 | 886891 | 2021-01-01 | Bryan | Oklahoma | 40013 | 3980 | 32 |
883646 | 883646 | 2020-12-31 | Bryan | Oklahoma | 40013 | 3980 | 32 |
880401 | 880401 | 2020-12-30 | Bryan | Oklahoma | 40013 | 3904 | 32 |
877156 | 877156 | 2020-12-29 | Bryan | Oklahoma | 40013 | 3823 | 32 |
873911 | 873911 | 2020-12-28 | Bryan | Oklahoma | 40013 | 3816 | 32 |
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);