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

6,002 rows where station_code = "SK0003" 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
9610564 9610564 20260404203329_MgJmB SK0003 2026-04-06T12:10:09.501Z 2026-04-06T12:16:14.604Z
9608998 9608998 20260404030335_fC9IR SK0003 2026-04-05T12:12:34.341Z 2026-04-06T12:20:56.214Z
9608908 9608908 20260404023153_pKLrr SK0003 2026-04-05T12:12:15.819Z 2026-04-06T12:20:50.195Z
9608617 9608617 20260403235859_siHn2 SK0003 2026-04-05T12:10:56.541Z 2026-04-06T12:20:26.367Z
9608437 9608437 20260403230443_SeAwU SK0003 2026-04-05T12:10:26.673Z 2026-04-06T12:20:12.830Z
9608354 9608354 20260403222424_7EYs1 SK0003 2026-04-05T12:10:10.324Z 2026-04-06T12:20:07.470Z
9608334 9608334 20260403220729_YaHtR SK0003 2026-04-05T12:10:03.102Z 2026-04-06T12:20:06.288Z
9608057 9608057 20260403184841_Lohpn SK0003 2026-04-05T12:08:06.878Z 2026-04-06T12:19:29.723Z
9579791 9579791 20260324225254_W8Fut SK0003 2026-03-26T12:14:24.784Z 2026-04-02T12:37:30.287Z
9576772 9576772 20260325030737_iA6Kr SK0003 2026-03-26T12:03:15.787Z 2026-04-03T12:36:20.668Z
9576647 9576647 20260325024729_QOXQk SK0003 2026-03-26T12:02:53.543Z 2026-04-03T12:36:15.790Z
9576194 9576194 20260325013345_bnabD SK0003 2026-03-26T12:01:32.212Z 2026-04-03T12:35:48.016Z
9576185 9576185 20260325013203_TXC6j SK0003 2026-03-26T12:01:30.566Z 2026-04-03T12:35:47.582Z
9576110 9576110 20260325011656_gUZY6 SK0003 2026-03-26T12:01:18.478Z 2026-04-03T12:35:44.508Z
9576105 9576105 20260325011639_47QV1 SK0003 2026-03-26T12:01:17.179Z 2026-04-03T12:35:44.243Z
9571450 9571450 20260324021534_1dtjX SK0003 2026-03-25T12:01:31.353Z 2026-04-02T12:34:27.141Z
9570841 9570841 20260322225757_27WJF SK0003 2026-03-24T12:23:54.269Z 2026-03-30T12:30:50.289Z
9542237 9542237 20260319230404_wRJgq SK0003 2026-03-21T12:29:53.335Z 2026-03-27T12:42:50.541Z
9542018 9542018 20260319223102_8Bdle SK0003 2026-03-21T12:29:36.082Z 2026-03-27T12:42:44.293Z
9541683 9541683 20260319212701_k7Uwm SK0003 2026-03-21T12:29:16.591Z 2026-03-27T12:42:40.863Z
9541470 9541470 20260319204131_WyW6C SK0003 2026-03-21T12:28:58.898Z 2026-03-27T12:42:38.023Z
9541104 9541104 20260319192540_vBzFi SK0003 2026-03-21T12:28:30.542Z 2026-03-27T12:42:34.091Z
9541012 9541012 20260319185620_w8wtO SK0003 2026-03-21T12:28:23.042Z 2026-03-27T12:42:32.940Z
9540991 9540991 20260319184827_2uTyM SK0003 2026-03-21T12:28:21.809Z 2026-03-27T12:42:32.758Z
9540987 9540987 20260319184825_uzK8i SK0003 2026-03-21T12:28:21.442Z 2026-03-27T12:42:32.709Z
9534068 9534068 20260320032126_7vzqr SK0003 2026-03-21T12:07:03.552Z 2026-03-28T12:34:07.412Z
9532354 9532354 20260320004824_sa3gp SK0003 2026-03-21T12:02:27.459Z 2026-03-28T12:33:28.214Z
9531112 9531112 20260318222614_VhQog SK0003 2026-03-20T12:24:57.910Z 2026-03-26T12:39:17.470Z
9531009 9531009 20260318221359_uC2uf SK0003 2026-03-20T12:24:54.480Z 2026-03-26T12:39:16.947Z
9530426 9530426 20260318205307_YieIK SK0003 2026-03-20T12:24:23.005Z 2026-03-26T12:39:12.146Z
9529969 9529969 20260318194858_ZHiDt SK0003 2026-03-20T12:23:52.368Z 2026-03-26T12:39:07.888Z
9529541 9529541 20260318184659_JZAOS SK0003 2026-03-20T12:23:17.325Z 2026-03-26T12:39:03.990Z
9520919 9520919 20260319034431_sBQpd SK0003 2026-03-20T12:07:14.277Z 2026-03-27T12:40:49.053Z
9520320 9520320 20260319031015_p2zUT SK0003 2026-03-20T12:06:13.924Z 2026-03-27T12:40:42.037Z
9520190 9520190 20260319030127_fS27V SK0003 2026-03-20T12:05:56.088Z 2026-03-27T12:40:40.315Z
9519763 9519763 20260319023448_A4DPM SK0003 2026-03-20T12:05:03.937Z 2026-03-27T12:40:35.329Z
9519590 9519590 20260319021910_ajiyp SK0003 2026-03-20T12:04:41.315Z 2026-03-27T12:40:32.804Z
9519273 9519273 20260319015737_RN4PV SK0003 2026-03-20T12:04:13.618Z 2026-03-27T12:40:19.731Z
9518955 9518955 20260319013858_wJP3g SK0003 2026-03-20T12:03:39.701Z 2026-03-27T12:40:16.748Z
9518899 9518899 20260319013327_L2jB8 SK0003 2026-03-20T12:03:34.514Z 2026-03-27T12:40:16.276Z
9518611 9518611 20260319011326_7nJHA SK0003 2026-03-20T12:02:58.664Z 2026-03-27T12:40:11.861Z
9518571 9518571 20260319011029_fxxhF SK0003 2026-03-20T12:02:51.493Z 2026-03-27T12:40:11.479Z
9518520 9518520 20260319010602_r6UMs SK0003 2026-03-20T12:02:45.473Z 2026-03-27T12:40:11.029Z
9518335 9518335 20260319005036_3rPLx SK0003 2026-03-20T12:02:19.013Z 2026-03-27T12:40:08.481Z
9518177 9518177 20260319003925_c2We3 SK0003 2026-03-20T12:02:03.779Z 2026-03-27T12:40:07.092Z
9517526 9517526 20260318233554_74MCE SK0003 2026-03-20T12:00:37.108Z 2026-03-27T12:40:00.514Z
9502264 9502264 20260317025602_505rT SK0003 2026-03-18T12:02:09.089Z 2026-03-25T12:41:48.055Z
9493095 9493095 20260314224016_FsmXg SK0003 2026-03-16T12:29:26.186Z 2026-03-22T12:42:56.753Z
9492882 9492882 20260314220926_kmGA9 SK0003 2026-03-16T12:29:08.166Z 2026-03-22T12:42:55.555Z
9492685 9492685 20260314213904_73Vuw SK0003 2026-03-16T12:28:56.202Z 2026-03-22T12:42:53.895Z
9492147 9492147 20260314192743_1CLGF SK0003 2026-03-16T12:28:04.859Z 2026-03-22T12:42:50.487Z
9485240 9485240 20260315024153_wCIaw SK0003 2026-03-16T12:05:44.426Z 2026-03-23T12:21:50.563Z
9483960 9483960 20260314233155_ExGlu SK0003 2026-03-16T12:01:04.898Z 2026-03-23T12:21:44.623Z
9469762 9469762 20260313034300_P494U SK0003 2026-03-14T12:05:27.276Z 2026-03-21T12:49:01.990Z
9469740 9469740 20260313033743_43fRi SK0003 2026-03-14T12:05:21.919Z 2026-03-21T12:49:01.713Z
9469522 9469522 20260313030127_ycYle SK0003 2026-03-14T12:04:34.624Z 2026-03-21T12:48:40.869Z
9469363 9469363 20260313023456_n06p9 SK0003 2026-03-14T12:04:00.465Z 2026-03-21T12:48:38.144Z
9469304 9469304 20260313022711_WPchw SK0003 2026-03-14T12:03:47.028Z 2026-03-21T12:48:37.178Z
9469246 9469246 20260313021950_Hk0ce SK0003 2026-03-14T12:03:34.898Z 2026-03-21T12:48:35.951Z
9460740 9460740 20260310220958_alcJS SK0003 2026-03-12T12:15:01.305Z 2026-03-18T12:40:18.748Z
9460330 9460330 20260310180236_Gi6Z2 SK0003 2026-03-12T12:13:41.061Z 2026-03-18T12:39:51.570Z
9457419 9457419 20260311035230_04yFI SK0003 2026-03-12T12:03:46.697Z 2026-03-19T12:44:42.348Z
9457341 9457341 20260311033923_3Off7 SK0003 2026-03-12T12:03:37.105Z 2026-03-19T12:44:39.817Z
9457298 9457298 20260311032525_6dhLl SK0003 2026-03-12T12:03:30.478Z 2026-03-19T12:44:36.994Z
9457247 9457247 20260311031440_bviA1 SK0003 2026-03-12T12:03:18.840Z 2026-03-19T12:44:34.672Z
9457225 9457225 20260311030741_G3Xon SK0003 2026-03-12T12:03:14.169Z 2026-03-19T12:44:33.055Z
9457223 9457223 20260311030741_tP3sp SK0003 2026-03-12T12:03:13.687Z 2026-03-19T12:44:32.628Z
9456990 9456990 20260311020142_2NpKn SK0003 2026-03-12T12:02:29.992Z 2026-03-19T12:44:24.498Z
9456786 9456786 20260311010024_oRBPG SK0003 2026-03-12T12:01:47.683Z 2026-03-19T12:44:21.984Z
9456496 9456496 20260310234400_ohC3c SK0003 2026-03-12T12:00:53.436Z 2026-03-19T12:44:17.658Z
9456368 9456368 20260310230514_RDq71 SK0003 2026-03-12T12:00:27.243Z 2026-03-19T12:44:16.273Z
9445546 9445546 20260307202553_VO8Ed SK0003 2026-03-09T12:19:44.168Z 2026-03-15T12:42:10.876Z
9445496 9445496 20260307200541_vUPfY SK0003 2026-03-09T12:19:28.228Z 2026-03-15T12:42:10.022Z
9445318 9445318 20260307174919_tnlpB SK0003 2026-03-09T12:18:24.365Z 2026-03-15T12:42:05.687Z
9442518 9442518 20260308040131_h2Bad SK0003 2026-03-09T12:04:21.537Z 2026-03-16T12:43:52.685Z
9442429 9442429 20260308033326_RkPKy SK0003 2026-03-09T12:03:59.578Z 2026-03-16T12:43:51.352Z
9441741 9441741 20260307232512_1N2J7 SK0003 2026-03-09T12:00:57.187Z 2026-03-16T12:43:30.349Z
9441692 9441692 20260307231307_KBIvE SK0003 2026-03-09T12:00:45.160Z 2026-03-16T12:43:29.547Z
9441685 9441685 20260307231306_ZItFJ SK0003 2026-03-09T12:00:44.002Z 2026-03-16T12:43:29.507Z
9441679 9441679 20260307231246_ii6PM SK0003 2026-03-09T12:00:42.482Z 2026-03-16T12:43:29.475Z
9441671 9441671 20260307231030_OvXNx SK0003 2026-03-09T12:00:40.166Z 2026-03-16T12:43:29.373Z
9441620 9441620 20260307225724_KFyG4 SK0003 2026-03-09T12:00:28.251Z 2026-03-16T12:43:28.484Z
9441416 9441416 20260306213641_GJRuG SK0003 2026-03-08T12:21:45.713Z 2026-03-14T12:40:51.771Z
9441034 9441034 20260306191355_BbdV6 SK0003 2026-03-08T12:20:11.663Z 2026-03-14T12:40:41.953Z
9441018 9441018 20260306190520_DcYeL SK0003 2026-03-08T12:20:09.426Z 2026-03-14T12:40:41.746Z
9437384 9437384 20260307032840_ALOfM SK0003 2026-03-08T12:03:46.786Z 2026-03-15T12:41:06.967Z
9436150 9436150 20260305192533_9Ll0o SK0003 2026-03-07T14:24:41.966Z 2026-03-13T12:35:41.400Z
9436134 9436134 20260305191828_2XAxr SK0003 2026-03-07T14:24:37.157Z 2026-03-13T12:35:41.082Z
9436132 9436132 20260305191817_lfz2q SK0003 2026-03-07T14:24:36.617Z 2026-03-13T12:35:41.070Z
9432233 9432233 20260306040616_mCztc SK0003 2026-03-07T14:03:59.042Z 2026-03-14T12:39:27.322Z
9432185 9432185 20260306035345_7mdMI SK0003 2026-03-07T14:03:46.605Z 2026-03-14T12:39:26.268Z
9432174 9432174 20260306034956_F2QRu SK0003 2026-03-07T14:03:44.041Z 2026-03-14T12:39:26.072Z
9431948 9431948 20260306024534_oLn3a SK0003 2026-03-07T14:02:38.796Z 2026-03-14T12:39:21.091Z
9431786 9431786 20260306015622_E1fLL SK0003 2026-03-07T14:02:00.813Z 2026-03-14T12:39:17.641Z
9431511 9431511 20260306000449_y5rR3 SK0003 2026-03-07T14:00:57.539Z 2026-03-14T12:39:13.811Z
9431423 9431423 20260305233355_wghxu SK0003 2026-03-07T14:00:36.439Z 2026-03-14T12:39:12.598Z
9415408 9415408 20260228224429_DGrW8 SK0003 2026-03-02T14:07:51.458Z 2026-03-08T12:43:13.079Z
9415396 9415396 20260228223546_fHZG5 SK0003 2026-03-02T14:07:50.608Z 2026-03-08T12:43:12.718Z
9415393 9415393 20260228223545_sJs7d SK0003 2026-03-02T14:07:50.420Z 2026-03-08T12:43:12.674Z
9411927 9411927 20260227224603_rmJdg SK0003 2026-03-01T14:09:21.325Z 2026-03-07T14:51:23.778Z

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