participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
9,030 rows where station_code = "US001R" 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 |
---|---|---|---|---|---|
5096491 | 5096491 | 20240912110106_LvI25 | US001R | 2024-09-16T12:16:24.949Z | 2024-09-19T12:21:22.406Z |
5096424 | 5096424 | 20240912104920_7r03D | US001R | 2024-09-16T12:16:23.294Z | 2024-09-19T12:21:22.293Z |
5096041 | 5096041 | 20240912094740_tml32 | US001R | 2024-09-16T12:16:06.171Z | 2024-09-19T12:21:21.094Z |
5095748 | 5095748 | 20240912085504_CgBQc | US001R | 2024-09-16T12:15:56.131Z | 2024-09-19T12:21:20.025Z |
5095686 | 5095686 | 20240912084623_dj7tF | US001R | 2024-09-16T12:15:53.100Z | 2024-09-19T12:21:19.753Z |
5049477 | 5049477 | 20240909110010_H2WoJ | US001R | 2024-09-13T12:12:14.633Z | 2024-09-17T12:19:10.581Z |
5040409 | 5040409 | 20240906040313_BUrom | US001R | 2024-09-12T12:16:09.209Z | 2024-09-14T12:23:09.075Z |
5034482 | 5034482 | 20240907070337_hq2yw | US001R | 2024-09-12T12:10:58.304Z | 2024-09-15T12:21:34.815Z |
5033726 | 5033726 | 20240907033750_mrel3 | US001R | 2024-09-12T12:09:53.159Z | 2024-09-15T12:21:31.617Z |
5004203 | 5004203 | 20240903105659_Nmlyt | US001R | 2024-09-09T12:02:27.211Z | 2024-09-12T12:19:01.164Z |
5003395 | 5003395 | 20240903084321_jQsD4 | US001R | 2024-09-09T12:01:41.348Z | 2024-09-12T12:18:56.386Z |
5002864 | 5002864 | 20240904105044_Otfs2 | US001R | 2024-09-09T12:01:07.065Z | 2024-09-13T12:19:42.289Z |
4992172 | 4992172 | 20240901060902_OQm1U | US001R | 2024-09-07T12:12:59.942Z | 2024-09-09T12:27:53.207Z |
4985043 | 4985043 | 20240901112406_oDRUf | US001R | 2024-09-07T12:02:46.464Z | 2024-09-10T12:19:06.834Z |
4984919 | 4984919 | 20240901110828_7eOun | US001R | 2024-09-07T12:02:35.570Z | 2024-09-10T12:19:06.619Z |
4984846 | 4984846 | 20240901110015_WIM5p | US001R | 2024-09-07T12:02:31.357Z | 2024-09-10T12:19:06.460Z |
4984174 | 4984174 | 20240901091732_aanLW | US001R | 2024-09-07T12:01:29.634Z | 2024-09-10T12:19:04.686Z |
4983935 | 4983935 | 20240901083023_q5gig | US001R | 2024-09-07T12:01:04.629Z | 2024-09-10T12:19:03.912Z |
4956769 | 4956769 | 20240811074620_LIoI1 | US001R | 2024-09-03T12:20:38.309Z | 2024-09-06T12:30:46.887Z |
4956298 | 4956298 | 20240811070413_2pe3n | US001R | 2024-09-03T12:20:12.682Z | 2024-09-06T12:30:24.511Z |
4955324 | 4955324 | 20240811043047_HPVMh | US001R | 2024-09-03T12:19:08.825Z | 2024-09-06T12:29:33.666Z |
4955125 | 4955125 | 20240811034336_Vt8h0 | US001R | 2024-09-03T12:18:46.292Z | 2024-09-06T12:29:19.998Z |
4931680 | 4931680 | 20240810105751_06Ix7 | US001R | 2024-08-31T12:24:49.374Z | 2024-09-02T12:31:07.208Z |
4931423 | 4931423 | 20240810102820_eUfk1 | US001R | 2024-08-31T12:24:36.458Z | 2024-09-02T12:30:54.006Z |
4931399 | 4931399 | 20240810102528_pTUNk | US001R | 2024-08-31T12:24:34.557Z | 2024-09-02T12:30:52.114Z |
4930447 | 4930447 | 20240810081346_FGMrr | US001R | 2024-08-31T12:23:31.198Z | 2024-09-02T12:30:13.282Z |
4930298 | 4930298 | 20240810075434_WiFms | US001R | 2024-08-31T12:23:17.222Z | 2024-09-02T12:30:07.224Z |
4929857 | 4929857 | 20240810064009_l99t8 | US001R | 2024-08-31T12:22:49.410Z | 2024-09-02T12:29:48.768Z |
4929799 | 4929799 | 20240810062234_lullS | US001R | 2024-08-31T12:22:41.122Z | 2024-09-02T12:29:46.983Z |
4929704 | 4929704 | 20240810054640_MhzRq | US001R | 2024-08-31T12:22:34.054Z | 2024-09-02T12:29:43.041Z |
4929497 | 4929497 | 20240810043316_I82lL | US001R | 2024-08-31T12:22:20.735Z | 2024-09-02T12:29:35.994Z |
4929375 | 4929375 | 20240810035314_ZGq5K | US001R | 2024-08-31T12:22:09.946Z | 2024-09-02T12:29:32.846Z |
4895216 | 4895216 | 20240807113355_57FWy | US001R | 2024-08-28T12:13:12.266Z | 2024-08-28T12:13:12.266Z |
4895190 | 4895190 | 20240807112937_hG8Za | US001R | 2024-08-28T12:13:10.516Z | 2024-08-28T12:13:10.516Z |
4895044 | 4895044 | 20240807111333_AtP7U | US001R | 2024-08-28T12:12:57.288Z | 2024-08-28T12:12:57.288Z |
4894805 | 4894805 | 20240807104335_ezG8h | US001R | 2024-08-28T12:12:44.404Z | 2024-08-28T12:12:44.404Z |
4894646 | 4894646 | 20240807102606_400p2 | US001R | 2024-08-28T12:12:37.515Z | 2024-08-28T12:12:37.515Z |
4892990 | 4892990 | 20240809075527_46C6v | US001R | 2024-08-28T12:10:54.373Z | 2024-08-30T12:22:41.908Z |
4892648 | 4892648 | 20240809045842_0EOVO | US001R | 2024-08-28T12:10:27.496Z | 2024-08-30T12:22:23.449Z |
4869056 | 4869056 | 20240806073220_ax0I7 | US001R | 2024-08-18T12:24:43.122Z | 2024-08-19T12:29:10.736Z |
4868532 | 4868532 | 20240806064505_tkO5J | US001R | 2024-08-18T12:24:13.695Z | 2024-08-19T12:28:47.622Z |
4868353 | 4868353 | 20240806062947_ijSgP | US001R | 2024-08-18T12:24:08.539Z | 2024-08-19T12:28:44.623Z |
4868268 | 4868268 | 20240806061703_ehXxe | US001R | 2024-08-18T12:24:03.690Z | 2024-08-19T12:28:42.930Z |
4868232 | 4868232 | 20240806061208_bB56S | US001R | 2024-08-18T12:24:03.095Z | 2024-08-19T12:28:42.417Z |
4868198 | 4868198 | 20240806060427_2Vco3 | US001R | 2024-08-18T12:24:02.302Z | 2024-08-19T12:28:40.450Z |
4868191 | 4868191 | 20240806060011_bG4aT | US001R | 2024-08-18T12:24:02.081Z | 2024-08-19T12:28:39.840Z |
4868163 | 4868163 | 20240806055349_34IUy | US001R | 2024-08-18T12:24:01.080Z | 2024-08-19T12:28:37.771Z |
4868148 | 4868148 | 20240806054833_bxJVJ | US001R | 2024-08-18T12:24:00.482Z | 2024-08-19T12:28:36.672Z |
4868117 | 4868117 | 20240806054400_CiFhD | US001R | 2024-08-18T12:23:59.385Z | 2024-08-19T12:28:34.065Z |
4868090 | 4868090 | 20240806053654_avCfg | US001R | 2024-08-18T12:23:58.735Z | 2024-08-19T12:28:33.702Z |
4868060 | 4868060 | 20240806052917_YnHbY | US001R | 2024-08-18T12:23:57.928Z | 2024-08-19T12:28:33.184Z |
4868045 | 4868045 | 20240806052550_3Tf72 | US001R | 2024-08-18T12:23:57.556Z | 2024-08-19T12:28:32.867Z |
4868037 | 4868037 | 20240806052350_IMDow | US001R | 2024-08-18T12:23:57.309Z | 2024-08-19T12:28:32.713Z |
4868014 | 4868014 | 20240806051919_p40JK | US001R | 2024-08-18T12:23:56.558Z | 2024-08-19T12:28:32.293Z |
4867962 | 4867962 | 20240806045456_DU22E | US001R | 2024-08-18T12:23:54.968Z | 2024-08-19T12:28:31.361Z |
4861739 | 4861739 | 20240806115124_U4uXq | US001R | 2024-08-18T12:03:53.193Z | 2024-08-27T12:03:46.224Z |
4860924 | 4860924 | 20240806111007_bxCoo | US001R | 2024-08-18T12:03:13.750Z | 2024-08-27T12:03:12.222Z |
4860106 | 4860106 | 20240806101829_yE9ug | US001R | 2024-08-18T12:02:29.986Z | 2024-08-27T12:02:30.302Z |
4859877 | 4859877 | 20240806100740_uckxy | US001R | 2024-08-18T12:02:18.190Z | 2024-08-27T12:02:20.435Z |
4858400 | 4858400 | 20240806082312_XAr8K | US001R | 2024-08-18T12:00:49.858Z | 2024-08-27T12:00:57.521Z |
4858193 | 4858193 | 20240806080451_t9D4b | US001R | 2024-08-18T12:00:34.434Z | 2024-08-27T12:00:42.649Z |
4857898 | 4857898 | 20240806034257_WRjYW | US001R | 2024-08-17T12:23:14.599Z | 2024-08-19T12:28:25.891Z |
4857890 | 4857890 | 20240806033744_fPJpl | US001R | 2024-08-17T12:23:13.970Z | 2024-08-19T12:28:25.586Z |
4838143 | 4838143 | 20240805083047_YxNnd | US001R | 2024-08-16T12:01:52.990Z | 2024-08-19T12:15:35.172Z |
4818444 | 4818444 | 20240804092539_29Ctx | US001R | 2024-08-14T12:02:48.827Z | 2024-08-17T12:24:38.955Z |
4817894 | 4817894 | 20240804080119_H73JX | US001R | 2024-08-14T12:01:29.448Z | 2024-08-17T12:23:59.208Z |
4817760 | 4817760 | 20240804073958_ZSnRe | US001R | 2024-08-14T12:01:08.060Z | 2024-08-17T12:23:45.297Z |
4808230 | 4808230 | 20240803105314_3c4mC | US001R | 2024-08-13T12:05:03.494Z | 2024-08-15T12:18:58.762Z |
4808125 | 4808125 | 20240803104551_Spf3j | US001R | 2024-08-13T12:04:53.651Z | 2024-08-15T12:18:55.149Z |
4808116 | 4808116 | 20240803104457_d2MG2 | US001R | 2024-08-13T12:04:51.933Z | 2024-08-15T12:18:54.383Z |
4798032 | 4798032 | 20240803075810_CCfb8 | US001R | 2024-08-12T12:02:31.897Z | 2024-08-15T12:17:33.263Z |
4797937 | 4797937 | 20240803074414_Dvv81 | US001R | 2024-08-12T12:02:03.952Z | 2024-08-15T12:17:25.802Z |
4797541 | 4797541 | 20240803063214_CStEr | US001R | 2024-08-12T12:00:55.553Z | 2024-08-15T12:17:13.626Z |
4797478 | 4797478 | 20240803055551_2O0Ks | US001R | 2024-08-12T12:00:39.879Z | 2024-08-15T12:17:11.297Z |
4797452 | 4797452 | 20240803054148_IAcgj | US001R | 2024-08-12T12:00:34.697Z | 2024-08-15T12:17:10.454Z |
4797383 | 4797383 | 20240803051645_mWBO1 | US001R | 2024-08-12T12:00:23.636Z | 2024-08-15T12:17:08.195Z |
4774297 | 4774297 | 20240801112723_dUI9X | US001R | 2024-08-07T12:07:17.805Z | 2024-08-11T12:12:19.281Z |
4772234 | 4772234 | 20240801062935_Jukms | US001R | 2024-08-07T12:02:57.561Z | 2024-08-11T12:11:20.095Z |
4772104 | 4772104 | 20240801054436_mnCYG | US001R | 2024-08-07T12:02:30.068Z | 2024-08-11T12:11:14.774Z |
4765902 | 4765902 | 20240731113007_FBerX | US001R | 2024-08-06T12:07:52.552Z | 2024-08-10T12:19:13.097Z |
4765900 | 4765900 | 20240731112957_o3x2T | US001R | 2024-08-06T12:07:52.507Z | 2024-08-10T12:19:13.083Z |
4765894 | 4765894 | 20240731112712_xANZG | US001R | 2024-08-06T12:07:52.115Z | 2024-08-10T12:19:12.935Z |
4765791 | 4765791 | 20240731111442_to3ID | US001R | 2024-08-06T12:07:43.933Z | 2024-08-10T12:19:11.569Z |
4764302 | 4764302 | 20240731083147_JIYb8 | US001R | 2024-08-06T12:05:52.525Z | 2024-08-10T12:18:43.397Z |
4764116 | 4764116 | 20240731075803_3pAEX | US001R | 2024-08-06T12:05:41.031Z | 2024-08-10T12:18:39.490Z |
4763680 | 4763680 | 20240731063751_Ns9gm | US001R | 2024-08-06T12:04:57.380Z | 2024-08-10T12:18:24.296Z |
4763583 | 4763583 | 20240731062251_PhQo9 | US001R | 2024-08-06T12:04:45.873Z | 2024-08-10T12:18:22.426Z |
4763515 | 4763515 | 20240731061033_s0BOA | US001R | 2024-08-06T12:04:41.773Z | 2024-08-10T12:18:20.836Z |
4763463 | 4763463 | 20240731055212_q9LhI | US001R | 2024-08-06T12:04:35.651Z | 2024-08-10T12:18:19.180Z |
4763419 | 4763419 | 20240731053718_GaEED | US001R | 2024-08-06T12:04:32.633Z | 2024-08-10T12:18:18.332Z |
4763381 | 4763381 | 20240731053022_UID91 | US001R | 2024-08-06T12:04:29.898Z | 2024-08-10T12:18:16.403Z |
4763218 | 4763218 | 20240731042352_1DDF7 | US001R | 2024-08-06T12:04:03.409Z | 2024-08-10T12:18:10.009Z |
4763186 | 4763186 | 20240731041558_3dmEJ | US001R | 2024-08-06T12:03:56.817Z | 2024-08-10T12:18:09.325Z |
4752114 | 4752114 | 20240730091407_Z9Ehk | US001R | 2024-08-05T12:04:46.498Z | 2024-08-08T12:19:41.088Z |
4751983 | 4751983 | 20240730084502_ZTvQ0 | US001R | 2024-08-05T12:04:30.269Z | 2024-08-08T12:19:34.429Z |
4751874 | 4751874 | 20240730082457_a7424 | US001R | 2024-08-05T12:04:20.797Z | 2024-08-08T12:19:31.411Z |
4751728 | 4751728 | 20240730075631_BRGJV | US001R | 2024-08-05T12:03:54.441Z | 2024-08-08T12:19:25.177Z |
4746879 | 4746879 | 20240730065837_2a4fK | US001R | 2024-08-04T12:09:35.032Z | 2024-08-08T12:19:09.208Z |
4746858 | 4746858 | 20240730065234_GiNFL | US001R | 2024-08-04T12:09:34.092Z | 2024-08-08T12:19:08.595Z |
4746758 | 4746758 | 20240730062843_FXZr6 | US001R | 2024-08-04T12:09:28.500Z | 2024-08-08T12:19:04.663Z |
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);