participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
10,789 rows where station_code = "HR001Z" 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 |
---|---|---|---|---|---|
5132180 | 5132180 | 20240915235334_QsU8l | HR001Z | 2024-09-19T12:15:55.343Z | 2024-09-19T12:15:55.343Z |
5132163 | 5132163 | 20240915234835_2eO9k | HR001Z | 2024-09-19T12:15:53.708Z | 2024-09-19T12:15:53.708Z |
5132074 | 5132074 | 20240915230321_3e2bT | HR001Z | 2024-09-19T12:15:48.636Z | 2024-09-19T12:15:48.636Z |
5132002 | 5132002 | 20240915223547_Z7LHw | HR001Z | 2024-09-19T12:15:42.670Z | 2024-09-19T12:15:42.670Z |
5131931 | 5131931 | 20240915221947_MjQoP | HR001Z | 2024-09-19T12:15:34.949Z | 2024-09-19T12:15:34.949Z |
5131862 | 5131862 | 20240915215812_YqC5G | HR001Z | 2024-09-19T12:15:31.949Z | 2024-09-19T12:15:31.949Z |
5131699 | 5131699 | 20240915205030_6BW4s | HR001Z | 2024-09-19T12:15:16.684Z | 2024-09-19T12:15:16.684Z |
5131697 | 5131697 | 20240915205020_MAbm6 | HR001Z | 2024-09-19T12:15:16.567Z | 2024-09-19T12:15:16.567Z |
5131568 | 5131568 | 20240915201828_qsiTj | HR001Z | 2024-09-19T12:15:09.519Z | 2024-09-19T12:15:09.519Z |
5131435 | 5131435 | 20240915195151_IznqO | HR001Z | 2024-09-19T12:15:03.412Z | 2024-09-19T12:15:03.412Z |
5131363 | 5131363 | 20240915192644_C0H3Y | HR001Z | 2024-09-19T12:14:59.101Z | 2024-09-19T12:14:59.101Z |
5125629 | 5125629 | 20240918031216_lfnZn | HR001Z | 2024-09-19T12:03:46.007Z | 2024-09-19T12:06:42.060Z |
5125511 | 5125511 | 20240918025143_kROIk | HR001Z | 2024-09-19T12:03:25.026Z | 2024-09-19T12:06:42.044Z |
5125450 | 5125450 | 20240918023920_rLolo | HR001Z | 2024-09-19T12:03:16.685Z | 2024-09-19T12:06:42.035Z |
5125410 | 5125410 | 20240918022936_bU2ol | HR001Z | 2024-09-19T12:03:10.763Z | 2024-09-19T12:06:42.028Z |
5125403 | 5125403 | 20240918022846_C3f3j | HR001Z | 2024-09-19T12:03:09.886Z | 2024-09-19T12:06:42.027Z |
5125360 | 5125360 | 20240918022038_FuBVz | HR001Z | 2024-09-19T12:03:04.578Z | 2024-09-19T12:06:42.020Z |
5125349 | 5125349 | 20240918021727_sQLgY | HR001Z | 2024-09-19T12:03:02.273Z | 2024-09-19T12:06:42.018Z |
5125343 | 5125343 | 20240918021548_xxFL1 | HR001Z | 2024-09-19T12:03:01.415Z | 2024-09-19T12:06:42.017Z |
5125332 | 5125332 | 20240918020935_6AxE6 | HR001Z | 2024-09-19T12:02:54.239Z | 2024-09-19T12:06:42.014Z |
5125325 | 5125325 | 20240918020822_sB1Qg | HR001Z | 2024-09-19T12:02:52.088Z | 2024-09-19T12:06:42.013Z |
5125310 | 5125310 | 20240918015852_2bIJU | HR001Z | 2024-09-19T12:02:44.033Z | 2024-09-19T12:06:42.009Z |
5125164 | 5125164 | 20240918004544_kru4a | HR001Z | 2024-09-19T12:02:25.617Z | 2024-09-19T12:06:41.985Z |
5125032 | 5125032 | 20240917233931_aIuVh | HR001Z | 2024-09-19T12:01:58.482Z | 2024-09-19T12:06:41.964Z |
5124979 | 5124979 | 20240917231548_fcgX3 | HR001Z | 2024-09-19T12:01:54.236Z | 2024-09-19T12:06:41.958Z |
5124911 | 5124911 | 20240917224650_HhNjG | HR001Z | 2024-09-19T12:01:47.661Z | 2024-09-19T12:06:41.951Z |
5124878 | 5124878 | 20240917223409_luDJ8 | HR001Z | 2024-09-19T12:01:43.531Z | 2024-09-19T12:06:41.946Z |
5124779 | 5124779 | 20240917220055_0xiRk | HR001Z | 2024-09-19T12:01:34.503Z | 2024-09-19T12:06:41.934Z |
5124543 | 5124543 | 20240917210122_XWSZh | HR001Z | 2024-09-19T12:01:06.309Z | 2024-09-19T12:06:41.908Z |
5110468 | 5110468 | 20240911020422_Mw5nt | HR001Z | 2024-09-17T12:18:00.736Z | 2024-09-19T12:21:40.573Z |
5080005 | 5080005 | 20240911032542_aDgvn | HR001Z | 2024-09-15T12:16:44.641Z | 2024-09-19T12:21:42.986Z |
5079649 | 5079649 | 20240911030704_hdrOb | HR001Z | 2024-09-15T12:16:32.420Z | 2024-09-19T12:21:42.546Z |
5079603 | 5079603 | 20240911030524_ApaeL | HR001Z | 2024-09-15T12:16:28.789Z | 2024-09-19T12:21:42.480Z |
5079566 | 5079566 | 20240911030309_eb6RS | HR001Z | 2024-09-15T12:16:26.250Z | 2024-09-19T12:21:42.386Z |
5079556 | 5079556 | 20240911030301_3zRz4 | HR001Z | 2024-09-15T12:16:25.999Z | 2024-09-19T12:21:42.383Z |
5079394 | 5079394 | 20240911025259_n7VOx | HR001Z | 2024-09-15T12:16:19.354Z | 2024-09-19T12:21:41.676Z |
5079392 | 5079392 | 20240911025246_bY1fA | HR001Z | 2024-09-15T12:16:19.154Z | 2024-09-19T12:21:41.571Z |
5079334 | 5079334 | 20240911024821_HPOA6 | HR001Z | 2024-09-15T12:16:15.898Z | 2024-09-19T12:21:41.453Z |
5079140 | 5079140 | 20240911023428_3eKBt | HR001Z | 2024-09-15T12:16:07.848Z | 2024-09-19T12:21:41.161Z |
5079101 | 5079101 | 20240911023251_N2Vqg | HR001Z | 2024-09-15T12:16:05.097Z | 2024-09-19T12:21:41.115Z |
5079053 | 5079053 | 20240911022956_Z7FLC | HR001Z | 2024-09-15T12:16:03.214Z | 2024-09-19T12:21:41.044Z |
5079048 | 5079048 | 20240911022945_Metal | HR001Z | 2024-09-15T12:16:02.768Z | 2024-09-19T12:21:41.033Z |
5078974 | 5078974 | 20240911022731_jCavH | HR001Z | 2024-09-15T12:16:01.208Z | 2024-09-19T12:21:40.949Z |
5078954 | 5078954 | 20240911022419_mi21Z | HR001Z | 2024-09-15T12:16:00.070Z | 2024-09-19T12:21:40.921Z |
5078913 | 5078913 | 20240911022048_mKgxw | HR001Z | 2024-09-15T12:15:55.706Z | 2024-09-19T12:21:40.816Z |
5078878 | 5078878 | 20240911021835_2aB8Y | HR001Z | 2024-09-15T12:15:54.559Z | 2024-09-19T12:21:40.783Z |
5078756 | 5078756 | 20240911021430_IaeVY | HR001Z | 2024-09-15T12:15:51.094Z | 2024-09-19T12:21:40.699Z |
5078624 | 5078624 | 20240911020639_GN4F9 | HR001Z | 2024-09-15T12:15:46.348Z | 2024-09-19T12:21:40.627Z |
5078612 | 5078612 | 20240911020603_nLvlT | HR001Z | 2024-09-15T12:15:45.024Z | 2024-09-19T12:21:40.590Z |
5078535 | 5078535 | 20240911020314_TwzkD | HR001Z | 2024-09-15T12:15:43.020Z | 2024-09-19T12:21:40.500Z |
5078517 | 5078517 | 20240911020245_pR5j3 | HR001Z | 2024-09-15T12:15:41.942Z | 2024-09-19T12:21:40.477Z |
5078380 | 5078380 | 20240911015203_cUCxF | HR001Z | 2024-09-15T12:15:37.008Z | 2024-09-19T12:21:40.328Z |
5078323 | 5078323 | 20240911015008_bO1qp | HR001Z | 2024-09-15T12:15:33.362Z | 2024-09-19T12:21:40.229Z |
5077993 | 5077993 | 20240911013415_F9Ot5 | HR001Z | 2024-09-15T12:15:16.032Z | 2024-09-19T12:21:39.891Z |
5077797 | 5077797 | 20240911011902_3uYIN | HR001Z | 2024-09-15T12:15:05.771Z | 2024-09-19T12:21:39.653Z |
5077760 | 5077760 | 20240911011615_YbjzY | HR001Z | 2024-09-15T12:15:03.615Z | 2024-09-19T12:21:39.627Z |
5077694 | 5077694 | 20240911011119_6rmos | HR001Z | 2024-09-15T12:15:00.351Z | 2024-09-19T12:21:39.520Z |
5077660 | 5077660 | 20240911010846_2SUiA | HR001Z | 2024-09-15T12:14:56.774Z | 2024-09-19T12:21:39.472Z |
5077478 | 5077478 | 20240911005749_OuKaK | HR001Z | 2024-09-15T12:14:47.965Z | 2024-09-19T12:21:39.100Z |
5077206 | 5077206 | 20240911003307_AI3gx | HR001Z | 2024-09-15T12:14:30.303Z | 2024-09-19T12:21:38.515Z |
5076421 | 5076421 | 20240910233343_x2gvB | HR001Z | 2024-09-15T12:13:33.570Z | 2024-09-19T12:21:37.166Z |
5076245 | 5076245 | 20240910231642_hOr1F | HR001Z | 2024-09-15T12:13:24.818Z | 2024-09-19T12:21:36.656Z |
5076237 | 5076237 | 20240910231620_Gw0yE | HR001Z | 2024-09-15T12:13:24.385Z | 2024-09-19T12:21:36.642Z |
5076215 | 5076215 | 20240910231505_WHrVo | HR001Z | 2024-09-15T12:13:23.225Z | 2024-09-19T12:21:36.622Z |
5076174 | 5076174 | 20240910231123_g53IU | HR001Z | 2024-09-15T12:13:21.707Z | 2024-09-19T12:21:36.574Z |
5075977 | 5075977 | 20240910230251_n4pp0 | HR001Z | 2024-09-15T12:13:14.353Z | 2024-09-19T12:21:36.308Z |
5075876 | 5075876 | 20240910225719_vYNZe | HR001Z | 2024-09-15T12:13:10.543Z | 2024-09-19T12:21:36.156Z |
5072681 | 5072681 | 20240911203646_IldpE | HR001Z | 2024-09-15T12:06:00.902Z | 2024-09-19T12:21:04.636Z |
5072551 | 5072551 | 20240911202258_Bp55I | HR001Z | 2024-09-15T12:05:37.333Z | 2024-09-19T12:21:04.413Z |
5072379 | 5072379 | 20240911200126_SIH3T | HR001Z | 2024-09-15T12:05:16.647Z | 2024-09-19T12:21:04.002Z |
5072250 | 5072250 | 20240911195128_IV8T9 | HR001Z | 2024-09-15T12:05:00.188Z | 2024-09-19T12:21:03.750Z |
5072088 | 5072088 | 20240911193245_sBdjV | HR001Z | 2024-09-15T12:04:38.108Z | 2024-09-19T12:21:03.509Z |
5070284 | 5070284 | 20240910224953_rUr2W | HR001Z | 2024-09-14T12:20:18.540Z | 2024-09-19T12:21:35.981Z |
5070031 | 5070031 | 20240910222608_i8fXc | HR001Z | 2024-09-14T12:20:12.477Z | 2024-09-19T12:21:35.625Z |
5069895 | 5069895 | 20240910221401_rAyeY | HR001Z | 2024-09-14T12:20:08.801Z | 2024-09-19T12:21:35.435Z |
5069363 | 5069363 | 20240910213555_GRt3v | HR001Z | 2024-09-14T12:19:54.794Z | 2024-09-19T12:21:34.766Z |
5069307 | 5069307 | 20240910212910_syCO0 | HR001Z | 2024-09-14T12:19:53.854Z | 2024-09-19T12:21:34.484Z |
5065110 | 5065110 | 20240910030702_K9cQM | HR001Z | 2024-09-14T12:16:26.153Z | 2024-09-18T12:15:18.409Z |
5065097 | 5065097 | 20240910030405_meAUE | HR001Z | 2024-09-14T12:16:25.148Z | 2024-09-18T12:15:18.376Z |
5065095 | 5065095 | 20240910030339_zU2Le | HR001Z | 2024-09-14T12:16:24.901Z | 2024-09-18T12:15:18.373Z |
5065056 | 5065056 | 20240910025919_NDh7N | HR001Z | 2024-09-14T12:16:21.099Z | 2024-09-18T12:15:18.267Z |
5065038 | 5065038 | 20240910025716_keOY9 | HR001Z | 2024-09-14T12:16:19.260Z | 2024-09-18T12:15:18.224Z |
5065027 | 5065027 | 20240910025528_aJHUl | HR001Z | 2024-09-14T12:16:18.594Z | 2024-09-18T12:15:18.168Z |
5064964 | 5064964 | 20240910024536_OrDMT | HR001Z | 2024-09-14T12:16:13.720Z | 2024-09-18T12:15:17.989Z |
5064961 | 5064961 | 20240910024308_G5IeA | HR001Z | 2024-09-14T12:16:13.334Z | 2024-09-18T12:15:17.981Z |
5064886 | 5064886 | 20240910022252_Mwqex | HR001Z | 2024-09-14T12:16:08.250Z | 2024-09-18T12:15:17.611Z |
5064861 | 5064861 | 20240910021820_RSU2H | HR001Z | 2024-09-14T12:16:07.124Z | 2024-09-18T12:15:17.562Z |
5064847 | 5064847 | 20240910021615_gX8ZM | HR001Z | 2024-09-14T12:16:06.061Z | 2024-09-18T12:15:17.521Z |
5064834 | 5064834 | 20240910021239_j37UR | HR001Z | 2024-09-14T12:16:05.496Z | 2024-09-18T12:15:17.493Z |
5064819 | 5064819 | 20240910020904_HBKVS | HR001Z | 2024-09-14T12:16:04.582Z | 2024-09-18T12:15:17.458Z |
5064811 | 5064811 | 20240910020817_7GQ3J | HR001Z | 2024-09-14T12:16:04.147Z | 2024-09-18T12:15:17.431Z |
5064790 | 5064790 | 20240910020523_kmvJy | HR001Z | 2024-09-14T12:16:02.481Z | 2024-09-18T12:15:17.387Z |
5064748 | 5064748 | 20240910015608_gWWiU | HR001Z | 2024-09-14T12:15:59.206Z | 2024-09-18T12:15:17.197Z |
5064729 | 5064729 | 20240910015148_LusbX | HR001Z | 2024-09-14T12:15:58.280Z | 2024-09-18T12:15:17.097Z |
5064408 | 5064408 | 20240910010007_i99tk | HR001Z | 2024-09-14T12:15:25.161Z | 2024-09-18T12:15:16.584Z |
5064384 | 5064384 | 20240910005644_9Zihi | HR001Z | 2024-09-14T12:15:20.712Z | 2024-09-18T12:15:16.411Z |
5064328 | 5064328 | 20240910004938_COVBJ | HR001Z | 2024-09-14T12:15:17.758Z | 2024-09-18T12:15:16.142Z |
5064283 | 5064283 | 20240910003829_m2f20 | HR001Z | 2024-09-14T12:15:12.741Z | 2024-09-18T12:15:16.070Z |
5064275 | 5064275 | 20240910003646_ZFFrz | HR001Z | 2024-09-14T12:15:11.692Z | 2024-09-18T12:15:16.049Z |
5064252 | 5064252 | 20240910003051_LRmj7 | HR001Z | 2024-09-14T12:15:09.460Z | 2024-09-18T12:15:15.964Z |
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);