participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
2,820 rows where station_code = "GR0005" 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 |
---|---|---|---|---|---|
5505111 | 5505111 | 20241108035436_43mGR | GR0005 | 2024-11-09T14:15:45.463Z | 2024-11-09T14:16:28.703Z |
5505063 | 5505063 | 20241108034717_loQkw | GR0005 | 2024-11-09T14:15:40.778Z | 2024-11-09T14:16:28.692Z |
5504985 | 5504985 | 20241108032829_YjmIo | GR0005 | 2024-11-09T14:15:31.561Z | 2024-11-09T14:16:28.672Z |
5504616 | 5504616 | 20241108022456_Pi39p | GR0005 | 2024-11-09T14:14:57.244Z | 2024-11-09T14:16:28.583Z |
5504577 | 5504577 | 20241108021812_vr73Q | GR0005 | 2024-11-09T14:14:52.470Z | 2024-11-09T14:16:28.573Z |
5504548 | 5504548 | 20241108021416_ujU2u | GR0005 | 2024-11-09T14:14:50.298Z | 2024-11-09T14:16:28.567Z |
5504500 | 5504500 | 20241108020745_Zaf8t | GR0005 | 2024-11-09T14:14:45.494Z | 2024-11-09T14:16:28.556Z |
5504105 | 5504105 | 20241108005529_0mkkg | GR0005 | 2024-11-09T14:14:04.877Z | 2024-11-09T14:16:28.450Z |
5504069 | 5504069 | 20241108004845_uHvfj | GR0005 | 2024-11-09T14:14:02.534Z | 2024-11-09T14:16:28.441Z |
5504053 | 5504053 | 20241108004534_9DlKF | GR0005 | 2024-11-09T14:14:00.793Z | 2024-11-09T14:16:28.437Z |
5503830 | 5503830 | 20241107235537_AMAKg | GR0005 | 2024-11-09T14:13:46.709Z | 2024-11-09T14:16:28.360Z |
5503629 | 5503629 | 20241107230652_E15PI | GR0005 | 2024-11-09T14:13:26.655Z | 2024-11-09T14:16:28.306Z |
5503614 | 5503614 | 20241107230307_CCRWx | GR0005 | 2024-11-09T14:13:24.368Z | 2024-11-09T14:16:28.302Z |
5503597 | 5503597 | 20241107225932_oAwq2 | GR0005 | 2024-11-09T14:13:23.099Z | 2024-11-09T14:16:28.298Z |
5503572 | 5503572 | 20241107225356_6IERn | GR0005 | 2024-11-09T14:13:18.870Z | 2024-11-09T14:16:28.292Z |
5503494 | 5503494 | 20241107223302_5CSeW | GR0005 | 2024-11-09T14:13:11.851Z | 2024-11-09T14:16:28.276Z |
5503447 | 5503447 | 20241107222234_XyCNU | GR0005 | 2024-11-09T14:13:06.142Z | 2024-11-09T14:16:28.261Z |
5503245 | 5503245 | 20241107210911_x2eHF | GR0005 | 2024-11-09T14:12:38.386Z | 2024-11-09T14:16:28.199Z |
5503235 | 5503235 | 20241107210707_ufZ9H | GR0005 | 2024-11-09T14:12:37.431Z | 2024-11-09T14:16:28.197Z |
5503161 | 5503161 | 20241107205517_xUWcz | GR0005 | 2024-11-09T14:12:29.358Z | 2024-11-09T14:16:28.181Z |
5503116 | 5503116 | 20241107204401_LNXGc | GR0005 | 2024-11-09T14:12:26.027Z | 2024-11-09T14:16:28.171Z |
5502991 | 5502991 | 20241107202544_hhBWF | GR0005 | 2024-11-09T14:12:17.469Z | 2024-11-09T14:16:28.143Z |
5502690 | 5502690 | 20241107193209_0PVen | GR0005 | 2024-11-09T14:11:58.403Z | 2024-11-09T14:16:28.078Z |
5502686 | 5502686 | 20241107193138_NU78i | GR0005 | 2024-11-09T14:11:58.354Z | 2024-11-09T14:16:28.077Z |
5502532 | 5502532 | 20241107185644_LsyMH | GR0005 | 2024-11-09T14:11:40.873Z | 2024-11-09T14:16:28.049Z |
5502201 | 5502201 | 20241107174218_4g0oL | GR0005 | 2024-11-09T14:11:03.867Z | 2024-11-09T14:16:27.983Z |
5502184 | 5502184 | 20241107173659_mfBF6 | GR0005 | 2024-11-09T14:11:02.982Z | 2024-11-09T14:16:27.977Z |
5497418 | 5497418 | 20241107033640_3NiCv | GR0005 | 2024-11-08T14:13:44.563Z | 2024-11-09T14:18:42.475Z |
5497396 | 5497396 | 20241107033309_ghSQ1 | GR0005 | 2024-11-08T14:13:41.041Z | 2024-11-09T14:18:42.070Z |
5497392 | 5497392 | 20241107033222_JfP2P | GR0005 | 2024-11-08T14:13:41.037Z | 2024-11-09T14:18:42.068Z |
5497245 | 5497245 | 20241107030503_vqyaG | GR0005 | 2024-11-08T14:13:26.229Z | 2024-11-09T14:18:38.880Z |
5497168 | 5497168 | 20241107025211_86x2B | GR0005 | 2024-11-08T14:13:18.465Z | 2024-11-09T14:18:36.406Z |
5496884 | 5496884 | 20241107020557_opcnN | GR0005 | 2024-11-08T14:12:57.118Z | 2024-11-09T14:18:32.290Z |
5496788 | 5496788 | 20241107013858_qTtKy | GR0005 | 2024-11-08T14:12:51.767Z | 2024-11-09T14:18:30.315Z |
5496696 | 5496696 | 20241107011742_E5xRs | GR0005 | 2024-11-08T14:12:43.608Z | 2024-11-09T14:18:27.702Z |
5496367 | 5496367 | 20241107000530_nosDm | GR0005 | 2024-11-08T14:12:02.570Z | 2024-11-09T14:18:21.054Z |
5496155 | 5496155 | 20241106231024_hdprz | GR0005 | 2024-11-08T14:11:39.460Z | 2024-11-09T14:18:17.116Z |
5496148 | 5496148 | 20241106230716_TcrYR | GR0005 | 2024-11-08T14:11:39.117Z | 2024-11-09T14:18:17.069Z |
5496116 | 5496116 | 20241106225844_Z7EYv | GR0005 | 2024-11-08T14:11:35.945Z | 2024-11-09T14:18:16.378Z |
5496097 | 5496097 | 20241106225440_lQFza | GR0005 | 2024-11-08T14:11:33.732Z | 2024-11-09T14:18:16.145Z |
5496089 | 5496089 | 20241106225353_dHqDa | GR0005 | 2024-11-08T14:11:31.872Z | 2024-11-09T14:18:16.073Z |
5496055 | 5496055 | 20241106224855_zBybV | GR0005 | 2024-11-08T14:11:28.413Z | 2024-11-09T14:18:15.166Z |
5496053 | 5496053 | 20241106224810_2UXmX | GR0005 | 2024-11-08T14:11:27.928Z | 2024-11-09T14:18:15.117Z |
5495950 | 5495950 | 20241106222011_UuJDI | GR0005 | 2024-11-08T14:11:12.475Z | 2024-11-09T14:18:12.648Z |
5495900 | 5495900 | 20241106220037_nEKrc | GR0005 | 2024-11-08T14:11:05.341Z | 2024-11-09T14:18:10.939Z |
5495849 | 5495849 | 20241106214523_T8pkR | GR0005 | 2024-11-08T14:11:01.067Z | 2024-11-09T14:18:10.276Z |
5495814 | 5495814 | 20241106213922_tvHK9 | GR0005 | 2024-11-08T14:10:55.730Z | 2024-11-09T14:18:09.522Z |
5495806 | 5495806 | 20241106213748_ek9Yu | GR0005 | 2024-11-08T14:10:55.156Z | 2024-11-09T14:18:09.461Z |
5495711 | 5495711 | 20241106210910_W9d0k | GR0005 | 2024-11-08T14:10:40.727Z | 2024-11-09T14:18:05.274Z |
5495701 | 5495701 | 20241106210610_6Wo07 | GR0005 | 2024-11-08T14:10:39.078Z | 2024-11-09T14:18:05.003Z |
5495629 | 5495629 | 20241106204311_05pWK | GR0005 | 2024-11-08T14:10:30.645Z | 2024-11-09T14:18:01.710Z |
5495533 | 5495533 | 20241106201119_gCWOr | GR0005 | 2024-11-08T14:10:21.386Z | 2024-11-09T14:17:56.843Z |
5495237 | 5495237 | 20241106190401_jnXlv | GR0005 | 2024-11-08T14:09:43.356Z | 2024-11-09T14:17:46.550Z |
5494866 | 5494866 | 20241106174123_vpAJC | GR0005 | 2024-11-08T14:08:43.818Z | 2024-11-09T14:17:33.100Z |
5490874 | 5490874 | 20241106010149_7B92h | GR0005 | 2024-11-07T14:15:01.846Z | 2024-11-09T14:20:00.790Z |
5489465 | 5489465 | 20241105190109_YGkXb | GR0005 | 2024-11-07T14:12:04.297Z | 2024-11-09T14:19:43.020Z |
5489318 | 5489318 | 20241105183504_LmIkU | GR0005 | 2024-11-07T14:11:52.812Z | 2024-11-09T14:19:41.318Z |
5488797 | 5488797 | 20241105165542_FRVn1 | GR0005 | 2024-11-07T14:10:37.890Z | 2024-11-09T14:19:33.417Z |
5483707 | 5483707 | 20241105012221_7igxW | GR0005 | 2024-11-06T14:15:37.232Z | 2024-11-09T14:21:06.909Z |
5483672 | 5483672 | 20241105011734_QlL2l | GR0005 | 2024-11-06T14:15:34.905Z | 2024-11-09T14:21:06.669Z |
5483518 | 5483518 | 20241105005206_UI2rW | GR0005 | 2024-11-06T14:15:26.312Z | 2024-11-09T14:21:05.764Z |
5483271 | 5483271 | 20241105002116_Bgu0U | GR0005 | 2024-11-06T14:14:51.438Z | 2024-11-09T14:21:04.530Z |
5482987 | 5482987 | 20241104234425_vf94g | GR0005 | 2024-11-06T14:14:33.409Z | 2024-11-09T14:21:02.806Z |
5482821 | 5482821 | 20241104231757_fFdGW | GR0005 | 2024-11-06T14:14:06.571Z | 2024-11-09T14:21:01.746Z |
5482688 | 5482688 | 20241104230252_YzOWb | GR0005 | 2024-11-06T14:13:37.390Z | 2024-11-09T14:21:01.022Z |
5482667 | 5482667 | 20241104225828_quMJf | GR0005 | 2024-11-06T14:13:33.553Z | 2024-11-09T14:21:00.852Z |
5482647 | 5482647 | 20241104225402_jl53P | GR0005 | 2024-11-06T14:13:30.365Z | 2024-11-09T14:21:00.744Z |
5482599 | 5482599 | 20241104224737_B2YVU | GR0005 | 2024-11-06T14:13:25.793Z | 2024-11-09T14:21:00.480Z |
5482591 | 5482591 | 20241104224634_3wGQB | GR0005 | 2024-11-06T14:13:25.211Z | 2024-11-09T14:21:00.454Z |
5482524 | 5482524 | 20241104223441_LJ51b | GR0005 | 2024-11-06T14:13:18.269Z | 2024-11-09T14:21:00.021Z |
5482514 | 5482514 | 20241104223410_bIEYy | GR0005 | 2024-11-06T14:13:17.514Z | 2024-11-09T14:20:59.966Z |
5482186 | 5482186 | 20241104212310_Y4gHS | GR0005 | 2024-11-06T14:12:34.057Z | 2024-11-09T14:20:56.358Z |
5481793 | 5481793 | 20241104194509_Jnfdk | GR0005 | 2024-11-06T14:11:35.468Z | 2024-11-09T14:20:51.054Z |
5481765 | 5481765 | 20241104193747_isttd | GR0005 | 2024-11-06T14:11:32.737Z | 2024-11-09T14:20:50.538Z |
5481742 | 5481742 | 20241104192748_VhyAx | GR0005 | 2024-11-06T14:11:29.518Z | 2024-11-09T14:20:50.201Z |
5481714 | 5481714 | 20241104192120_1fygb | GR0005 | 2024-11-06T14:11:26.787Z | 2024-11-09T14:20:50.001Z |
5481601 | 5481601 | 20241104184445_WTabi | GR0005 | 2024-11-06T14:10:55.000Z | 2024-11-09T14:20:47.862Z |
5481521 | 5481521 | 20241104180726_QAXAl | GR0005 | 2024-11-06T14:10:43.486Z | 2024-11-09T14:20:46.867Z |
5469084 | 5469084 | 20241103023242_hx8L0 | GR0005 | 2024-11-04T14:15:35.014Z | 2024-11-09T14:23:00.877Z |
5468467 | 5468467 | 20241103004150_hV3us | GR0005 | 2024-11-04T14:14:10.020Z | 2024-11-09T14:22:58.464Z |
5468383 | 5468383 | 20241103002348_GDomm | GR0005 | 2024-11-04T14:14:02.123Z | 2024-11-09T14:22:58.135Z |
5468305 | 5468305 | 20241103000850_e39EM | GR0005 | 2024-11-04T14:13:55.671Z | 2024-11-09T14:22:57.957Z |
5468122 | 5468122 | 20241102233443_RodWD | GR0005 | 2024-11-04T14:13:18.977Z | 2024-11-09T14:22:57.159Z |
5468113 | 5468113 | 20241102233158_iVTNA | GR0005 | 2024-11-04T14:13:18.063Z | 2024-11-09T14:22:57.124Z |
5468013 | 5468013 | 20241102231428_OR9cP | GR0005 | 2024-11-04T14:13:07.445Z | 2024-11-09T14:22:56.502Z |
5467852 | 5467852 | 20241102224648_3dw9O | GR0005 | 2024-11-04T14:12:41.114Z | 2024-11-09T14:22:55.790Z |
5467789 | 5467789 | 20241102223702_sxsvt | GR0005 | 2024-11-04T14:12:31.566Z | 2024-11-09T14:22:55.647Z |
5467723 | 5467723 | 20241102222416_J3iOm | GR0005 | 2024-11-04T14:12:24.293Z | 2024-11-09T14:22:55.468Z |
5467647 | 5467647 | 20241102220942_H32Do | GR0005 | 2024-11-04T14:12:17.406Z | 2024-11-09T14:22:55.232Z |
5467585 | 5467585 | 20241102220144_DEbvi | GR0005 | 2024-11-04T14:12:07.163Z | 2024-11-09T14:22:55.104Z |
5467568 | 5467568 | 20241102215353_edpM0 | GR0005 | 2024-11-04T14:12:04.582Z | 2024-11-09T14:22:55.075Z |
5467477 | 5467477 | 20241102212613_uHAYG | GR0005 | 2024-11-04T14:11:37.964Z | 2024-11-09T14:22:54.707Z |
5467391 | 5467391 | 20241102205804_1JGjX | GR0005 | 2024-11-04T14:11:25.402Z | 2024-11-09T14:22:54.265Z |
5466843 | 5466843 | 20241102190905_aiPZl | GR0005 | 2024-11-04T14:10:00.132Z | 2024-11-09T14:22:52.523Z |
5466726 | 5466726 | 20241102184145_eAUZZ | GR0005 | 2024-11-04T14:09:38.159Z | 2024-11-09T14:22:52.095Z |
5466701 | 5466701 | 20241102183635_HVSPJ | GR0005 | 2024-11-04T14:09:35.364Z | 2024-11-09T14:22:51.976Z |
5466393 | 5466393 | 20241102173119_rIaOS | GR0005 | 2024-11-04T14:08:46.487Z | 2024-11-09T14:22:50.483Z |
5466286 | 5466286 | 20241102170259_v9dhs | GR0005 | 2024-11-04T14:08:32.884Z | 2024-11-09T14:22:50.063Z |
5463468 | 5463468 | 20241102034144_r2klI | GR0005 | 2024-11-03T14:18:48.566Z | 2024-11-09T14:23:41.251Z |
5462865 | 5462865 | 20241102014701_3qrQC | GR0005 | 2024-11-03T14:18:08.204Z | 2024-11-09T14:23:36.521Z |
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);