participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
7,338 rows where station_code = "HR000Q" 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 |
---|---|---|---|---|---|
5132177 | 5132177 | 20240915235239_jdR9t | HR000Q | 2024-09-19T12:15:54.960Z | 2024-09-19T12:15:54.960Z |
5131934 | 5131934 | 20240915222005_ZJygh | HR000Q | 2024-09-19T12:15:35.102Z | 2024-09-19T12:15:35.102Z |
5131830 | 5131830 | 20240915212559_5OpQM | HR000Q | 2024-09-19T12:15:26.606Z | 2024-09-19T12:15:26.606Z |
5131703 | 5131703 | 20240915205236_y83l9 | HR000Q | 2024-09-19T12:15:16.912Z | 2024-09-19T12:15:16.912Z |
5131427 | 5131427 | 20240915194703_pUhE1 | HR000Q | 2024-09-19T12:15:02.871Z | 2024-09-19T12:15:02.871Z |
5131407 | 5131407 | 20240915193853_BY2qd | HR000Q | 2024-09-19T12:15:01.672Z | 2024-09-19T12:15:01.672Z |
5125220 | 5125220 | 20240918011959_0dtSD | HR000Q | 2024-09-19T12:02:31.660Z | 2024-09-19T12:06:41.993Z |
5125047 | 5125047 | 20240917235003_G2eIJ | HR000Q | 2024-09-19T12:02:01.811Z | 2024-09-19T12:06:41.967Z |
5124964 | 5124964 | 20240917231341_5oGEh | HR000Q | 2024-09-19T12:01:52.491Z | 2024-09-19T12:06:41.957Z |
5124903 | 5124903 | 20240917224502_WhIKc | HR000Q | 2024-09-19T12:01:46.460Z | 2024-09-19T12:06:41.949Z |
5124876 | 5124876 | 20240917223409_luDJ8 | HR000Q | 2024-09-19T12:01:43.531Z | 2024-09-19T12:06:41.946Z |
5124842 | 5124842 | 20240917221707_s93JD | HR000Q | 2024-09-19T12:01:40.220Z | 2024-09-19T12:06:41.942Z |
5124811 | 5124811 | 20240917220635_4U23z | HR000Q | 2024-09-19T12:01:36.593Z | 2024-09-19T12:06:41.937Z |
5124291 | 5124291 | 20240917191807_qOpZi | HR000Q | 2024-09-19T12:00:29.500Z | 2024-09-19T12:06:41.873Z |
5080107 | 5080107 | 20240911033209_g8j2M | HR000Q | 2024-09-15T12:16:50.106Z | 2024-09-19T12:21:43.092Z |
5079247 | 5079247 | 20240911024351_VzMvL | HR000Q | 2024-09-15T12:16:12.588Z | 2024-09-19T12:21:41.290Z |
5072307 | 5072307 | 20240911195549_YgRlu | HR000Q | 2024-09-15T12:05:07.861Z | 2024-09-19T12:21:03.823Z |
5070157 | 5070157 | 20240910223542_3B3ff | HR000Q | 2024-09-14T12:20:15.489Z | 2024-09-19T12:21:35.803Z |
5064846 | 5064846 | 20240910021615_gX8ZM | HR000Q | 2024-09-14T12:16:06.046Z | 2024-09-18T12:15:17.521Z |
5054468 | 5054468 | 20240908025522_SHPL4 | HR000Q | 2024-09-13T12:16:42.728Z | 2024-09-16T12:21:15.655Z |
5040264 | 5040264 | 20240906032439_ImV6X | HR000Q | 2024-09-12T12:16:04.561Z | 2024-09-14T12:23:08.497Z |
5040099 | 5040099 | 20240906025833_YN5Um | HR000Q | 2024-09-12T12:15:58.312Z | 2024-09-14T12:23:07.508Z |
5039988 | 5039988 | 20240906024157_Pzb8i | HR000Q | 2024-09-12T12:15:53.881Z | 2024-09-14T12:23:06.433Z |
5033284 | 5033284 | 20240907024358_8s8PO | HR000Q | 2024-09-12T12:09:04.821Z | 2024-09-15T12:21:29.502Z |
5033166 | 5033166 | 20240907023214_M043l | HR000Q | 2024-09-12T12:08:54.070Z | 2024-09-15T12:21:29.116Z |
5032564 | 5032564 | 20240907011536_3ogHk | HR000Q | 2024-09-12T12:07:40.520Z | 2024-09-15T12:21:26.787Z |
5031760 | 5031760 | 20240906231244_xLC5Q | HR000Q | 2024-09-12T12:05:45.319Z | 2024-09-15T12:21:24.233Z |
5031571 | 5031571 | 20240906223359_4W6as | HR000Q | 2024-09-12T12:05:12.052Z | 2024-09-15T12:21:23.130Z |
5031366 | 5031366 | 20240906213416_4QRg1 | HR000Q | 2024-09-12T12:04:37.700Z | 2024-09-15T12:21:22.101Z |
5031209 | 5031209 | 20240906205416_8P3Oo | HR000Q | 2024-09-12T12:04:18.620Z | 2024-09-15T12:21:21.735Z |
5030833 | 5030833 | 20240906190028_RqV4t | HR000Q | 2024-09-12T12:03:11.731Z | 2024-09-15T12:21:19.989Z |
5026121 | 5026121 | 20240905022036_MHzxZ | HR000Q | 2024-09-11T12:11:56.901Z | 2024-09-13T12:19:56.896Z |
5025740 | 5025740 | 20240905010515_It3G9 | HR000Q | 2024-09-11T12:10:54.883Z | 2024-09-13T12:19:55.334Z |
5025730 | 5025730 | 20240905010154_STX71 | HR000Q | 2024-09-11T12:10:53.880Z | 2024-09-13T12:19:55.291Z |
5025655 | 5025655 | 20240905005045_PmWiN | HR000Q | 2024-09-11T12:10:43.375Z | 2024-09-13T12:19:55.011Z |
5020561 | 5020561 | 20240905022036_XTuOR | HR000Q | 2024-09-10T12:14:43.192Z | 2024-09-10T12:16:55.180Z |
5020157 | 5020157 | 20240905010515_2KGuB | HR000Q | 2024-09-10T12:14:00.859Z | 2024-09-10T12:16:55.084Z |
5020074 | 5020074 | 20240905005045_K3gLn | HR000Q | 2024-09-10T12:13:53.793Z | 2024-09-10T12:16:55.063Z |
5019897 | 5019897 | 20240905001415_8ZJ6H | HR000Q | 2024-09-10T12:13:41.462Z | 2024-09-13T12:19:54.363Z |
5019391 | 5019391 | 20240904224217_g8BNp | HR000Q | 2024-09-10T12:12:41.910Z | 2024-09-13T12:19:51.686Z |
5018779 | 5018779 | 20240904202210_yto5b | HR000Q | 2024-09-10T12:11:32.827Z | 2024-09-13T12:19:48.947Z |
5018690 | 5018690 | 20240904193604_AUhgl | HR000Q | 2024-09-10T12:11:16.646Z | 2024-09-13T12:19:48.532Z |
5018530 | 5018530 | 20240904183653_JIr6M | HR000Q | 2024-09-10T12:10:48.511Z | 2024-09-13T12:19:48.055Z |
5010662 | 5010662 | 20240904033122_p5hGS | HR000Q | 2024-09-09T12:08:56.335Z | 2024-09-12T12:19:28.518Z |
5010219 | 5010219 | 20240904024424_ISELj | HR000Q | 2024-09-09T12:08:28.680Z | 2024-09-12T12:19:26.447Z |
5009444 | 5009444 | 20240904012530_wn8D3 | HR000Q | 2024-09-09T12:07:45.170Z | 2024-09-12T12:19:22.839Z |
5009056 | 5009056 | 20240904005020_z94Mj | HR000Q | 2024-09-09T12:07:22.828Z | 2024-09-12T12:19:21.278Z |
5008635 | 5008635 | 20240904000432_oHljI | HR000Q | 2024-09-09T12:06:56.483Z | 2024-09-12T12:19:18.487Z |
5007990 | 5007990 | 20240903225003_PAa3T | HR000Q | 2024-09-09T12:06:18.579Z | 2024-09-12T12:19:15.763Z |
5007762 | 5007762 | 20240903221617_NEzH4 | HR000Q | 2024-09-09T12:06:06.420Z | 2024-09-12T12:19:14.750Z |
5007741 | 5007741 | 20240903220946_Y4qX9 | HR000Q | 2024-09-09T12:06:05.211Z | 2024-09-12T12:19:14.708Z |
5007480 | 5007480 | 20240903212027_LbgCe | HR000Q | 2024-09-09T12:05:48.371Z | 2024-09-12T12:19:13.367Z |
5007168 | 5007168 | 20240903201647_133Eo | HR000Q | 2024-09-09T12:05:30.298Z | 2024-09-12T12:19:11.862Z |
5007108 | 5007108 | 20240903195844_wJ6M8 | HR000Q | 2024-09-09T12:05:26.621Z | 2024-09-12T12:19:11.384Z |
5006902 | 5006902 | 20240903192555_o7Pjb | HR000Q | 2024-09-09T12:05:12.098Z | 2024-09-12T12:19:10.834Z |
5006832 | 5006832 | 20240903190748_RVBZ9 | HR000Q | 2024-09-09T12:05:07.475Z | 2024-09-12T12:19:10.275Z |
5001093 | 5001093 | 20240902033120_FeWXn | HR000Q | 2024-09-08T12:16:09.734Z | 2024-09-10T12:19:31.683Z |
5001043 | 5001043 | 20240902032038_GtE32 | HR000Q | 2024-09-08T12:16:07.151Z | 2024-09-10T12:19:31.320Z |
5000206 | 5000206 | 20240902014439_aVRhG | HR000Q | 2024-09-08T12:15:15.657Z | 2024-09-10T12:19:25.922Z |
4999806 | 4999806 | 20240902005907_cS81f | HR000Q | 2024-09-08T12:14:45.412Z | 2024-09-10T12:19:22.522Z |
4998429 | 4998429 | 20240903030131_HtedP | HR000Q | 2024-09-08T12:07:37.671Z | 2024-09-11T12:21:12.687Z |
4997499 | 4997499 | 20240903003044_tBQW7 | HR000Q | 2024-09-08T12:06:22.444Z | 2024-09-11T12:21:05.049Z |
4997168 | 4997168 | 20240902231632_4oPZ0 | HR000Q | 2024-09-08T12:05:51.658Z | 2024-09-11T12:21:01.720Z |
4997132 | 4997132 | 20240902231234_aYmTe | HR000Q | 2024-09-08T12:05:49.078Z | 2024-09-11T12:21:01.465Z |
4997029 | 4997029 | 20240902223822_sTDJ8 | HR000Q | 2024-09-08T12:05:37.085Z | 2024-09-11T12:21:00.337Z |
4996973 | 4996973 | 20240902221349_01McA | HR000Q | 2024-09-08T12:05:30.614Z | 2024-09-11T12:20:59.520Z |
4996945 | 4996945 | 20240902215638_3KN0c | HR000Q | 2024-09-08T12:05:28.480Z | 2024-09-11T12:20:59.365Z |
4996929 | 4996929 | 20240902214425_PHN2z | HR000Q | 2024-09-08T12:05:27.209Z | 2024-09-11T12:20:59.181Z |
4991847 | 4991847 | 20240901032500_bJgU9 | HR000Q | 2024-09-07T12:12:32.390Z | 2024-09-09T12:27:24.688Z |
4991838 | 4991838 | 20240901032355_mlbt0 | HR000Q | 2024-09-07T12:12:31.960Z | 2024-09-09T12:27:24.375Z |
4991671 | 4991671 | 20240901025736_4h03S | HR000Q | 2024-09-07T12:12:22.447Z | 2024-09-09T12:27:15.355Z |
4991129 | 4991129 | 20240901020126_L1W2E | HR000Q | 2024-09-07T12:11:35.837Z | 2024-09-09T12:27:00.652Z |
4990942 | 4990942 | 20240901013609_rRljs | HR000Q | 2024-09-07T12:11:21.893Z | 2024-09-09T12:26:55.934Z |
4990480 | 4990480 | 20240901002142_3hqzR | HR000Q | 2024-09-07T12:10:40.862Z | 2024-09-09T12:26:21.633Z |
4989721 | 4989721 | 20240831221401_cu5NG | HR000Q | 2024-09-07T12:09:25.437Z | 2024-09-09T12:25:42.149Z |
4989579 | 4989579 | 20240901235141_uBZgz | HR000Q | 2024-09-07T12:09:09.071Z | 2024-09-10T12:19:18.073Z |
4988736 | 4988736 | 20240901212635_bxCQj | HR000Q | 2024-09-07T12:07:53.688Z | 2024-09-10T12:19:15.264Z |
4988661 | 4988661 | 20240901211816_bM8hb | HR000Q | 2024-09-07T12:07:48.055Z | 2024-09-10T12:19:14.956Z |
4988474 | 4988474 | 20240901205514_Y2k7U | HR000Q | 2024-09-07T12:07:31.361Z | 2024-09-10T12:19:14.330Z |
4987943 | 4987943 | 20240901192234_8qGf2 | HR000Q | 2024-09-07T12:06:30.975Z | 2024-09-10T12:19:11.890Z |
4983082 | 4983082 | 20240812004101_DBWBS | HR000Q | 2024-09-06T12:15:14.702Z | 2024-09-06T12:15:14.702Z |
4980545 | 4980545 | 20240812001343_sJU1A | HR000Q | 2024-09-06T12:14:04.549Z | 2024-09-06T12:14:04.549Z |
4977511 | 4977511 | 20240811234024_2r8Xw | HR000Q | 2024-09-06T12:12:18.533Z | 2024-09-06T12:12:18.533Z |
4976478 | 4976478 | 20240811233034_YxAHr | HR000Q | 2024-09-06T12:11:33.422Z | 2024-09-06T12:11:33.422Z |
4976379 | 4976379 | 20240811232946_rWn3Y | HR000Q | 2024-09-06T12:11:30.144Z | 2024-09-06T12:11:30.144Z |
4975098 | 4975098 | 20240811231431_16vI6 | HR000Q | 2024-09-05T12:11:39.497Z | 2024-09-06T12:10:36.889Z |
4974244 | 4974244 | 20240811230451_HbMyx | HR000Q | 2024-09-05T12:11:21.371Z | 2024-09-06T12:10:24.169Z |
4970390 | 4970390 | 20240811222459_sM3FW | HR000Q | 2024-09-05T12:09:25.612Z | 2024-09-06T12:08:39.556Z |
4969506 | 4969506 | 20240811221227_h6Esi | HR000Q | 2024-09-05T12:08:46.897Z | 2024-09-06T12:07:53.346Z |
4967778 | 4967778 | 20240811214931_0Cmdn | HR000Q | 2024-09-05T12:07:47.982Z | 2024-09-06T12:07:08.850Z |
4963724 | 4963724 | 20240811203106_6cXey | HR000Q | 2024-09-04T12:05:52.552Z | 2024-09-06T12:04:52.746Z |
4963129 | 4963129 | 20240811194543_6KG7r | HR000Q | 2024-09-04T12:05:14.006Z | 2024-09-06T12:04:19.425Z |
4962853 | 4962853 | 20240811192812_Qs2cF | HR000Q | 2024-09-04T12:04:55.835Z | 2024-09-06T12:04:08.699Z |
4962540 | 4962540 | 20240811190644_TfvVw | HR000Q | 2024-09-04T12:04:37.985Z | 2024-09-06T12:03:50.490Z |
4952760 | 4952760 | 20240811022654_G2Idv | HR000Q | 2024-09-03T12:17:05.327Z | 2024-09-06T12:28:08.398Z |
4950331 | 4950331 | 20240811020519_u3GuY | HR000Q | 2024-09-02T12:16:22.440Z | 2024-09-06T12:27:43.274Z |
4947944 | 4947944 | 20240811012655_xXrzz | HR000Q | 2024-09-02T12:14:51.198Z | 2024-09-06T12:27:04.832Z |
4947476 | 4947476 | 20240811011952_h2B03 | HR000Q | 2024-09-02T12:14:35.022Z | 2024-09-06T12:26:53.853Z |
4945013 | 4945013 | 20240811003944_fp2rX | HR000Q | 2024-09-02T12:13:04.334Z | 2024-09-06T12:25:44.725Z |
4943404 | 4943404 | 20240811001104_bV9wx | HR000Q | 2024-09-02T12:11:49.874Z | 2024-09-06T12:24:47.764Z |
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);