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 = "NZ003H" 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
8684895 8684895 20251204142803_43T8i NZ003H 2025-12-05T14:04:54.740Z 2025-12-05T14:04:54.740Z
8684100 8684100 20251204104254_0R64V NZ003H 2025-12-05T14:01:56.153Z 2025-12-05T14:01:56.153Z
8684056 8684056 20251204103034_R4UHB NZ003H 2025-12-05T14:01:39.420Z 2025-12-05T14:01:39.420Z
8684051 8684051 20251204103012_f2juJ NZ003H 2025-12-05T14:01:38.985Z 2025-12-05T14:01:38.985Z
8683912 8683912 20251204092032_3b3es NZ003H 2025-12-05T14:01:03.500Z 2025-12-05T14:01:03.500Z
8683904 8683904 20251204091947_pF3FT NZ003H 2025-12-05T14:01:02.424Z 2025-12-05T14:01:02.424Z
8683891 8683891 20251204091703_w36Aq NZ003H 2025-12-05T14:01:00.830Z 2025-12-05T14:01:00.830Z
8683865 8683865 20251204090711_Aunmq NZ003H 2025-12-05T14:00:55.799Z 2025-12-05T14:00:55.799Z
8683808 8683808 20251204083354_a3a2E NZ003H 2025-12-05T14:00:44.760Z 2025-12-05T14:00:44.760Z
8678128 8678128 20251203150042_FBiGI NZ003H 2025-12-04T14:03:36.244Z 2025-12-05T14:14:35.116Z
8672816 8672816 20251201152516_m311B NZ003H 2025-12-03T14:16:37.399Z 2025-12-05T14:25:42.780Z
8672771 8672771 20251201151704_2dx8p NZ003H 2025-12-03T14:16:24.876Z 2025-12-05T14:25:41.563Z
8672760 8672760 20251201151526_tQzbS NZ003H 2025-12-03T14:16:23.606Z 2025-12-05T14:25:41.323Z
8672723 8672723 20251201151051_YxAXP NZ003H 2025-12-03T14:16:19.511Z 2025-12-05T14:25:39.731Z
8672716 8672716 20251201151015_zFNTP NZ003H 2025-12-03T14:16:19.013Z 2025-12-05T14:25:39.652Z
8672675 8672675 20251201150507_xJNEb NZ003H 2025-12-03T14:16:08.818Z 2025-12-05T14:25:38.295Z
8672629 8672629 20251201145540_K58DD NZ003H 2025-12-03T14:16:01.187Z 2025-12-05T14:25:36.810Z
8672603 8672603 20251201145404_IWE3U NZ003H 2025-12-03T14:15:58.847Z 2025-12-05T14:25:36.125Z
8672592 8672592 20251201145054_smS3v NZ003H 2025-12-03T14:15:57.453Z 2025-12-05T14:25:35.740Z
8672529 8672529 20251201144153_G7aZn NZ003H 2025-12-03T14:15:50.446Z 2025-12-05T14:25:33.325Z
8672511 8672511 20251201143927_gGt7f NZ003H 2025-12-03T14:15:49.335Z 2025-12-05T14:25:32.722Z
8672304 8672304 20251201141151_AvPBi NZ003H 2025-12-03T14:15:15.354Z 2025-12-05T14:25:17.095Z
8672256 8672256 20251201140821_Syjkh NZ003H 2025-12-03T14:15:11.113Z 2025-12-05T14:25:15.756Z
8672211 8672211 20251201140249_oV1rZ NZ003H 2025-12-03T14:15:00.778Z 2025-12-05T14:25:12.361Z
8671573 8671573 20251201123534_nSFrV NZ003H 2025-12-03T14:13:02.375Z 2025-12-05T14:24:33.926Z
8670988 8670988 20251201105900_G078k NZ003H 2025-12-03T14:11:00.321Z 2025-12-05T14:23:58.438Z
8670762 8670762 20251201100835_Q39Gb NZ003H 2025-12-03T14:10:01.480Z 2025-12-05T14:23:48.358Z
8670492 8670492 20251201090904_P0Ogq NZ003H 2025-12-03T14:09:00.678Z 2025-12-05T14:23:26.674Z
8641877 8641877 20251128151752_MNdoE NZ003H 2025-11-30T14:17:06.372Z 2025-12-05T14:48:52.609Z
8641828 8641828 20251128151551_RSBU6 NZ003H 2025-11-30T14:17:02.987Z 2025-12-05T14:48:52.109Z
8641724 8641724 20251128151006_27fev NZ003H 2025-11-30T14:16:44.945Z 2025-12-05T14:48:50.895Z
8641662 8641662 20251128150531_TPT20 NZ003H 2025-11-30T14:16:38.469Z 2025-12-05T14:48:50.129Z
8641510 8641510 20251128145720_Ihqcx NZ003H 2025-11-30T14:16:29.655Z 2025-12-05T14:48:44.020Z
8639533 8639533 20251129111651_eCtAv NZ003H 2025-11-30T14:05:14.190Z 2025-12-05T14:38:24.410Z
8639424 8639424 20251129110456_NG30x NZ003H 2025-11-30T14:04:52.462Z 2025-11-30T14:04:52.462Z
8629849 8629849 20251128144112_2jWj8 NZ003H 2025-11-29T14:09:13.316Z 2025-12-05T14:48:22.886Z
8629841 8629841 20251128144058_Fdm1f NZ003H 2025-11-29T14:09:09.370Z 2025-12-05T14:48:22.593Z
8629834 8629834 20251128144044_GgSlZ NZ003H 2025-11-29T14:09:05.115Z 2025-12-05T14:48:22.541Z
8629782 8629782 20251128143809_49KCf NZ003H 2025-11-29T14:09:00.483Z 2025-12-05T14:48:18.744Z
8629771 8629771 20251128143743_SMEgB NZ003H 2025-11-29T14:08:59.992Z 2025-12-05T14:48:18.342Z
8629679 8629679 20251128142806_wGBvW NZ003H 2025-11-29T14:08:52.432Z 2025-12-05T14:48:09.009Z
8629651 8629651 20251128142716_Lb3Sh NZ003H 2025-11-29T14:08:50.444Z 2025-12-05T14:48:08.784Z
8629587 8629587 20251128142018_qGtmU NZ003H 2025-11-29T14:08:43.752Z 2025-12-05T14:48:06.988Z
8629535 8629535 20251128141755_dP6tg NZ003H 2025-11-29T14:08:32.003Z 2025-12-05T14:48:06.319Z
8629501 8629501 20251128141153_6Ktbc NZ003H 2025-11-29T14:08:29.742Z 2025-12-05T14:48:05.576Z
8629347 8629347 20251128140045_fWlNw NZ003H 2025-11-29T14:08:17.918Z 2025-12-05T14:47:59.268Z
8629199 8629199 20251128134901_tFmZB NZ003H 2025-11-29T14:08:06.578Z 2025-12-05T14:47:57.220Z
8629100 8629100 20251128134345_whjxe NZ003H 2025-11-29T14:07:51.082Z 2025-12-05T14:47:55.336Z
8629059 8629059 20251128134128_QI5VY NZ003H 2025-11-29T14:07:46.035Z 2025-12-05T14:47:54.895Z
8629011 8629011 20251128133453_G1aDv NZ003H 2025-11-29T14:07:41.404Z 2025-12-05T14:47:54.344Z
8628965 8628965 20251128133135_Eejce NZ003H 2025-11-29T14:07:38.172Z 2025-12-05T14:47:53.773Z
8628857 8628857 20251128131438_9IJZ1 NZ003H 2025-11-29T14:07:14.499Z 2025-12-05T14:47:51.175Z
8628716 8628716 20251128130602_6D5ZU NZ003H 2025-11-29T14:06:59.767Z 2025-12-05T14:47:48.972Z
8628685 8628685 20251128130526_iemvs NZ003H 2025-11-29T14:06:57.457Z 2025-11-29T14:06:57.457Z
8628634 8628634 20251128130123_ntUyU NZ003H 2025-11-29T14:06:52.941Z 2025-12-05T14:47:47.591Z
8628602 8628602 20251128125926_iwjG5 NZ003H 2025-11-29T14:06:50.351Z 2025-12-05T14:47:46.909Z
8628522 8628522 20251128125332_9Dt2n NZ003H 2025-11-29T14:06:29.474Z 2025-12-05T14:47:44.739Z
8628287 8628287 20251128123250_tSBlO NZ003H 2025-11-29T14:05:49.533Z 2025-12-05T14:47:40.628Z
8628122 8628122 20251128121531_tzCZ3 NZ003H 2025-11-29T14:05:31.118Z 2025-12-05T14:47:14.445Z
8628025 8628025 20251128120834_QBAs2 NZ003H 2025-11-29T14:05:08.166Z 2025-12-05T14:47:12.480Z
8628011 8628011 20251128120449_aKfa9 NZ003H 2025-11-29T14:05:06.426Z 2025-12-05T14:47:11.995Z
8627986 8627986 20251128120121_6V8CK NZ003H 2025-11-29T14:05:02.770Z 2025-12-05T14:47:11.437Z
8627962 8627962 20251128115751_wYpb5 NZ003H 2025-11-29T14:05:01.123Z 2025-12-05T14:47:11.090Z
8627941 8627941 20251128115426_OKGj2 NZ003H 2025-11-29T14:04:58.004Z 2025-12-05T14:47:10.622Z
8627907 8627907 20251128115059_XGswY NZ003H 2025-11-29T14:04:52.986Z 2025-12-05T14:47:08.207Z
8627851 8627851 20251128114509_mI3Xp NZ003H 2025-11-29T14:04:37.328Z 2025-12-05T14:47:07.323Z
8627834 8627834 20251128114338_2qmRL NZ003H 2025-11-29T14:04:35.986Z 2025-12-05T14:47:06.979Z
8627817 8627817 20251128113919_7uHH3 NZ003H 2025-11-29T14:04:34.048Z 2025-12-05T14:47:06.632Z
8627693 8627693 20251128112948_ApuGC NZ003H 2025-11-29T14:04:18.438Z 2025-12-05T14:47:04.963Z
8627573 8627573 20251128111514_gR2eW NZ003H 2025-11-29T14:04:00.207Z 2025-12-05T14:47:02.350Z
8627548 8627548 20251128111218_niA3X NZ003H 2025-11-29T14:03:56.925Z 2025-12-05T14:47:01.682Z
8627391 8627391 20251128105510_vuy8a NZ003H 2025-11-29T14:03:28.474Z 2025-12-05T14:46:58.569Z
8627365 8627365 20251128105402_lhefE NZ003H 2025-11-29T14:03:25.783Z 2025-12-05T14:46:58.203Z
8627308 8627308 20251128104641_HIYFn NZ003H 2025-11-29T14:03:18.549Z 2025-12-05T14:46:57.024Z
8627246 8627246 20251128104032_PjtRv NZ003H 2025-11-29T14:03:08.087Z 2025-12-05T14:46:56.337Z
8627238 8627238 20251128103948_BYgeV NZ003H 2025-11-29T14:03:07.377Z 2025-12-05T14:46:56.244Z
8627125 8627125 20251128102507_dAp2s NZ003H 2025-11-29T14:02:46.166Z 2025-12-05T14:46:53.669Z
8627009 8627009 20251128101137_y3hGJ NZ003H 2025-11-29T14:02:17.332Z 2025-12-05T14:46:32.217Z
8626957 8626957 20251128100330_EdZBJ NZ003H 2025-11-29T14:02:09.057Z 2025-12-05T14:46:24.926Z
8626690 8626690 20251128092043_UCOrG NZ003H 2025-11-29T14:01:11.348Z 2025-12-05T14:46:16.633Z
8626538 8626538 20251128085701_dJVKa NZ003H 2025-11-29T14:00:40.353Z 2025-12-05T14:46:12.819Z
8626492 8626492 20251128084806_EY2Lx NZ003H 2025-11-29T14:00:33.360Z 2025-12-05T14:46:11.635Z
8626465 8626465 20251128084638_GUY9X NZ003H 2025-11-29T14:00:24.111Z 2025-12-05T14:46:11.264Z
8576245 8576245 20251122144009_r0q6g NZ003H 2025-11-24T14:05:15.489Z 2025-12-01T15:18:34.599Z
8576223 8576223 20251122143618_iLmN3 NZ003H 2025-11-24T14:05:12.582Z 2025-12-01T15:18:34.372Z
8576092 8576092 20251122141057_S3nz5 NZ003H 2025-11-24T14:04:50.531Z 2025-12-01T15:18:33.090Z
8576082 8576082 20251122140923_EYydi NZ003H 2025-11-24T14:04:48.864Z 2025-12-01T15:18:32.977Z
8576076 8576076 20251122140838_1f5FG NZ003H 2025-11-24T14:04:47.782Z 2025-12-01T15:18:32.931Z
8576015 8576015 20251122140044_3Hg4Z NZ003H 2025-11-24T14:04:39.432Z 2025-12-01T15:18:32.454Z
8575991 8575991 20251122135820_4Yi4V NZ003H 2025-11-24T14:04:37.434Z 2025-12-01T15:18:32.298Z
8575952 8575952 20251122135557_6Mrn8 NZ003H 2025-11-24T14:04:32.697Z 2025-12-01T15:18:31.968Z
8575855 8575855 20251122134146_kl3dN NZ003H 2025-11-24T14:04:16.180Z 2025-12-01T15:18:31.307Z
8575783 8575783 20251122133411_HCPmb NZ003H 2025-11-24T14:04:05.285Z 2025-12-01T15:18:30.693Z
8575230 8575230 20251122120044_S27Nl NZ003H 2025-11-24T14:02:30.695Z 2025-12-01T15:18:05.757Z
8575144 8575144 20251122114818_Ft3Wr NZ003H 2025-11-24T14:02:17.133Z 2025-12-01T15:17:56.069Z
8575049 8575049 20251122113114_sQe12 NZ003H 2025-11-24T14:01:55.966Z 2025-12-01T15:17:50.039Z
8575009 8575009 20251122112304_PijZ2 NZ003H 2025-11-24T14:01:48.416Z 2025-12-01T15:17:47.288Z
8574988 8574988 20251122111808_US770 NZ003H 2025-11-24T14:01:39.626Z 2025-12-01T15:17:44.877Z
8574779 8574779 20251122103843_kPgfG NZ003H 2025-11-24T14:00:57.440Z 2025-12-01T15:17:25.624Z
8574736 8574736 20251122103234_WRedh NZ003H 2025-11-24T14:00:49.555Z 2025-12-01T15:17:24.838Z

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