participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
4,242 rows where station_code = "HR000Z" 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 |
---|---|---|---|---|---|
5485248 | 5485248 | 20241105043008_YsvMb | HR000Z | 2024-11-06T14:17:59.139Z | 2024-11-09T14:21:20.278Z |
5485180 | 5485180 | 20241105041632_EHOQb | HR000Z | 2024-11-06T14:17:52.136Z | 2024-11-09T14:21:19.849Z |
5485174 | 5485174 | 20241105041520_eZeVa | HR000Z | 2024-11-06T14:17:51.685Z | 2024-11-09T14:21:19.820Z |
5485124 | 5485124 | 20241105040743_hwuo5 | HR000Z | 2024-11-06T14:17:48.048Z | 2024-11-09T14:21:19.561Z |
5484983 | 5484983 | 20241105035032_3YElA | HR000Z | 2024-11-06T14:17:36.466Z | 2024-11-09T14:21:18.478Z |
5484853 | 5484853 | 20241105033444_102u5 | HR000Z | 2024-11-06T14:17:23.005Z | 2024-11-09T14:21:16.955Z |
5484756 | 5484756 | 20241105032558_k4RZK | HR000Z | 2024-11-06T14:17:13.885Z | 2024-11-09T14:21:16.239Z |
5484734 | 5484734 | 20241105032333_na32k | HR000Z | 2024-11-06T14:17:12.516Z | 2024-11-09T14:21:16.119Z |
5484521 | 5484521 | 20241105030030_1NvUt | HR000Z | 2024-11-06T14:16:59.568Z | 2024-11-09T14:21:14.840Z |
5484511 | 5484511 | 20241105025931_ClJOv | HR000Z | 2024-11-06T14:16:58.940Z | 2024-11-09T14:21:14.809Z |
5484226 | 5484226 | 20241105022206_2w3Gp | HR000Z | 2024-11-06T14:16:34.831Z | 2024-11-09T14:21:11.993Z |
5484045 | 5484045 | 20241105020502_0B5t3 | HR000Z | 2024-11-06T14:16:08.403Z | 2024-11-09T14:21:10.313Z |
5482143 | 5482143 | 20241104211250_ZV1mQ | HR000Z | 2024-11-06T14:12:28.166Z | 2024-11-09T14:20:55.749Z |
5481835 | 5481835 | 20241104195550_MHvsW | HR000Z | 2024-11-06T14:11:39.688Z | 2024-11-09T14:20:51.652Z |
5478485 | 5478485 | 20241104041704_2zhIO | HR000Z | 2024-11-05T14:18:24.959Z | 2024-11-09T14:22:28.465Z |
5478168 | 5478168 | 20241104033149_ZkblS | HR000Z | 2024-11-05T14:18:01.643Z | 2024-11-09T14:22:25.544Z |
5477887 | 5477887 | 20241104025110_UHtLP | HR000Z | 2024-11-05T14:17:34.659Z | 2024-11-09T14:22:22.695Z |
5477587 | 5477587 | 20241104021051_02RwN | HR000Z | 2024-11-05T14:17:05.808Z | 2024-11-09T14:22:19.790Z |
5477543 | 5477543 | 20241104020653_drak4 | HR000Z | 2024-11-05T14:17:02.437Z | 2024-11-09T14:22:18.806Z |
5477413 | 5477413 | 20241104014936_zyvO2 | HR000Z | 2024-11-05T14:16:51.028Z | 2024-11-09T14:22:17.462Z |
5477387 | 5477387 | 20241104014639_ySoV3 | HR000Z | 2024-11-05T14:16:49.146Z | 2024-11-09T14:22:17.200Z |
5454469 | 5454469 | 20241031042715_7cKGT | HR000Z | 2024-11-02T12:23:06.969Z | 2024-11-08T14:23:23.085Z |
5454382 | 5454382 | 20241031041332_S8vKO | HR000Z | 2024-11-02T12:23:04.288Z | 2024-11-08T14:23:22.535Z |
5454214 | 5454214 | 20241031035807_bS1fB | HR000Z | 2024-11-02T12:22:54.733Z | 2024-11-08T14:23:21.408Z |
5454001 | 5454001 | 20241031032855_bwDYj | HR000Z | 2024-11-02T12:22:47.511Z | 2024-11-08T14:23:19.954Z |
5453943 | 5453943 | 20241031032022_i6J3O | HR000Z | 2024-11-02T12:22:45.529Z | 2024-11-08T14:23:19.713Z |
5453928 | 5453928 | 20241031031805_l5Lkh | HR000Z | 2024-11-02T12:22:45.290Z | 2024-11-08T14:23:19.692Z |
5453434 | 5453434 | 20241031021147_XZfze | HR000Z | 2024-11-02T12:22:33.652Z | 2024-11-08T14:23:17.381Z |
5453429 | 5453429 | 20241031021144_IsXOL | HR000Z | 2024-11-02T12:22:33.591Z | 2024-11-08T14:23:17.378Z |
5453418 | 5453418 | 20241031021042_EA1I7 | HR000Z | 2024-11-02T12:22:33.252Z | 2024-11-08T14:23:17.314Z |
5453161 | 5453161 | 20241031014550_FdN65 | HR000Z | 2024-11-02T12:22:28.618Z | 2024-11-08T14:23:16.107Z |
5453132 | 5453132 | 20241031014415_C3IUb | HR000Z | 2024-11-02T12:22:27.564Z | 2024-11-08T14:23:16.067Z |
5444452 | 5444452 | 20241031012231_Josqy | HR000Z | 2024-11-01T12:21:18.284Z | 2024-11-08T14:23:15.637Z |
5444249 | 5444249 | 20241031010321_JzhmE | HR000Z | 2024-11-01T12:21:11.458Z | 2024-11-08T14:23:14.189Z |
5444104 | 5444104 | 20241031004826_hpAJM | HR000Z | 2024-11-01T12:21:06.130Z | 2024-11-08T14:23:13.973Z |
5443107 | 5443107 | 20241030033419_kvstv | HR000Z | 2024-11-01T12:20:17.931Z | 2024-11-07T14:26:49.566Z |
5443056 | 5443056 | 20241030032627_n4aX6 | HR000Z | 2024-11-01T12:20:16.747Z | 2024-11-07T14:26:49.320Z |
5442970 | 5442970 | 20241030030730_6q1pk | HR000Z | 2024-11-01T12:20:14.656Z | 2024-11-07T14:26:49.076Z |
5442917 | 5442917 | 20241030025548_sGVYC | HR000Z | 2024-11-01T12:20:12.661Z | 2024-11-07T14:26:48.712Z |
5442786 | 5442786 | 20241030023431_xuJTY | HR000Z | 2024-11-01T12:20:08.225Z | 2024-11-07T14:26:48.325Z |
5442626 | 5442626 | 20241030020540_IPQVi | HR000Z | 2024-11-01T12:20:03.532Z | 2024-11-07T14:26:47.217Z |
5442580 | 5442580 | 20241030015618_0BwaB | HR000Z | 2024-11-01T12:20:02.537Z | 2024-11-07T14:26:47.048Z |
5440527 | 5440527 | 20241030222418_fQUGT | HR000Z | 2024-11-01T12:15:35.085Z | 2024-11-08T14:23:09.813Z |
5439495 | 5439495 | 20241030200006_c4Uxk | HR000Z | 2024-11-01T12:13:54.239Z | 2024-11-08T14:23:03.575Z |
5343562 | 5343562 | 20241022033509_hvnLM | HR000Z | 2024-10-23T12:17:50.471Z | 2024-10-30T12:26:50.213Z |
5312594 | 5312594 | 20241015040417_rE7Bo | HR000Z | 2024-10-16T12:10:50.142Z | 2024-10-23T12:24:52.315Z |
5312305 | 5312305 | 20241015031252_Y2a2S | HR000Z | 2024-10-16T12:10:23.385Z | 2024-10-23T12:24:50.042Z |
5303930 | 5303930 | 20241013035031_x8vy0 | HR000Z | 2024-10-14T12:17:38.307Z | 2024-10-21T12:24:22.102Z |
5303684 | 5303684 | 20241013032248_Md948 | HR000Z | 2024-10-14T12:17:31.829Z | 2024-10-21T12:24:19.518Z |
5303675 | 5303675 | 20241013032209_YOgho | HR000Z | 2024-10-14T12:17:31.491Z | 2024-10-21T12:24:19.398Z |
5303663 | 5303663 | 20241013032151_s4gAs | HR000Z | 2024-10-14T12:17:31.214Z | 2024-10-21T12:24:19.266Z |
5303562 | 5303562 | 20241013031323_2jVS4 | HR000Z | 2024-10-14T12:17:28.551Z | 2024-10-21T12:24:18.650Z |
5303494 | 5303494 | 20241013030703_rkT6p | HR000Z | 2024-10-14T12:17:26.850Z | 2024-10-21T12:24:18.314Z |
5303322 | 5303322 | 20241013024950_OxF7J | HR000Z | 2024-10-14T12:17:20.803Z | 2024-10-21T12:24:17.026Z |
5303318 | 5303318 | 20241013024946_hwBht | HR000Z | 2024-10-14T12:17:20.724Z | 2024-10-21T12:24:16.869Z |
5268843 | 5268843 | 20241007035601_B3uQy | HR000Z | 2024-10-10T12:16:58.485Z | 2024-10-16T12:20:58.198Z |
5252746 | 5252746 | 20241006211840_x5TBl | HR000Z | 2024-10-08T12:12:22.373Z | 2024-10-15T12:29:03.473Z |
5252742 | 5252742 | 20241006211618_fGy9z | HR000Z | 2024-10-08T12:12:22.068Z | 2024-10-15T12:29:03.332Z |
5205360 | 5205360 | 20240930232545_fp2EZ | HR000Z | 2024-10-02T12:12:39.176Z | 2024-10-09T12:29:16.183Z |
5204972 | 5204972 | 20240930213733_2k8Wc | HR000Z | 2024-10-02T12:12:13.558Z | 2024-10-09T12:29:15.268Z |
5199321 | 5199321 | 20240929233953_ZklYg | HR000Z | 2024-10-01T12:16:05.968Z | 2024-10-07T12:21:39.691Z |
5199241 | 5199241 | 20240929231605_JHTqM | HR000Z | 2024-10-01T12:15:59.103Z | 2024-10-07T12:21:39.060Z |
5199136 | 5199136 | 20240929222648_l2481 | HR000Z | 2024-10-01T12:15:48.105Z | 2024-10-07T12:21:38.352Z |
5198727 | 5198727 | 20240929195126_5eMF7 | HR000Z | 2024-10-01T12:15:01.244Z | 2024-10-07T12:21:35.243Z |
5198498 | 5198498 | 20240929185519_2LbH3 | HR000Z | 2024-10-01T12:14:47.803Z | 2024-10-07T12:21:34.134Z |
5194800 | 5194800 | 20240930025924_06XvO | HR000Z | 2024-10-01T12:02:15.674Z | 2024-10-09T12:29:01.018Z |
5194668 | 5194668 | 20240930022024_De657 | HR000Z | 2024-10-01T12:01:40.199Z | 2024-10-09T12:29:00.605Z |
5077747 | 5077747 | 20240911011515_S5tvz | HR000Z | 2024-09-15T12:15:03.032Z | 2024-09-19T12:21:39.596Z |
5076756 | 5076756 | 20240911000722_N31vw | HR000Z | 2024-09-15T12:14:00.371Z | 2024-09-19T12:21:37.551Z |
5076492 | 5076492 | 20240910234120_FiCcG | HR000Z | 2024-09-15T12:13:38.796Z | 2024-09-19T12:21:37.302Z |
5074286 | 5074286 | 20240911222845_Gsl1U | HR000Z | 2024-09-15T12:08:17.556Z | 2024-09-20T12:21:35.717Z |
5060549 | 5060549 | 20240910203737_tOCGx | HR000Z | 2024-09-14T12:09:07.636Z | 2024-09-19T12:21:32.609Z |
5060077 | 5060077 | 20240910194747_M9x6q | HR000Z | 2024-09-14T12:08:10.279Z | 2024-09-19T12:21:31.776Z |
5052586 | 5052586 | 20240907211011_LQhKP | HR000Z | 2024-09-13T12:15:14.601Z | 2024-09-16T12:21:06.555Z |
5052559 | 5052559 | 20240907210357_PXxBe | HR000Z | 2024-09-13T12:15:13.963Z | 2024-09-16T12:21:06.271Z |
5052055 | 5052055 | 20240907193508_KORkr | HR000Z | 2024-09-13T12:14:55.234Z | 2024-09-16T12:21:03.504Z |
5052000 | 5052000 | 20240907192435_Gybl3 | HR000Z | 2024-09-13T12:14:52.817Z | 2024-09-16T12:21:02.873Z |
5032265 | 5032265 | 20240907003708_Iz3pT | HR000Z | 2024-09-12T12:07:00.427Z | 2024-09-15T12:21:25.757Z |
5032175 | 5032175 | 20240907002319_Lt6jV | HR000Z | 2024-09-12T12:06:40.698Z | 2024-09-15T12:21:25.445Z |
5032150 | 5032150 | 20240907002007_xVFt9 | HR000Z | 2024-09-12T12:06:38.467Z | 2024-09-15T12:21:25.358Z |
5031970 | 5031970 | 20240906234805_cgxU8 | HR000Z | 2024-09-12T12:06:16.110Z | 2024-09-15T12:21:24.922Z |
5031864 | 5031864 | 20240906233351_jHvGy | HR000Z | 2024-09-12T12:05:57.818Z | 2024-09-15T12:21:24.595Z |
5031762 | 5031762 | 20240906231251_fxsuq | HR000Z | 2024-09-12T12:05:45.559Z | 2024-09-15T12:21:24.235Z |
5031739 | 5031739 | 20240906230748_6qOMn | HR000Z | 2024-09-12T12:05:42.494Z | 2024-09-15T12:21:23.980Z |
4970655 | 4970655 | 20240811222751_8WASw | HR000Z | 2024-09-05T12:09:30.536Z | 2024-09-06T12:08:43.607Z |
4970536 | 4970536 | 20240811222622_4dvUf | HR000Z | 2024-09-05T12:09:28.061Z | 2024-09-06T12:08:41.621Z |
4970238 | 4970238 | 20240811222251_5xDrl | HR000Z | 2024-09-05T12:09:22.689Z | 2024-09-06T12:08:32.838Z |
4970126 | 4970126 | 20240811222121_EAuk5 | HR000Z | 2024-09-05T12:09:19.225Z | 2024-09-06T12:08:25.054Z |
4969788 | 4969788 | 20240811221639_2LaKx | HR000Z | 2024-09-05T12:09:02.235Z | 2024-09-06T12:08:06.663Z |
4969149 | 4969149 | 20240811220656_2Z2iK | HR000Z | 2024-09-05T12:08:35.787Z | 2024-09-06T12:07:42.924Z |
4968023 | 4968023 | 20240811215324_SwQf8 | HR000Z | 2024-09-05T12:07:57.161Z | 2024-09-06T12:07:19.801Z |
4967535 | 4967535 | 20240811214517_Rj8Ed | HR000Z | 2024-09-05T12:07:41.256Z | 2024-09-06T12:07:01.608Z |
4967414 | 4967414 | 20240811214409_cf93a | HR000Z | 2024-09-05T12:07:38.421Z | 2024-09-06T12:06:59.361Z |
4967239 | 4967239 | 20240811214128_lM8VV | HR000Z | 2024-09-05T12:07:34.253Z | 2024-09-06T12:06:55.973Z |
4967145 | 4967145 | 20240811213933_9mjbh | HR000Z | 2024-09-05T12:07:32.037Z | 2024-09-06T12:06:54.379Z |
4966378 | 4966378 | 20240811212907_Ka0ss | HR000Z | 2024-09-04T12:07:26.266Z | 2024-09-06T12:06:27.939Z |
4966194 | 4966194 | 20240811212517_hodS2 | HR000Z | 2024-09-04T12:07:20.355Z | 2024-09-06T12:06:16.608Z |
4965694 | 4965694 | 20240811211753_2tEvp | HR000Z | 2024-09-04T12:07:05.731Z | 2024-09-06T12:06:01.658Z |
4964978 | 4964978 | 20240811210657_EiDP2 | HR000Z | 2024-09-04T12:06:40.828Z | 2024-09-06T12:05:44.917Z |
4963932 | 4963932 | 20240811204049_R9JVO | HR000Z | 2024-09-04T12:06:01.341Z | 2024-09-06T12:05:06.162Z |
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);