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

>10,000 rows count all where station_code = "IT0004" 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
9611618 9611618 20260405024835_cQHMG IT0004 2026-04-06T12:15:17.547Z 2026-04-06T12:16:14.834Z
9611368 9611368 20260405013552_jauF2 IT0004 2026-04-06T12:14:08.050Z 2026-04-06T12:16:14.786Z
9611265 9611265 20260405010651_r0IS2 IT0004 2026-04-06T12:13:41.612Z 2026-04-06T12:16:14.765Z
9611229 9611229 20260405005616_C2lzq IT0004 2026-04-06T12:13:32.613Z 2026-04-06T12:16:14.758Z
9611126 9611126 20260405002452_REWIc IT0004 2026-04-06T12:13:06.829Z 2026-04-06T12:16:14.738Z
9610980 9610980 20260404231255_8ZBak IT0004 2026-04-06T12:12:25.456Z 2026-04-06T12:16:14.704Z
9610940 9610940 20260404225951_83mQS IT0004 2026-04-06T12:12:06.619Z 2026-04-06T12:16:14.695Z
9610598 9610598 20260404204606_Ts2jb IT0004 2026-04-06T12:10:16.401Z 2026-04-06T12:16:14.614Z
9610485 9610485 20260404194709_hLCRU IT0004 2026-04-06T12:09:42.454Z 2026-04-06T12:16:14.576Z
9608785 9608785 20260404012459_upaWR IT0004 2026-04-05T12:11:40.493Z 2026-04-06T12:20:36.809Z
9608161 9608161 20260403202304_3EJpf IT0004 2026-04-05T12:09:07.803Z 2026-04-06T12:19:47.013Z
9608142 9608142 20260403201150_A520Z IT0004 2026-04-05T12:09:01.450Z 2026-04-06T12:19:44.794Z
9608098 9608098 20260403193215_QcsYP IT0004 2026-04-05T12:08:35.511Z 2026-04-06T12:19:39.198Z
9598339 9598339 20260329225058_VPvpT IT0004 2026-03-31T12:10:21.235Z 2026-04-06T12:36:25.847Z
9598302 9598302 20260329221353_MInei IT0004 2026-03-31T12:10:14.353Z 2026-04-06T12:36:23.379Z
9598282 9598282 20260329215823_vK6tb IT0004 2026-03-31T12:10:11.330Z 2026-04-06T12:36:22.259Z
9598262 9598262 20260329214901_ngFWz IT0004 2026-03-31T12:10:08.503Z 2026-04-06T12:36:21.058Z
9598230 9598230 20260329205824_x2OOo IT0004 2026-03-31T12:10:02.263Z 2026-04-06T12:36:18.691Z
9595210 9595210 20260330030445_XFLZl IT0004 2026-03-31T12:00:47.817Z 2026-04-06T12:29:48.246Z
9595178 9595178 20260330025054_VVwgs IT0004 2026-03-31T12:00:42.822Z 2026-04-06T12:29:44.718Z
9595098 9595098 20260330022157_TArWK IT0004 2026-03-31T12:00:28.168Z 2026-04-06T12:29:40.380Z
9595046 9595046 20260330015851_a5ZR7 IT0004 2026-03-31T12:00:18.072Z 2026-04-06T12:29:37.206Z
9595040 9595040 20260330015521_1f2lI IT0004 2026-03-31T12:00:16.737Z 2026-04-06T12:29:36.624Z
9584421 9584421 20260325195052_LAxIp IT0004 2026-03-27T12:15:17.232Z 2026-04-03T12:39:13.644Z
9580042 9580042 20260324235158_ZVCJ4 IT0004 2026-03-26T12:14:55.317Z 2026-04-02T12:37:39.744Z
9579803 9579803 20260324225744_rdqHd IT0004 2026-03-26T12:14:29.573Z 2026-04-02T12:37:30.867Z
9579666 9579666 20260324220558_XVy3r IT0004 2026-03-26T12:14:09.653Z 2026-04-02T12:37:19.600Z
9579479 9579479 20260324205312_1dUmt IT0004 2026-03-26T12:13:46.887Z 2026-04-02T12:37:11.834Z
9577147 9577147 20260325040306_MPYmS IT0004 2026-03-26T12:04:14.588Z 2026-04-03T12:36:36.150Z
9577079 9577079 20260325035248_MA52U IT0004 2026-03-26T12:04:04.617Z 2026-04-03T12:36:33.638Z
9577071 9577071 20260325034950_AzU3P IT0004 2026-03-26T12:04:02.556Z 2026-04-03T12:36:33.232Z
9576969 9576969 20260325033029_DLwmg IT0004 2026-03-26T12:03:47.149Z 2026-04-03T12:36:27.459Z
9576828 9576828 20260325031420_qaPxz IT0004 2026-03-26T12:03:25.192Z 2026-04-03T12:36:22.589Z
9576366 9576366 20260325015710_XUexF IT0004 2026-03-26T12:02:02.217Z 2026-04-03T12:35:54.681Z
9576059 9576059 20260325010803_zWeQZ IT0004 2026-03-26T12:01:09.493Z 2026-04-03T12:35:42.795Z
9576031 9576031 20260325010127_RV0e0 IT0004 2026-03-26T12:01:01.863Z 2026-04-03T12:35:41.454Z
9575633 9575633 20260323235851_KjC53 IT0004 2026-03-25T12:21:33.155Z 2026-03-31T12:29:03.606Z
9575455 9575455 20260323221807_t5vSB IT0004 2026-03-25T12:21:10.977Z 2026-03-31T12:28:58.012Z
9575159 9575159 20260323185936_ICXWa IT0004 2026-03-25T12:20:25.410Z 2026-03-31T12:28:50.001Z
9575156 9575156 20260323185936_CN8Ji IT0004 2026-03-25T12:20:25.277Z 2026-03-31T12:28:49.919Z
9575153 9575153 20260323185936_zfGol IT0004 2026-03-25T12:20:24.919Z 2026-03-31T12:28:49.794Z
9575150 9575150 20260323185935_NyEHQ IT0004 2026-03-25T12:20:24.620Z 2026-03-31T12:28:49.716Z
9571593 9571593 20260324030420_4LI5Y IT0004 2026-03-25T12:02:01.564Z 2026-04-02T12:34:33.417Z
9571556 9571556 20260324025404_0hf7N IT0004 2026-03-25T12:01:54.549Z 2026-04-02T12:34:31.797Z
9571477 9571477 20260324022933_QHKFv IT0004 2026-03-25T12:01:38.562Z 2026-04-02T12:34:28.448Z
9571367 9571367 20260324013620_YQYlr IT0004 2026-03-25T12:01:12.650Z 2026-04-02T12:34:23.137Z
9571316 9571316 20260324010937_jI0JC IT0004 2026-03-25T12:00:58.462Z 2026-04-02T12:34:19.513Z
9571288 9571288 20260324005323_j9eQq IT0004 2026-03-25T12:00:48.555Z 2026-04-02T12:34:17.879Z
9571255 9571255 20260324004711_wuZJH IT0004 2026-03-25T12:00:41.865Z 2026-04-02T12:34:16.882Z
9571183 9571183 20260324001655_2EpqY IT0004 2026-03-25T12:00:20.200Z 2026-04-02T12:34:11.487Z
9570558 9570558 20260322220103_BJ2tA IT0004 2026-03-24T12:23:27.493Z 2026-03-30T12:30:45.398Z
9561074 9561074 20260321225404_DJQ7J IT0004 2026-03-23T12:12:11.067Z 2026-03-29T12:21:05.020Z
9560741 9560741 20260321220908_pMACz IT0004 2026-03-23T12:12:02.310Z 2026-03-29T12:21:02.476Z
9542720 9542720 20260321005824_1akJS IT0004 2026-03-22T12:01:23.439Z 2026-03-29T12:18:57.447Z
9542714 9542714 20260321005649_8MgEv IT0004 2026-03-22T12:01:21.494Z 2026-03-29T12:18:57.381Z
9541280 9541280 20260319201238_7Scuz IT0004 2026-03-21T12:28:47.867Z 2026-03-27T12:42:36.106Z
9541258 9541258 20260319201122_CIvUC IT0004 2026-03-21T12:28:46.901Z 2026-03-27T12:42:35.987Z
9540886 9540886 20260319182525_WFrJ0 IT0004 2026-03-21T12:28:15.388Z 2026-03-27T12:42:31.841Z
9521217 9521217 20260319035808_T4Grq IT0004 2026-03-20T12:07:43.039Z 2026-03-27T12:40:52.761Z
9517236 9517236 20260317225832_2qF3A IT0004 2026-03-19T12:27:21.417Z 2026-03-25T12:43:09.520Z
9517023 9517023 20260317222710_V2CTj IT0004 2026-03-19T12:27:05.332Z 2026-03-25T12:43:08.089Z
9515736 9515736 20260317181525_v5Iv0 IT0004 2026-03-19T12:24:43.542Z 2026-03-25T12:42:35.150Z
9502371 9502371 20260317032454_Sgflp IT0004 2026-03-18T12:02:35.038Z 2026-03-25T12:41:49.032Z
9502306 9502306 20260317031109_3yrL6 IT0004 2026-03-18T12:02:19.706Z 2026-03-25T12:41:48.490Z
9502221 9502221 20260317024505_q76G7 IT0004 2026-03-18T12:01:58.857Z 2026-03-25T12:41:47.580Z
9502167 9502167 20260317022145_zWx3j IT0004 2026-03-18T12:01:45.146Z 2026-03-25T12:41:47.075Z
9502151 9502151 20260317021854_1eDA3 IT0004 2026-03-18T12:01:41.965Z 2026-03-25T12:41:46.913Z
9501125 9501125 20260315210558_9hnwv IT0004 2026-03-17T12:24:27.367Z 2026-03-23T12:22:43.156Z
9494310 9494310 20260316015400_E6mZy IT0004 2026-03-17T12:03:35.292Z 2026-03-24T12:40:46.877Z
9493083 9493083 20260314223848_R3GWH IT0004 2026-03-16T12:29:25.888Z 2026-03-22T12:42:56.723Z
9485404 9485404 20260315025939_gzbpQ IT0004 2026-03-16T12:06:21.018Z 2026-03-23T12:21:52.159Z
9485393 9485393 20260315025848_oiQXY IT0004 2026-03-16T12:06:16.591Z 2026-03-23T12:21:51.848Z
9485078 9485078 20260315022249_ik8fv IT0004 2026-03-16T12:05:11.591Z 2026-03-23T12:21:49.917Z
9484738 9484738 20260315013437_R6ibV IT0004 2026-03-16T12:03:57.574Z 2026-03-23T12:21:48.197Z
9483438 9483438 20260313221501_TWL2U IT0004 2026-03-15T12:26:31.383Z 2026-03-21T12:50:27.672Z
9483384 9483384 20260313215500_oVD7Z IT0004 2026-03-15T12:26:21.268Z 2026-03-21T12:50:27.190Z
9483247 9483247 20260313212240_220fH IT0004 2026-03-15T12:26:09.512Z 2026-03-21T12:50:25.835Z
9482943 9482943 20260313195531_V4pAv IT0004 2026-03-15T12:25:36.232Z 2026-03-21T12:50:11.474Z
9482841 9482841 20260313191603_ZvjuW IT0004 2026-03-15T12:25:17.617Z 2026-03-21T12:50:01.822Z
9482784 9482784 20260313182542_vy5BC IT0004 2026-03-15T12:25:06.870Z 2026-03-21T12:50:00.381Z
9476822 9476822 20260314034258_iVZ2S IT0004 2026-03-15T12:06:56.333Z 2026-03-22T12:41:59.385Z
9475039 9475039 20260314002913_6nVcp IT0004 2026-03-15T12:02:03.702Z 2026-03-22T12:41:26.392Z
9457423 9457423 20260311035503_YZsf2 IT0004 2026-03-12T12:03:47.308Z 2026-03-19T12:44:42.420Z
9457393 9457393 20260311034930_l9afm IT0004 2026-03-12T12:03:43.079Z 2026-03-19T12:44:41.281Z
9456597 9456597 20260311000815_uBqc2 IT0004 2026-03-12T12:01:11.957Z 2026-03-19T12:44:18.880Z
9456499 9456499 20260310234403_gnZ3r IT0004 2026-03-12T12:00:53.763Z 2026-03-19T12:44:17.685Z
9456465 9456465 20260310233304_saOmn IT0004 2026-03-12T12:00:48.450Z 2026-03-19T12:44:17.417Z
9455539 9455539 20260309183707_dLg4T IT0004 2026-03-11T12:14:32.328Z 2026-03-17T12:42:34.360Z
9451574 9451574 20260310025059_hoO0G IT0004 2026-03-11T12:03:13.373Z 2026-03-18T12:38:55.289Z
9451570 9451570 20260310025059_M692I IT0004 2026-03-11T12:03:12.523Z 2026-03-18T12:38:52.796Z
9445884 9445884 20260307222225_u2g89 IT0004 2026-03-09T12:21:05.073Z 2026-03-15T12:42:15.204Z
9445784 9445784 20260307214501_BTMfI IT0004 2026-03-09T12:20:47.662Z 2026-03-15T12:42:14.319Z
9445447 9445447 20260307193508_6JH5j IT0004 2026-03-09T12:19:09.459Z 2026-03-15T12:42:08.905Z
9442266 9442266 20260308024618_7Lamd IT0004 2026-03-09T12:03:19.348Z 2026-03-16T12:43:48.368Z
9437278 9437278 20260307025230_Jq8yJ IT0004 2026-03-08T12:03:19.758Z 2026-03-15T12:41:05.576Z
9437263 9437263 20260307024758_2HavO IT0004 2026-03-08T12:03:16.491Z 2026-03-15T12:41:05.344Z
9437207 9437207 20260307023107_JgDtv IT0004 2026-03-08T12:03:00.871Z 2026-03-15T12:41:04.381Z
9437195 9437195 20260307022910_uE2h5 IT0004 2026-03-08T12:02:59.181Z 2026-03-15T12:41:04.167Z
9402800 9402800 20260227043849_m2rdp IT0004 2026-02-28T14:06:07.816Z 2026-03-07T14:47:09.344Z
9402417 9402417 20260227034947_RwmKa IT0004 2026-02-28T14:04:49.050Z 2026-03-07T14:46:46.689Z

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