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

7,653 rows where station_code = "NZ002L" 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
9270676 9270676 20260128162240_TebOj NZ002L 2026-01-29T14:13:17.747Z 2026-01-29T14:13:17.747Z
9270448 9270448 20260128155008_ZBeFv NZ002L 2026-01-29T14:12:18.312Z 2026-01-29T14:12:18.312Z
9270231 9270231 20260128151845_iBDIW NZ002L 2026-01-29T14:11:22.545Z 2026-01-29T14:11:22.545Z
9270126 9270126 20260128145826_2Npm8 NZ002L 2026-01-29T14:10:56.995Z 2026-01-29T14:10:56.995Z
9269997 9269997 20260128144245_pzPgu NZ002L 2026-01-29T14:10:29.513Z 2026-01-29T14:10:29.513Z
9269865 9269865 20260128142543_y0Cs4 NZ002L 2026-01-29T14:09:55.041Z 2026-01-29T14:09:55.041Z
9269681 9269681 20260128135451_eRfj7 NZ002L 2026-01-29T14:09:04.026Z 2026-01-29T14:09:04.026Z
9269317 9269317 20260128130214_I55vX NZ002L 2026-01-29T14:07:27.623Z 2026-01-29T14:07:27.623Z
9268660 9268660 20260128110008_tCrC2 NZ002L 2026-01-29T14:04:16.544Z 2026-01-29T14:04:16.544Z
9268618 9268618 20260128105457_GNwYo NZ002L 2026-01-29T14:04:01.749Z 2026-01-29T14:04:01.749Z
9268586 9268586 20260128104800_jRx1Q NZ002L 2026-01-29T14:03:52.991Z 2026-01-29T14:03:52.991Z
9268515 9268515 20260128104051_ePKU4 NZ002L 2026-01-29T14:03:28.394Z 2026-01-29T14:03:28.394Z
9268443 9268443 20260128102127_tCPYm NZ002L 2026-01-29T14:03:06.350Z 2026-01-29T14:03:06.350Z
9268417 9268417 20260128101030_01CVp NZ002L 2026-01-29T14:02:54.117Z 2026-01-29T14:02:54.117Z
9268265 9268265 20260128093517_SyuZB NZ002L 2026-01-29T14:02:08.541Z 2026-01-29T14:02:08.541Z
9265991 9265991 20260127163011_hAN8g NZ002L 2026-01-28T14:12:00.678Z 2026-01-29T14:30:24.809Z
9265797 9265797 20260127160124_WdIX4 NZ002L 2026-01-28T14:11:22.558Z 2026-01-29T14:30:24.678Z
9265274 9265274 20260127145408_gKI3H NZ002L 2026-01-28T14:09:43.364Z 2026-01-29T14:30:24.518Z
9265199 9265199 20260127143613_7ORjC NZ002L 2026-01-28T14:09:25.642Z 2026-01-29T14:30:24.499Z
9265195 9265195 20260127143420_Xk2Sr NZ002L 2026-01-28T14:09:25.007Z 2026-01-29T14:30:24.498Z
9265176 9265176 20260127143118_X62ga NZ002L 2026-01-28T14:09:20.502Z 2026-01-29T14:30:24.494Z
9265121 9265121 20260127142301_t6Tlw NZ002L 2026-01-28T14:09:09.662Z 2026-01-29T14:30:24.452Z
9264970 9264970 20260127134424_5YX1s NZ002L 2026-01-28T14:08:27.111Z 2026-01-29T14:30:24.403Z
9264948 9264948 20260127134037_MlOYJ NZ002L 2026-01-28T14:08:20.580Z 2026-01-29T14:30:24.397Z
9264635 9264635 20260127125117_roMKc NZ002L 2026-01-28T14:06:58.447Z 2026-01-29T14:30:24.234Z
9257816 9257816 20260125160140_EEJAr NZ002L 2026-01-26T14:07:50.637Z 2026-01-29T14:37:42.942Z
9257692 9257692 20260125152740_qDZ28 NZ002L 2026-01-26T14:07:18.644Z 2026-01-29T14:37:35.454Z
9257523 9257523 20260125141829_CtWQl NZ002L 2026-01-26T14:06:06.137Z 2026-01-29T14:37:25.579Z
9257351 9257351 20260125130050_wSqjM NZ002L 2026-01-26T14:05:02.407Z 2026-01-29T14:37:06.842Z
9257012 9257012 20260125113430_l4PC7 NZ002L 2026-01-26T14:03:10.719Z 2026-01-29T14:36:41.545Z
9256821 9256821 20260125103609_2RGm0 NZ002L 2026-01-26T14:02:09.120Z 2026-01-29T14:36:25.826Z
9253819 9253819 20260124150004_3Ug8P NZ002L 2026-01-25T14:04:32.765Z 2026-01-29T14:41:33.420Z
9253816 9253816 20260124145843_9B3Jt NZ002L 2026-01-25T14:04:32.301Z 2026-01-29T14:41:33.248Z
9253741 9253741 20260124142027_oJc2W NZ002L 2026-01-25T14:04:12.405Z 2026-01-29T14:41:23.006Z
9253672 9253672 20260124133438_FruV3 NZ002L 2026-01-25T14:03:53.472Z 2026-01-29T14:41:15.448Z
9253547 9253547 20260124123746_3TuJ3 NZ002L 2026-01-25T14:03:15.544Z 2026-01-29T14:40:56.952Z
9253510 9253510 20260124121938_L0CpB NZ002L 2026-01-25T14:03:04.513Z 2026-01-29T14:40:54.251Z
9250384 9250384 20260123141044_7ErrH NZ002L 2026-01-24T14:02:37.363Z 2026-01-29T14:45:29.287Z
9250084 9250084 20260123101018_fypz1 NZ002L 2026-01-24T14:01:04.365Z 2026-01-29T14:44:57.789Z
9245749 9245749 20260122141111_NCgUs NZ002L 2026-01-23T14:03:17.272Z 2026-01-29T14:50:08.303Z
9245528 9245528 20260122125420_6ZVsg NZ002L 2026-01-23T14:02:17.943Z 2026-01-29T14:49:45.339Z
9245508 9245508 20260122125030_ECx8D NZ002L 2026-01-23T14:02:14.860Z 2026-01-29T14:49:44.808Z
9221520 9221520 20260118155026_6bz5H NZ002L 2026-01-19T14:08:10.303Z 2026-01-27T15:00:29.206Z
9221399 9221399 20260118153409_0CEbN NZ002L 2026-01-19T14:07:48.826Z 2026-01-27T15:00:16.247Z
9220943 9220943 20260118142122_rl1M3 NZ002L 2026-01-19T14:06:14.388Z 2026-01-27T14:59:47.207Z
9216065 9216065 20260116114651_SEAGR NZ002L 2026-01-17T14:27:47.798Z 2026-01-24T15:15:25.166Z
9215944 9215944 20260116112721_pZTzn NZ002L 2026-01-17T14:27:19.955Z 2026-01-24T15:15:21.163Z
9215867 9215867 20260116111600_RC3Jo NZ002L 2026-01-17T14:27:07.758Z 2026-01-24T15:15:15.944Z
9215857 9215857 20260116111448_L9dsq NZ002L 2026-01-17T14:27:06.348Z 2026-01-24T15:15:15.560Z
9215817 9215817 20260116110411_UhH3X NZ002L 2026-01-17T14:27:00.060Z 2026-01-24T15:15:14.322Z
9215792 9215792 20260116110151_Mm0e4 NZ002L 2026-01-17T14:26:52.584Z 2026-01-24T15:15:13.447Z
9215562 9215562 20260116103056_jK9ME NZ002L 2026-01-17T14:26:08.679Z 2026-01-24T15:15:03.400Z
9215394 9215394 20260116100442_6tHQW NZ002L 2026-01-17T14:25:27.206Z 2026-01-24T15:14:44.160Z
9215336 9215336 20260116095655_qJnIU NZ002L 2026-01-17T14:25:14.329Z 2026-01-24T15:14:42.013Z
9215313 9215313 20260116095354_Y9TgM NZ002L 2026-01-17T14:25:09.826Z 2026-01-24T15:14:40.970Z
9215049 9215049 20260116090341_hh2YP NZ002L 2026-01-17T14:24:11.417Z 2026-01-24T15:14:28.033Z
9215014 9215014 20260116085944_wDjva NZ002L 2026-01-17T14:24:05.770Z 2026-01-24T15:14:26.888Z
9210993 9210993 20260116142907_UrkPv NZ002L 2026-01-17T14:03:43.775Z 2026-01-25T14:57:13.751Z
9210942 9210942 20260116141314_L3Sjx NZ002L 2026-01-17T14:03:29.353Z 2026-01-25T14:57:12.422Z
9197515 9197515 20260113112751_V9wgi NZ002L 2026-01-14T14:23:17.050Z 2026-01-21T15:06:19.441Z
9193209 9193209 20260112091853_XIdce NZ002L 2026-01-13T14:30:41.976Z 2026-01-20T15:24:38.321Z
9192173 9192173 20260112121056_jBYcA NZ002L 2026-01-13T14:27:40.420Z 2026-01-20T15:26:12.032Z
9192093 9192093 20260112120445_bn4zY NZ002L 2026-01-13T14:27:25.435Z 2026-01-20T15:25:58.902Z
9191973 9191973 20260112115704_KnkJy NZ002L 2026-01-13T14:27:06.246Z 2026-01-20T15:25:53.876Z
9191884 9191884 20260112114902_U7Mi4 NZ002L 2026-01-13T14:26:45.889Z 2026-01-20T15:25:50.276Z
9191584 9191584 20260112112246_RA8w5 NZ002L 2026-01-13T14:25:48.664Z 2026-01-20T15:25:39.583Z
9191379 9191379 20260112110223_9VGt4 NZ002L 2026-01-13T14:25:12.438Z 2026-01-20T15:25:22.699Z
9191208 9191208 20260112104549_zFXDr NZ002L 2026-01-13T14:24:44.065Z 2026-01-20T15:25:14.605Z
9191149 9191149 20260112103957_QTX3b NZ002L 2026-01-13T14:24:33.849Z 2026-01-20T15:25:12.164Z
9190633 9190633 20260112093133_VSq2q NZ002L 2026-01-13T14:22:55.347Z 2026-01-20T15:24:41.369Z
9190510 9190510 20260112091529_NwhYC NZ002L 2026-01-13T14:22:29.819Z 2026-01-20T15:24:36.674Z
9190483 9190483 20260112091117_tufl5 NZ002L 2026-01-13T14:22:23.788Z 2026-01-20T15:24:35.138Z
9187113 9187113 20260111151511_0ddHf NZ002L 2026-01-13T14:05:32.116Z 2026-01-20T15:20:00.941Z
9184861 9184861 20260111122900_YXGfJ NZ002L 2026-01-12T14:21:46.782Z 2026-01-19T15:21:18.916Z
9184845 9184845 20260111122804_W2aDS NZ002L 2026-01-12T14:21:44.380Z 2026-01-12T14:21:44.380Z
9184787 9184787 20260111122007_bzUvm NZ002L 2026-01-12T14:21:35.446Z 2026-01-19T15:21:13.631Z
9184564 9184564 20260111115141_lbBhF NZ002L 2026-01-12T14:21:03.672Z 2026-01-19T15:21:04.518Z
9184204 9184204 20260111105621_iIEE2 NZ002L 2026-01-12T14:19:56.765Z 2026-01-19T15:20:27.302Z
9184072 9184072 20260111103842_mch15 NZ002L 2026-01-12T14:19:36.442Z 2026-01-19T15:20:21.100Z
9184004 9184004 20260111103505_23KkC NZ002L 2026-01-12T14:19:25.547Z 2026-01-19T15:20:19.532Z
9183725 9183725 20260111100645_D2WJP NZ002L 2026-01-12T14:18:40.309Z 2026-01-19T15:20:09.748Z
9183700 9183700 20260111100208_tmsDU NZ002L 2026-01-12T14:18:35.255Z 2026-01-19T15:20:08.704Z
9179269 9179269 20260111151459_Fw793 NZ002L 2026-01-12T14:00:56.272Z 2026-01-20T15:20:00.561Z
9179123 9179123 20260111141903_TL3Ae NZ002L 2026-01-12T14:00:21.764Z 2026-01-20T15:19:32.133Z
9178992 9178992 20260110123127_MCe1X NZ002L 2026-01-11T14:16:15.033Z 2026-01-18T15:10:38.811Z
9178960 9178960 20260110143512_Glyrr NZ002L 2026-01-11T14:16:07.966Z 2026-01-18T15:11:26.399Z
9178955 9178955 20260110143359_GmUGV NZ002L 2026-01-11T14:16:07.693Z 2026-01-18T15:11:26.294Z
9178905 9178905 20260110142728_6UzB4 NZ002L 2026-01-11T14:15:58.856Z 2026-01-18T15:11:24.043Z
9178870 9178870 20260110142123_OqNdw NZ002L 2026-01-11T14:15:55.003Z 2026-01-18T15:11:21.872Z
9178847 9178847 20260110142021_3x2v3 NZ002L 2026-01-11T14:15:50.977Z 2026-01-18T15:11:20.465Z
9178771 9178771 20260110140932_31YF6 NZ002L 2026-01-11T14:15:42.965Z 2026-01-18T15:11:16.820Z
9178437 9178437 20260110130840_TtONF NZ002L 2026-01-11T14:14:53.824Z 2026-01-18T15:10:50.925Z
9178321 9178321 20260110124848_ti4Jc NZ002L 2026-01-11T14:14:35.799Z 2026-01-18T15:10:44.439Z
9178021 9178021 20260110120021_MvvzH NZ002L 2026-01-11T14:13:48.229Z 2026-01-18T15:10:21.532Z
9177842 9177842 20260110113000_4io2A NZ002L 2026-01-11T14:13:16.819Z 2026-01-18T15:10:11.601Z
9177790 9177790 20260110111826_zKRGS NZ002L 2026-01-11T14:13:02.420Z 2026-01-18T15:10:08.750Z
9177368 9177368 20260110093330_rXqaf NZ002L 2026-01-11T14:11:46.607Z 2026-01-18T15:09:39.818Z
9177280 9177280 20260110090556_5oS1o NZ002L 2026-01-11T14:11:31.196Z 2026-01-18T15:09:35.238Z
9174273 9174273 20260110160055_IJsuA NZ002L 2026-01-11T14:01:58.520Z 2026-01-19T15:14:46.659Z
9174191 9174191 20260110155059_s2BYS NZ002L 2026-01-11T14:01:42.920Z 2026-01-19T15:14:41.071Z

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