home / gmn_data_store / participating_station

Menu
  • Dashboards

participating_station

Each row represents a station recording a meteor sighting.

Data license: CC BY 4.0 license · Data source: Global Meteor Network

2,991 rows where station_code = "ES001F" sorted by created_at descending

✎ View and edit SQL

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
8452820 8452820 20251112050800_7cWjj ES001F 2025-11-14T14:38:20.851Z 2025-11-20T15:25:39.887Z
8452814 8452814 20251112043237_89eph ES001F 2025-11-14T14:38:14.921Z 2025-11-20T15:25:32.348Z
8452810 8452810 20251112033729_ZQXHa ES001F 2025-11-14T14:37:35.608Z 2025-11-20T15:25:16.737Z
8452808 8452808 20251112030416_jNgeB ES001F 2025-11-14T14:37:26.858Z 2025-11-20T15:24:56.572Z
8452806 8452806 20251112025703_10Pa0 ES001F 2025-11-14T14:37:25.420Z 2025-11-20T15:24:53.153Z
8452804 8452804 20251112025634_YCP2D ES001F 2025-11-14T14:37:24.827Z 2025-11-20T15:24:53.053Z
8452798 8452798 20251112020227_n5eyL ES001F 2025-11-14T14:37:11.506Z 2025-11-20T15:24:36.693Z
8452794 8452794 20251112014407_x1j8K ES001F 2025-11-14T14:36:49.763Z 2025-11-20T15:24:25.140Z
8452792 8452792 20251112013445_rYZ05 ES001F 2025-11-14T14:36:44.007Z 2025-11-20T15:24:17.580Z
8452790 8452790 20251112001615_mjUbQ ES001F 2025-11-14T14:36:24.595Z 2025-11-20T15:23:42.227Z
8452788 8452788 20251112001542_5Xzna ES001F 2025-11-14T14:36:22.367Z 2025-11-20T15:23:42.147Z
8452786 8452786 20251112000031_NHUJc ES001F 2025-11-14T14:36:06.845Z 2025-11-20T15:23:29.987Z
8452781 8452781 20251111235521_rTt3U ES001F 2025-11-14T14:35:59.900Z 2025-11-20T15:23:28.876Z
8452779 8452779 20251111234835_dTXOh ES001F 2025-11-14T14:35:51.391Z 2025-11-20T15:23:25.122Z
8452777 8452777 20251111234824_izao7 ES001F 2025-11-14T14:35:51.027Z 2025-11-20T15:23:25.052Z
8452767 8452767 20251111224142_bkWWv ES001F 2025-11-14T14:35:35.300Z 2025-11-20T15:23:01.987Z
8452764 8452764 20251111210748_I2xQw ES001F 2025-11-14T14:34:59.517Z 2025-11-20T15:22:44.769Z
8437109 8437109 20251111231953_Oj5II ES001F 2025-11-13T14:20:13.559Z 2025-11-20T15:23:14.200Z
8427852 8427852 20251111051833_ZxrWp ES001F 2025-11-12T14:29:14.694Z 2025-11-19T15:18:06.484Z
8427245 8427245 20251111041956_MjcLq ES001F 2025-11-12T14:27:31.173Z 2025-11-19T15:17:48.502Z
8427163 8427163 20251111041202_eyoiB ES001F 2025-11-12T14:27:20.338Z 2025-11-19T15:17:45.756Z
8426778 8426778 20251111034241_jIKmz ES001F 2025-11-12T14:26:22.232Z 2025-11-19T15:17:26.164Z
8426678 8426678 20251111033155_QJNRk ES001F 2025-11-12T14:26:00.190Z 2025-11-19T15:17:24.431Z
8426298 8426298 20251111025120_gaY6D ES001F 2025-11-12T14:25:00.338Z 2025-11-19T15:17:02.839Z
8425721 8425721 20251111020820_McIZ2 ES001F 2025-11-12T14:23:31.082Z 2025-11-19T15:16:45.866Z
8415220 8415220 20251110044524_aDR3i ES001F 2025-11-11T14:22:54.844Z 2025-11-18T15:21:23.773Z
8414588 8414588 20251110031537_07yQs ES001F 2025-11-11T14:21:07.623Z 2025-11-18T15:21:09.530Z
8414568 8414568 20251110031000_rWKM7 ES001F 2025-11-11T14:21:05.161Z 2025-11-18T15:21:09.230Z
8414429 8414429 20251110024121_tVrOP ES001F 2025-11-11T14:20:42.058Z 2025-11-18T15:21:05.600Z
8414328 8414328 20251110022007_CHycy ES001F 2025-11-11T14:20:17.713Z 2025-11-18T15:20:56.096Z
8414188 8414188 20251110015412_F4YHz ES001F 2025-11-11T14:19:54.192Z 2025-11-18T15:20:47.698Z
8414164 8414164 20251110015006_8AA6P ES001F 2025-11-11T14:19:39.659Z 2025-11-18T15:20:44.526Z
8414160 8414160 20251110014839_E4A7Q ES001F 2025-11-11T14:19:38.955Z 2025-11-18T15:20:42.677Z
8414050 8414050 20251110013200_jOERl ES001F 2025-11-11T14:19:22.818Z 2025-11-18T15:20:37.108Z
8414006 8414006 20251110012621_3lNEy ES001F 2025-11-11T14:19:17.690Z 2025-11-18T15:20:33.876Z
8414004 8414004 20251110012527_Y2lYQ ES001F 2025-11-11T14:19:17.299Z 2025-11-18T15:20:33.874Z
8413662 8413662 20251110001345_9ZfX3 ES001F 2025-11-11T14:18:03.158Z 2025-11-18T15:20:23.242Z
8413468 8413468 20251109233313_cbqwc ES001F 2025-11-11T14:17:31.935Z 2025-11-18T15:20:21.526Z
8413147 8413147 20251109221947_cplSV ES001F 2025-11-11T14:16:20.949Z 2025-11-18T15:20:18.738Z
8413108 8413108 20251109221214_LcvuK ES001F 2025-11-11T14:16:13.731Z 2025-11-18T15:20:18.275Z
8412933 8412933 20251109212405_hGsmn ES001F 2025-11-11T14:15:36.490Z 2025-11-18T15:20:16.695Z
8412821 8412821 20251109210059_yZKYY ES001F 2025-11-11T14:15:18.620Z 2025-11-18T15:20:15.549Z
8412768 8412768 20251109205611_iKUel ES001F 2025-11-11T14:14:59.952Z 2025-11-18T15:20:15.194Z
8412551 8412551 20251109203303_sc5S2 ES001F 2025-11-11T14:14:34.043Z 2025-11-18T15:20:12.788Z
8412258 8412258 20251109195855_1BqAw ES001F 2025-11-11T14:13:29.581Z 2025-11-18T15:20:09.275Z
8412127 8412127 20251109195030_f45sF ES001F 2025-11-11T14:13:03.512Z 2025-11-18T15:20:08.018Z
8406231 8406231 20251109054205_7buso ES001F 2025-11-10T14:16:16.131Z 2025-11-17T14:59:09.912Z
8405987 8405987 20251109045605_aMOAs ES001F 2025-11-10T14:15:30.435Z 2025-11-17T14:59:06.950Z
8405710 8405710 20251109041428_v588n ES001F 2025-11-10T14:14:50.250Z 2025-11-17T14:59:04.154Z
8405555 8405555 20251109034710_QvOwU ES001F 2025-11-10T14:14:34.231Z 2025-11-17T14:59:00.648Z
8405534 8405534 20251109034425_RnFY2 ES001F 2025-11-10T14:14:32.397Z 2025-11-17T14:59:00.282Z
8405262 8405262 20251109031229_0WsWw ES001F 2025-11-10T14:13:54.953Z 2025-11-17T14:58:55.911Z
8405258 8405258 20251109031146_29wby ES001F 2025-11-10T14:13:54.840Z 2025-11-17T14:58:55.910Z
8405015 8405015 20251109025005_7uO6L ES001F 2025-11-10T14:13:17.705Z 2025-11-17T14:58:54.332Z
8404913 8404913 20251109023654_hzP6l ES001F 2025-11-10T14:13:09.573Z 2025-11-17T14:58:53.572Z
8404909 8404909 20251109023634_f776M ES001F 2025-11-10T14:13:08.502Z 2025-11-17T14:58:53.388Z
8404812 8404812 20251109022720_k4xw9 ES001F 2025-11-10T14:12:42.288Z 2025-11-17T14:58:51.166Z
8404742 8404742 20251109021612_bQ5jb ES001F 2025-11-10T14:12:34.069Z 2025-11-17T14:58:50.726Z
8404622 8404622 20251109020216_qV0Qf ES001F 2025-11-10T14:12:15.228Z 2025-11-17T14:58:49.370Z
8404541 8404541 20251109015220_ZghIC ES001F 2025-11-10T14:12:01.595Z 2025-11-17T14:58:48.620Z
8404308 8404308 20251109012925_bJs4R ES001F 2025-11-10T14:11:27.110Z 2025-11-17T14:58:44.454Z
8404077 8404077 20251109010109_Md1gO ES001F 2025-11-10T14:10:46.934Z 2025-11-17T14:58:41.952Z
8404032 8404032 20251109005548_ugUuB ES001F 2025-11-10T14:10:40.635Z 2025-11-17T14:58:41.307Z
8404016 8404016 20251109005219_AP9zs ES001F 2025-11-10T14:10:35.415Z 2025-11-17T14:58:40.999Z
8403978 8403978 20251109004527_rWpuL ES001F 2025-11-10T14:10:30.841Z 2025-11-17T14:58:40.775Z
8403644 8403644 20251108234948_jRJWP ES001F 2025-11-10T14:09:36.120Z 2025-11-17T14:58:37.571Z
8403642 8403642 20251108234922_mnXaC ES001F 2025-11-10T14:09:35.988Z 2025-11-17T14:58:37.570Z
8403527 8403527 20251108233314_BH5tR ES001F 2025-11-10T14:09:14.353Z 2025-11-17T14:58:36.533Z
8403432 8403432 20251108232150_cyAQV ES001F 2025-11-10T14:09:03.795Z 2025-11-17T14:58:35.726Z
8403410 8403410 20251108231812_ZO3Xk ES001F 2025-11-10T14:09:02.670Z 2025-11-17T14:58:35.683Z
8403350 8403350 20251108230836_83gLX ES001F 2025-11-10T14:08:58.803Z 2025-11-17T14:58:35.080Z
8402917 8402917 20251108215049_hBcPQ ES001F 2025-11-10T14:07:59.933Z 2025-11-17T14:58:29.451Z
8402844 8402844 20251108213618_PezNb ES001F 2025-11-10T14:07:47.093Z 2025-11-17T14:58:28.664Z
8402395 8402395 20251108193943_4UlNo ES001F 2025-11-10T14:06:43.450Z 2025-11-17T14:58:16.593Z
8402380 8402380 20251108193323_2MfOl ES001F 2025-11-10T14:06:30.748Z 2025-11-17T14:58:15.178Z
8402255 8402255 20251108190719_neq3U ES001F 2025-11-10T14:06:07.167Z 2025-11-17T14:58:13.509Z
8397978 8397978 20251108031154_2YtVU ES001F 2025-11-09T14:13:48.389Z 2025-11-16T15:04:32.025Z
8397339 8397339 20251108012640_5Gwf6 ES001F 2025-11-09T14:11:53.657Z 2025-11-16T15:04:14.195Z
8397306 8397306 20251108011829_R32uS ES001F 2025-11-09T14:11:46.510Z 2025-11-16T15:04:13.415Z
8397189 8397189 20251108005507_2kbKX ES001F 2025-11-09T14:11:17.412Z 2025-11-16T15:04:09.238Z
8397174 8397174 20251108005256_4vVRm ES001F 2025-11-09T14:11:14.099Z 2025-11-16T15:04:08.914Z
8390747 8390747 20251107011652_qOFtE ES001F 2025-11-08T14:12:08.521Z 2025-11-15T15:00:09.773Z
8390397 8390397 20251107002201_MdD8W ES001F 2025-11-08T14:10:45.822Z 2025-11-15T15:00:01.749Z
8374783 8374783 20251103045417_zs9h8 ES001F 2025-11-05T14:33:12.033Z 2025-11-11T15:08:07.308Z
8374680 8374680 20251103043124_Y4aEA ES001F 2025-11-05T14:32:52.409Z 2025-11-11T15:08:04.605Z
8374645 8374645 20251103042251_Euu2k ES001F 2025-11-05T14:32:37.628Z 2025-11-11T15:07:53.929Z
8374448 8374448 20251103034608_gvxcX ES001F 2025-11-05T14:32:10.595Z 2025-11-11T15:07:32.734Z
8374385 8374385 20251103033615_6cdcd ES001F 2025-11-05T14:31:44.017Z 2025-11-11T15:07:29.223Z
8373626 8373626 20251102230641_xKs3C ES001F 2025-11-05T14:28:17.804Z 2025-11-11T15:06:13.212Z
8371753 8371753 20251104053528_HGhre ES001F 2025-11-05T14:16:02.999Z 2025-11-12T15:11:06.142Z
8371744 8371744 20251104053438_3H4Pj ES001F 2025-11-05T14:16:02.185Z 2025-11-12T15:11:06.039Z
8371136 8371136 20251104034744_eHJMY ES001F 2025-11-05T14:13:56.108Z 2025-11-12T15:10:56.665Z
8371117 8371117 20251104034612_7RgsH ES001F 2025-11-05T14:13:53.831Z 2025-11-12T15:10:56.447Z
8371064 8371064 20251104033625_tVFzn ES001F 2025-11-05T14:13:33.635Z 2025-11-12T15:10:55.622Z
8371038 8371038 20251104033237_3zeIU ES001F 2025-11-05T14:13:30.472Z 2025-11-12T15:10:55.181Z
8370773 8370773 20251104030037_kMIa7 ES001F 2025-11-05T14:12:28.132Z 2025-11-12T15:10:50.734Z
8369908 8369908 20251103232902_KR3C5 ES001F 2025-11-05T14:08:48.957Z 2025-11-12T15:10:01.012Z
8369818 8369818 20251103225210_Txjq7 ES001F 2025-11-05T14:08:28.905Z 2025-11-12T15:09:48.964Z
8369630 8369630 20251103215327_cHbof ES001F 2025-11-05T14:07:50.516Z 2025-11-12T15:09:29.176Z
8365783 8365783 20251103055553_hAknb ES001F 2025-11-04T14:21:31.303Z 2025-11-11T15:08:11.391Z

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 1.2ms · Data license: CC BY 4.0 license · Data source: Global Meteor Network