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

147 rows where station_code = "RU001D" 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
9071240 9071240 20251226181150_j4mgD RU001D 2025-12-29T14:49:03.104Z 2025-12-30T15:22:33.694Z
9063286 9063286 20251226030347_7JDE7 RU001D 2025-12-29T14:34:56.228Z 2026-01-03T15:35:10.508Z
9062853 9062853 20251226024217_s12j7 RU001D 2025-12-29T14:34:13.022Z 2026-01-03T15:34:44.328Z
9059959 9059959 20251225231325_jnq27 RU001D 2025-12-29T14:28:30.286Z 2026-01-03T15:32:29.120Z
9047532 9047532 20251223191255_06hvm RU001D 2025-12-28T14:56:38.239Z 2025-12-28T14:56:38.239Z
9046995 9046995 20251223160048_tNUMt RU001D 2025-12-28T14:55:48.153Z 2025-12-28T14:55:48.153Z
9044577 9044577 20251223041925_vgOwS RU001D 2025-12-28T14:51:53.584Z 2025-12-28T14:51:53.584Z
9044504 9044504 20251223034503_uuG6B RU001D 2025-12-28T14:51:17.739Z 2025-12-31T15:42:12.121Z
8887079 8887079 20251214012544_y9ucl RU001D 2025-12-22T14:11:23.380Z 2025-12-23T14:27:39.770Z
8769244 8769244 20251212184206_tjpO3 RU001D 2025-12-15T14:19:44.394Z 2025-12-21T14:17:26.612Z
8769032 8769032 20251212181354_27kdj RU001D 2025-12-15T14:18:47.743Z 2025-12-21T14:17:26.478Z
8768810 8768810 20251212172901_rr9sS RU001D 2025-12-15T14:18:03.177Z 2025-12-21T14:17:26.259Z
8768688 8768688 20251212155258_DXO3B RU001D 2025-12-15T14:16:57.008Z 2025-12-21T14:17:25.855Z
8623725 8623725 20251127015037_QWW56 RU001D 2025-11-28T14:22:30.848Z 2025-12-05T15:04:11.929Z
8623668 8623668 20251127014127_Csk3e RU001D 2025-11-28T14:22:22.067Z 2025-12-05T15:04:06.856Z
8623267 8623267 20251126233840_N7nqN RU001D 2025-11-28T14:21:25.647Z 2025-12-05T15:03:41.304Z
8623249 8623249 20251126233509_J12he RU001D 2025-11-28T14:21:23.586Z 2025-12-05T15:03:40.529Z
8623218 8623218 20251126232224_3F1QE RU001D 2025-11-28T14:21:06.737Z 2025-12-05T15:03:38.468Z
8623182 8623182 20251126231354_JSuST RU001D 2025-11-28T14:21:02.312Z 2025-12-05T15:03:36.609Z
8623128 8623128 20251126225707_7kFHL RU001D 2025-11-28T14:20:55.637Z 2025-12-05T15:03:30.553Z
8180182 8180182 20251021224404_9mam2 RU001D 2025-10-23T12:18:00.859Z 2025-10-30T13:12:59.205Z
8179886 8179886 20251021221458_7PuZK RU001D 2025-10-23T12:17:24.576Z 2025-10-30T13:12:58.004Z
8179478 8179478 20251021212130_Sw9vU RU001D 2025-10-23T12:16:22.692Z 2025-10-30T13:12:54.266Z
8179418 8179418 20251021210902_Lkus2 RU001D 2025-10-23T12:16:16.838Z 2025-10-30T13:12:53.136Z
8178877 8178877 20251021201421_H36VT RU001D 2025-10-23T12:14:44.918Z 2025-10-30T13:12:49.590Z
8178875 8178875 20251021201420_bhtUB RU001D 2025-10-23T12:14:44.687Z 2025-10-23T12:39:24.381Z
8178828 8178828 20251021201108_U3A4p RU001D 2025-10-23T12:14:39.970Z 2025-10-30T13:12:48.905Z
8178239 8178239 20251021190702_dznaD RU001D 2025-10-23T12:12:44.891Z 2025-10-30T13:12:46.966Z
8177804 8177804 20251021180909_6O15L RU001D 2025-10-23T12:11:21.768Z 2025-10-30T13:12:45.396Z
8177756 8177756 20251021180141_9jBvm RU001D 2025-10-23T12:11:15.242Z 2025-10-30T13:12:45.236Z
8177367 8177367 20251021165303_dfp3I RU001D 2025-10-23T12:09:48.151Z 2025-10-30T13:12:43.828Z
8164459 8164459 20251019203153_B66m6 RU001D 2025-10-22T12:25:30.443Z 2025-10-28T13:07:54.727Z
8146550 8146550 20251019034313_JV2pZ RU001D 2025-10-20T12:22:48.454Z 2025-10-27T13:10:41.825Z
8144874 8144874 20251019014056_ptHhR RU001D 2025-10-20T12:18:41.498Z 2025-10-27T13:10:18.877Z
8143740 8143740 20251018235956_F8MCB RU001D 2025-10-20T12:15:11.026Z 2025-10-27T13:10:06.939Z
8142995 8142995 20251018224519_D6YeM RU001D 2025-10-20T12:13:00.906Z 2025-10-27T13:10:02.562Z
8141775 8141775 20251018194305_ji3pQ RU001D 2025-10-20T12:08:33.527Z 2025-10-27T13:09:44.738Z
8133798 8133798 20251018033448_PjJPG RU001D 2025-10-19T12:14:03.931Z 2025-10-26T13:15:46.974Z
8132489 8132489 20251018012005_oIFjr RU001D 2025-10-19T12:10:38.155Z 2025-10-26T13:15:21.393Z
8132396 8132396 20251018010626_u4QGz RU001D 2025-10-19T12:10:20.924Z 2025-10-26T13:15:20.896Z
8132333 8132333 20251018005638_4w4Zt RU001D 2025-10-19T12:10:02.318Z 2025-10-26T13:15:20.405Z
8132260 8132260 20251018004602_2lMsP RU001D 2025-10-19T12:09:51.481Z 2025-10-26T13:15:19.604Z
8132219 8132219 20251018004232_9cLkC RU001D 2025-10-19T12:09:47.878Z 2025-10-26T13:15:19.387Z
8132189 8132189 20251018003854_I8lB4 RU001D 2025-10-19T12:09:44.463Z 2025-10-26T13:15:19.139Z
8131569 8131569 20251017230425_k444w RU001D 2025-10-19T12:07:57.701Z 2025-10-26T13:15:08.950Z
8131560 8131560 20251017230315_3lPJ3 RU001D 2025-10-19T12:07:56.477Z 2025-10-26T13:15:08.859Z
8131490 8131490 20251017224919_Pu2Bw RU001D 2025-10-19T12:07:44.309Z 2025-10-26T13:15:08.057Z
8131377 8131377 20251017221234_JvWSl RU001D 2025-10-19T12:07:31.713Z 2025-10-26T13:15:06.139Z
8131235 8131235 20251017214256_NmLY3 RU001D 2025-10-19T12:06:59.721Z 2025-10-26T13:15:01.327Z
8130834 8130834 20251017184451_tSTJ7 RU001D 2025-10-19T12:05:44.192Z 2025-10-26T13:14:56.587Z
8130802 8130802 20251017182517_uAcn5 RU001D 2025-10-19T12:05:39.693Z 2025-10-26T13:14:56.032Z
8123172 8123172 20251017031445_YVQeY RU001D 2025-10-18T12:25:41.715Z 2025-10-25T13:29:05.879Z
8123143 8123143 20251017031049_n3aK7 RU001D 2025-10-18T12:25:37.281Z 2025-10-25T13:29:05.214Z
8122885 8122885 20251017024651_nWkuX RU001D 2025-10-18T12:25:13.494Z 2025-10-25T13:28:58.125Z
8122881 8122881 20251017024616_SMIgz RU001D 2025-10-18T12:25:06.056Z 2025-10-25T13:28:57.982Z
8122780 8122780 20251017022916_urMKc RU001D 2025-10-18T12:24:41.687Z 2025-10-25T13:28:51.148Z
8122401 8122401 20251017015214_qCJOA RU001D 2025-10-18T12:23:41.248Z 2025-10-25T13:28:30.763Z
8122354 8122354 20251017014833_rXGnx RU001D 2025-10-18T12:23:19.172Z 2025-10-25T13:28:28.152Z
8122352 8122352 20251017014821_X4wqn RU001D 2025-10-18T12:23:18.806Z 2025-10-25T13:28:28.117Z
8122007 8122007 20251017010454_tLxeO RU001D 2025-10-18T12:22:14.654Z 2025-10-25T13:28:09.382Z
8121581 8121581 20251017001011_nxihQ RU001D 2025-10-18T12:20:50.201Z 2025-10-25T13:27:44.935Z
8121370 8121370 20251016233743_vq8K4 RU001D 2025-10-18T12:20:01.161Z 2025-10-25T13:27:29.212Z
8121316 8121316 20251016232819_hrJal RU001D 2025-10-18T12:19:51.664Z 2025-10-25T13:27:27.029Z
8121296 8121296 20251016232433_6R3i9 RU001D 2025-10-18T12:19:49.065Z 2025-10-25T13:27:26.505Z
8120705 8120705 20251016212011_lTC5a RU001D 2025-10-18T12:17:40.108Z 2025-10-25T13:26:39.642Z
8120610 8120610 20251016205048_lgVF9 RU001D 2025-10-18T12:17:13.513Z 2025-10-25T13:26:32.834Z
8120539 8120539 20251016203435_Gz10s RU001D 2025-10-18T12:17:03.305Z 2025-10-25T13:26:29.017Z
8086517 8086517 20251011234132_M2E1d RU001D 2025-10-13T12:08:26.078Z 2025-10-20T13:03:26.708Z
8086347 8086347 20251011225633_fP2tP RU001D 2025-10-13T12:08:02.844Z 2025-10-20T13:03:23.635Z
8086268 8086268 20251011224232_cs1YI RU001D 2025-10-13T12:07:55.846Z 2025-10-20T13:03:22.901Z
8086215 8086215 20251011223230_Njc2g RU001D 2025-10-13T12:07:52.279Z 2025-10-20T13:03:22.248Z
8085649 8085649 20251011202414_a4Wj1 RU001D 2025-10-13T12:06:21.447Z 2025-10-20T13:03:15.556Z
8085192 8085192 20251011183600_U3t0n RU001D 2025-10-13T12:05:09.481Z 2025-10-20T13:02:54.253Z
8085067 8085067 20251011165736_jD50H RU001D 2025-10-13T12:04:46.320Z 2025-10-20T13:02:44.737Z
8085059 8085059 20251011165125_VrEV5 RU001D 2025-10-13T12:04:45.135Z 2025-10-20T13:02:44.676Z
8048041 8048041 20251002212614_vmoR6 RU001D 2025-10-04T12:15:56.195Z 2025-10-11T12:39:36.357Z
8038836 8038836 20251001220914_8bThV RU001D 2025-10-03T12:31:24.798Z 2025-10-10T12:39:53.503Z
8026615 8026615 20250930210126_8VniZ RU001D 2025-10-02T12:21:19.157Z 2025-10-09T12:37:54.834Z
8025687 8025687 20250930184426_RFYy1 RU001D 2025-10-02T12:17:59.831Z 2025-10-09T12:36:59.856Z
8025455 8025455 20250930171352_7YbfB RU001D 2025-10-02T12:16:58.438Z 2025-10-09T12:36:48.268Z
8017595 8017595 20250930000339_B34Jd RU001D 2025-10-01T12:26:24.890Z 2025-10-08T12:42:54.644Z
8017429 8017429 20250929234130_K0BXd RU001D 2025-10-01T12:26:05.840Z 2025-10-08T12:42:49.472Z
8016762 8016762 20250929223902_a0WdS RU001D 2025-10-01T12:24:28.544Z 2025-10-08T12:42:36.532Z
8015773 8015773 20250929194109_emDXO RU001D 2025-10-01T12:21:17.086Z 2025-10-08T12:42:11.610Z
8015520 8015520 20250929183528_mOhp9 RU001D 2025-10-01T12:20:11.737Z 2025-10-08T12:42:09.158Z
8007631 8007631 20250929021016_PfCfY RU001D 2025-09-30T12:28:45.144Z 2025-10-07T13:01:07.224Z
8007295 8007295 20250929015631_QTeb5 RU001D 2025-09-30T12:28:05.703Z 2025-10-07T13:01:03.404Z
8006830 8006830 20250929014054_CaIhv RU001D 2025-09-30T12:27:30.764Z 2025-10-07T13:01:01.303Z
8006481 8006481 20250929013004_HOmpA RU001D 2025-09-30T12:26:57.218Z 2025-10-07T13:00:59.536Z
8005268 8005268 20250929002949_IRp5D RU001D 2025-09-30T12:24:29.646Z 2025-10-07T13:00:52.482Z
8004337 8004337 20250928234520_8KIav RU001D 2025-09-30T12:22:28.333Z 2025-10-07T13:00:46.509Z
8004291 8004291 20250928234103_dOsim RU001D 2025-09-30T12:22:23.551Z 2025-10-07T13:00:46.198Z
8004257 8004257 20250928233926_zEiCA RU001D 2025-09-30T12:22:11.815Z 2025-10-07T13:00:45.964Z
8003285 8003285 20250928224513_VHLK2 RU001D 2025-09-30T12:20:02.139Z 2025-10-07T13:00:38.754Z
8002632 8002632 20250928220001_SLxag RU001D 2025-09-30T12:18:26.814Z 2025-10-07T13:00:33.656Z
8001659 8001659 20250928204846_Zu5kk RU001D 2025-09-30T12:15:59.280Z 2025-10-07T13:00:22.850Z
8001049 8001049 20250928195446_S9uz4 RU001D 2025-09-30T12:14:15.968Z 2025-10-07T13:00:14.371Z
8000286 8000286 20250928175427_zPs9Z RU001D 2025-09-30T12:11:48.914Z 2025-10-07T12:59:52.527Z
7994284 7994284 20250927223346_Ww4Ni RU001D 2025-09-29T12:20:50.453Z 2025-10-05T13:06:51.410Z
7974852 7974852 20250926012201_CjiLl RU001D 2025-09-27T12:14:13.622Z 2025-10-04T13:07:06.288Z

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