participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
17,595 rows where station_code = "US0007" sorted by created_at descending
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date), updated_at (date)
Link | rowid | meteor_unique_trajectory_identifier | station_code | created_at ▲ | updated_at |
---|---|---|---|---|---|
5129924 | 5129924 | 20240917062538_4qrTN | US0007 | 2024-09-19T12:12:17.536Z | 2024-09-19T12:12:17.536Z |
5129429 | 5129429 | 20240917035553_2YPVQ | US0007 | 2024-09-19T12:11:36.897Z | 2024-09-19T12:11:36.897Z |
5126453 | 5126453 | 20240918115710_BInW5 | US0007 | 2024-09-19T12:05:59.429Z | 2024-09-19T12:06:42.203Z |
5126445 | 5126445 | 20240918115353_WHZhA | US0007 | 2024-09-19T12:05:58.641Z | 2024-09-19T12:06:42.202Z |
5126440 | 5126440 | 20240918115340_FU7CL | US0007 | 2024-09-19T12:05:58.285Z | 2024-09-19T12:06:42.201Z |
5126380 | 5126380 | 20240918112029_OF8GO | US0007 | 2024-09-19T12:05:52.164Z | 2024-09-19T12:06:42.192Z |
5126363 | 5126363 | 20240918111259_AGXTo | US0007 | 2024-09-19T12:05:50.047Z | 2024-09-19T12:06:42.188Z |
5126272 | 5126272 | 20240918102731_NocFG | US0007 | 2024-09-19T12:05:29.944Z | 2024-09-19T12:06:42.172Z |
5125941 | 5125941 | 20240918050554_EqkkA | US0007 | 2024-09-19T12:04:36.425Z | 2024-09-19T12:06:42.112Z |
5125691 | 5125691 | 20240918032137_P62dZ | US0007 | 2024-09-19T12:03:53.718Z | 2024-09-19T12:06:42.070Z |
5123741 | 5123741 | 20240914111812_8xZm1 | US0007 | 2024-09-18T12:11:55.451Z | 2024-09-19T12:20:14.368Z |
5123590 | 5123590 | 20240914104115_bN2yh | US0007 | 2024-09-18T12:11:51.803Z | 2024-09-19T12:20:13.098Z |
5123447 | 5123447 | 20240914101020_FJvBg | US0007 | 2024-09-18T12:11:49.282Z | 2024-09-19T12:20:11.124Z |
5123333 | 5123333 | 20240914094730_0J3LU | US0007 | 2024-09-18T12:11:45.362Z | 2024-09-19T12:20:10.431Z |
5123271 | 5123271 | 20240914092925_TTtDD | US0007 | 2024-09-18T12:11:43.821Z | 2024-09-19T12:20:09.266Z |
5123050 | 5123050 | 20240914084429_q2K5e | US0007 | 2024-09-18T12:11:39.094Z | 2024-09-19T12:20:07.491Z |
5123038 | 5123038 | 20240914084406_Nmo2j | US0007 | 2024-09-18T12:11:38.837Z | 2024-09-19T12:20:07.447Z |
5122937 | 5122937 | 20240914082502_zvycd | US0007 | 2024-09-18T12:11:34.448Z | 2024-09-19T12:20:06.753Z |
5122700 | 5122700 | 20240914073259_0wz30 | US0007 | 2024-09-18T12:11:28.799Z | 2024-09-19T12:20:05.789Z |
5122489 | 5122489 | 20240914064800_tcOnS | US0007 | 2024-09-18T12:11:20.774Z | 2024-09-19T12:20:04.557Z |
5117858 | 5117858 | 20240915072918_kYiuv | US0007 | 2024-09-18T12:08:03.783Z | 2024-09-19T12:19:18.610Z |
5117739 | 5117739 | 20240915064135_nqT7M | US0007 | 2024-09-18T12:07:54.774Z | 2024-09-19T12:19:17.420Z |
5117674 | 5117674 | 20240915061826_NJGg1 | US0007 | 2024-09-18T12:07:51.824Z | 2024-09-19T12:19:16.906Z |
5109959 | 5109959 | 20240913114144_7kVix | US0007 | 2024-09-17T12:14:51.827Z | 2024-09-19T12:20:55.500Z |
5109818 | 5109818 | 20240913111416_AQTZX | US0007 | 2024-09-17T12:14:46.903Z | 2024-09-19T12:20:54.858Z |
5109605 | 5109605 | 20240913103558_MvYdy | US0007 | 2024-09-17T12:14:42.035Z | 2024-09-19T12:20:53.815Z |
5108991 | 5108991 | 20240913082004_1rPj7 | US0007 | 2024-09-17T12:14:24.169Z | 2024-09-19T12:20:51.379Z |
5108972 | 5108972 | 20240913081543_c3OQ8 | US0007 | 2024-09-17T12:14:23.145Z | 2024-09-19T12:20:51.339Z |
5108949 | 5108949 | 20240913081257_oijI3 | US0007 | 2024-09-17T12:14:21.534Z | 2024-09-19T12:20:51.250Z |
5108454 | 5108454 | 20240913054716_iibdF | US0007 | 2024-09-17T12:13:45.313Z | 2024-09-19T12:20:48.881Z |
5096713 | 5096713 | 20240912113320_He30f | US0007 | 2024-09-16T12:16:32.460Z | 2024-09-19T12:21:23.497Z |
5095918 | 5095918 | 20240912092733_ialUi | US0007 | 2024-09-16T12:16:02.078Z | 2024-09-19T12:21:20.661Z |
5095876 | 5095876 | 20240912092012_YaZiK | US0007 | 2024-09-16T12:16:01.068Z | 2024-09-19T12:21:20.579Z |
5094968 | 5094968 | 20240912045732_S5vy8 | US0007 | 2024-09-16T12:15:04.950Z | 2024-09-19T12:21:16.781Z |
5082763 | 5082763 | 20240911105621_0h3ur | US0007 | 2024-09-15T12:18:25.099Z | 2024-09-19T12:21:48.651Z |
5082724 | 5082724 | 20240911105011_FkRlC | US0007 | 2024-09-15T12:18:23.971Z | 2024-09-19T12:21:48.489Z |
5082691 | 5082691 | 20240911104436_iWjtT | US0007 | 2024-09-15T12:18:22.627Z | 2024-09-19T12:21:48.342Z |
5082173 | 5082173 | 20240911093224_Es54l | US0007 | 2024-09-15T12:18:05.823Z | 2024-09-19T12:21:47.405Z |
5082156 | 5082156 | 20240911092942_fZw0k | US0007 | 2024-09-15T12:18:05.364Z | 2024-09-19T12:21:47.251Z |
5081901 | 5081901 | 20240911090138_X3R9R | US0007 | 2024-09-15T12:17:53.645Z | 2024-09-19T12:21:46.711Z |
5081696 | 5081696 | 20240911082802_Bu1lG | US0007 | 2024-09-15T12:17:42.419Z | 2024-09-19T12:21:46.109Z |
5081464 | 5081464 | 20240911074643_32N6K | US0007 | 2024-09-15T12:17:34.129Z | 2024-09-19T12:21:45.442Z |
5080977 | 5080977 | 20240911054939_CXIFY | US0007 | 2024-09-15T12:17:19.221Z | 2024-09-19T12:21:44.177Z |
5068430 | 5068430 | 20240910113131_s26xp | US0007 | 2024-09-14T12:19:15.179Z | 2024-09-18T12:15:26.126Z |
5067868 | 5067868 | 20240910102301_77C4D | US0007 | 2024-09-14T12:19:01.421Z | 2024-09-18T12:15:24.997Z |
5066437 | 5066437 | 20240910072934_j7PDs | US0007 | 2024-09-14T12:17:56.901Z | 2024-09-18T12:15:21.951Z |
5065970 | 5065970 | 20240910061303_iEqDZ | US0007 | 2024-09-14T12:17:32.484Z | 2024-09-18T12:15:20.938Z |
5065682 | 5065682 | 20240910050846_jLOq2 | US0007 | 2024-09-14T12:17:18.824Z | 2024-09-18T12:15:20.151Z |
5056953 | 5056953 | 20240908114528_j8MWy | US0007 | 2024-09-13T12:17:41.855Z | 2024-09-16T12:21:27.960Z |
5056570 | 5056570 | 20240908104516_jbCPc | US0007 | 2024-09-13T12:17:35.482Z | 2024-09-16T12:21:25.939Z |
5056177 | 5056177 | 20240908095125_eGTI7 | US0007 | 2024-09-13T12:17:28.253Z | 2024-09-16T12:21:23.692Z |
5056133 | 5056133 | 20240908094516_3vn8C | US0007 | 2024-09-13T12:17:27.867Z | 2024-09-16T12:21:23.478Z |
5055635 | 5055635 | 20240908083047_2BzxX | US0007 | 2024-09-13T12:17:19.159Z | 2024-09-16T12:21:21.320Z |
5055478 | 5055478 | 20240908080949_frdZe | US0007 | 2024-09-13T12:17:15.219Z | 2024-09-16T12:21:19.941Z |
5055424 | 5055424 | 20240908080137_bh72r | US0007 | 2024-09-13T12:17:12.430Z | 2024-09-16T12:21:19.619Z |
5055330 | 5055330 | 20240908074947_RakiR | US0007 | 2024-09-13T12:17:09.997Z | 2024-09-16T12:21:18.821Z |
5055260 | 5055260 | 20240908073549_k252K | US0007 | 2024-09-13T12:17:08.616Z | 2024-09-16T12:21:18.555Z |
5049776 | 5049776 | 20240909113833_lUJ8X | US0007 | 2024-09-13T12:12:25.953Z | 2024-09-17T12:19:11.449Z |
5049713 | 5049713 | 20240909113033_X3RzA | US0007 | 2024-09-13T12:12:23.656Z | 2024-09-17T12:19:11.269Z |
5049493 | 5049493 | 20240909110410_pxoap | US0007 | 2024-09-13T12:12:15.279Z | 2024-09-17T12:19:10.696Z |
5047306 | 5047306 | 20240909032519_mnJ22 | US0007 | 2024-09-13T12:08:46.531Z | 2024-09-17T12:19:01.982Z |
5043396 | 5043396 | 20240907105657_aQ3C7 | US0007 | 2024-09-12T12:17:32.765Z | 2024-09-15T12:21:41.580Z |
5041904 | 5041904 | 20240906092051_3K7UA | US0007 | 2024-09-12T12:16:52.096Z | 2024-09-14T12:23:15.322Z |
5041723 | 5041723 | 20240906085657_M6VOH | US0007 | 2024-09-12T12:16:47.817Z | 2024-09-14T12:23:14.424Z |
5041018 | 5041018 | 20240906065941_XZ8lJ | US0007 | 2024-09-12T12:16:31.982Z | 2024-09-14T12:23:11.340Z |
5035776 | 5035776 | 20240907102040_5B83s | US0007 | 2024-09-12T12:12:28.217Z | 2024-09-15T12:21:41.224Z |
5035384 | 5035384 | 20240907092418_tzhxo | US0007 | 2024-09-12T12:12:02.714Z | 2024-09-15T12:21:39.482Z |
5034680 | 5034680 | 20240907074012_hhxUT | US0007 | 2024-09-12T12:11:11.258Z | 2024-09-15T12:21:35.524Z |
5034453 | 5034453 | 20240907065916_A0sU9 | US0007 | 2024-09-12T12:10:57.180Z | 2024-09-15T12:21:34.733Z |
5034155 | 5034155 | 20240907054514_37l5L | US0007 | 2024-09-12T12:10:41.232Z | 2024-09-15T12:21:32.953Z |
5033863 | 5033863 | 20240907041034_oC27N | US0007 | 2024-09-12T12:10:03.927Z | 2024-09-15T12:21:32.045Z |
5029440 | 5029440 | 20240905094000_aqYxU | US0007 | 2024-09-11T12:16:38.251Z | 2024-09-13T12:20:06.315Z |
5028694 | 5028694 | 20240905104014_ZRuBq | US0007 | 2024-09-11T12:15:43.057Z | 2024-09-14T12:22:48.962Z |
5027626 | 5027626 | 20240905080212_wWFVn | US0007 | 2024-09-11T12:14:20.878Z | 2024-09-13T12:20:04.070Z |
5027620 | 5027620 | 20240905080157_MwfTW | US0007 | 2024-09-11T12:14:20.651Z | 2024-09-13T12:20:04.064Z |
5026688 | 5026688 | 20240905044501_wVy2q | US0007 | 2024-09-11T12:12:55.579Z | 2024-09-13T12:19:59.331Z |
5026597 | 5026597 | 20240905042517_jxQFk | US0007 | 2024-09-11T12:12:47.845Z | 2024-09-13T12:19:59.012Z |
5022869 | 5022869 | 20240905094000_MITKm | US0007 | 2024-09-10T12:16:31.368Z | 2024-09-11T12:15:16.588Z |
5022067 | 5022067 | 20240905080212_teGDQ | US0007 | 2024-09-10T12:16:03.682Z | 2024-09-10T12:16:55.488Z |
5022061 | 5022061 | 20240905080157_s31cI | US0007 | 2024-09-10T12:16:03.559Z | 2024-09-10T12:16:55.487Z |
5021148 | 5021148 | 20240905044501_o7NhF | US0007 | 2024-09-10T12:15:17.858Z | 2024-09-10T12:16:55.319Z |
5021057 | 5021057 | 20240905042517_peTi6 | US0007 | 2024-09-10T12:15:12.941Z | 2024-09-10T12:16:55.302Z |
5013504 | 5013504 | 20240905104014_DZ3aN | US0007 | 2024-09-10T12:00:51.435Z | 2024-09-14T12:22:48.961Z |
5012945 | 5012945 | 20240903075946_yb9XB | US0007 | 2024-09-09T12:18:21.861Z | 2024-09-11T12:21:19.388Z |
5012832 | 5012832 | 20240903074144_23qvo | US0007 | 2024-09-09T12:18:18.011Z | 2024-09-11T12:21:18.987Z |
5012813 | 5012813 | 20240903073638_qzUdQ | US0007 | 2024-09-09T12:18:17.275Z | 2024-09-11T12:21:18.899Z |
5012788 | 5012788 | 20240903073302_pYSQ8 | US0007 | 2024-09-09T12:18:16.554Z | 2024-09-11T12:21:18.797Z |
5012689 | 5012689 | 20240903071805_lEvta | US0007 | 2024-09-09T12:18:04.367Z | 2024-09-11T12:21:18.555Z |
5012564 | 5012564 | 20240903070130_EJM90 | US0007 | 2024-09-09T12:17:57.820Z | 2024-09-11T12:21:18.206Z |
5012544 | 5012544 | 20240903065955_PqoPA | US0007 | 2024-09-09T12:17:56.935Z | 2024-09-11T12:21:18.132Z |
5012246 | 5012246 | 20240904090255_DA33G | US0007 | 2024-09-09T12:10:28.317Z | 2024-09-12T12:19:35.557Z |
5012204 | 5012204 | 20240904085754_DJn6a | US0007 | 2024-09-09T12:10:26.347Z | 2024-09-12T12:19:35.439Z |
5011814 | 5011814 | 20240904075911_6ExC1 | US0007 | 2024-09-09T12:10:03.051Z | 2024-09-12T12:19:33.596Z |
5011715 | 5011715 | 20240904074341_z3Pf3 | US0007 | 2024-09-09T12:09:59.076Z | 2024-09-12T12:19:33.327Z |
5004109 | 5004109 | 20240903104348_yfYSu | US0007 | 2024-09-09T12:02:22.488Z | 2024-09-12T12:19:00.813Z |
5003985 | 5003985 | 20240903102040_YpRe0 | US0007 | 2024-09-09T12:02:15.692Z | 2024-09-12T12:19:00.281Z |
5003841 | 5003841 | 20240903100440_jw2Vl | US0007 | 2024-09-09T12:02:07.743Z | 2024-09-12T12:18:59.516Z |
5003650 | 5003650 | 20240903092856_suEln | US0007 | 2024-09-09T12:01:56.120Z | 2024-09-12T12:18:58.344Z |
5003365 | 5003365 | 20240903084147_1H7He | US0007 | 2024-09-09T12:01:39.290Z | 2024-09-12T12:18:56.130Z |
5003140 | 5003140 | 20240904111730_Lr6M7 | US0007 | 2024-09-09T12:01:23.923Z | 2024-09-13T12:19:43.461Z |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE participating_station ( meteor_unique_trajectory_identifier text NOT NULL, station_code text NOT NULL, created_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), updated_at datetime NOT NULL DEFAULT ( strftime( '%Y-%m-%dT%H:%M:%fZ', 'now', 'utc' ) ), FOREIGN KEY (meteor_unique_trajectory_identifier) REFERENCES meteor (unique_trajectory_identifier), FOREIGN KEY (station_code) REFERENCES station (code), UNIQUE (meteor_unique_trajectory_identifier, station_code) ON CONFLICT IGNORE ); CREATE INDEX participating_station_station_code_covering_index ON participating_station (station_code, meteor_unique_trajectory_identifier); CREATE INDEX participating_station_created_at_index ON participating_station (created_at); CREATE INDEX participating_station_updated_at_index ON participating_station (updated_at);