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

8,228 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
9626435 9626435 20260408140357_8Aht2 NZ002L 2026-04-09T12:08:21.453Z 2026-04-09T12:08:21.453Z
9626043 9626043 20260408130002_LBWdW NZ002L 2026-04-09T12:07:23.745Z 2026-04-09T12:07:23.745Z
9625904 9625904 20260408122303_JDVGy NZ002L 2026-04-09T12:07:05.266Z 2026-04-09T12:07:05.266Z
9610262 9610262 20260405153019_2Ojdp NZ002L 2026-04-06T12:06:45.052Z 2026-04-09T12:36:42.068Z
9605979 9605979 20260403133937_4A0m0 NZ002L 2026-04-04T12:04:45.412Z 2026-04-09T12:42:05.332Z
9605925 9605925 20260403131432_NtJaX NZ002L 2026-04-04T12:04:29.263Z 2026-04-09T12:42:03.900Z
9605900 9605900 20260403124331_ZsUSF NZ002L 2026-04-04T12:04:23.587Z 2026-04-09T12:42:03.313Z
9605880 9605880 20260403123509_nYFDj NZ002L 2026-04-04T12:04:20.254Z 2026-04-09T12:42:03.056Z
9605404 9605404 20260403094935_FO1SW NZ002L 2026-04-04T12:02:08.933Z 2026-04-09T12:41:21.744Z
9605139 9605139 20260403070510_vS0KH NZ002L 2026-04-04T12:00:53.147Z 2026-04-09T12:41:15.274Z
9604305 9604305 20260402170508_lH0bC NZ002L 2026-04-03T12:06:49.005Z 2026-04-09T12:44:20.043Z
9604285 9604285 20260402165700_4c4hR NZ002L 2026-04-03T12:06:44.642Z 2026-04-09T12:44:19.580Z
9604279 9604279 20260402165402_AhgdJ NZ002L 2026-04-03T12:06:37.300Z 2026-04-09T12:44:19.408Z
9599084 9599084 20260331113214_NLz8R NZ002L 2026-04-01T12:02:19.032Z 2026-04-09T12:46:41.228Z
9598859 9598859 20260331080102_dEHm0 NZ002L 2026-04-01T12:01:20.277Z 2026-04-09T12:46:36.873Z
9598851 9598851 20260331080102_cqQB7 NZ002L 2026-04-01T12:01:19.285Z 2026-04-09T12:46:36.847Z
9598832 9598832 20260331074549_r23AP NZ002L 2026-04-01T12:01:15.001Z 2026-04-09T12:46:36.600Z
9597065 9597065 20260330150902_bFsuf NZ002L 2026-03-31T12:05:35.887Z 2026-04-08T12:43:31.877Z
9596855 9596855 20260330141704_lp2yY NZ002L 2026-03-31T12:05:05.557Z 2026-04-08T12:43:26.117Z
9596374 9596374 20260330122509_sY9v5 NZ002L 2026-03-31T12:04:07.576Z 2026-04-08T12:42:50.762Z
9596166 9596166 20260330113027_QCYwi NZ002L 2026-03-31T12:03:37.856Z 2026-04-08T12:42:42.928Z
9596023 9596023 20260330104514_EPh82 NZ002L 2026-03-31T12:03:09.881Z 2026-04-08T12:42:38.763Z
9591155 9591155 20260328135415_2YwWN NZ002L 2026-03-29T12:03:56.405Z 2026-04-06T12:39:03.370Z
9591114 9591114 20260328132749_USXVL NZ002L 2026-03-29T12:03:51.846Z 2026-04-06T12:39:01.361Z
9587624 9587624 20260327143848_ufxZP NZ002L 2026-03-28T12:05:56.244Z 2026-04-05T12:34:34.154Z
9587563 9587563 20260327140822_Vt783 NZ002L 2026-03-28T12:05:49.783Z 2026-04-05T12:34:31.667Z
9587558 9587558 20260327140646_dMJpl NZ002L 2026-03-28T12:05:49.504Z 2026-04-05T12:34:31.560Z
9587515 9587515 20260327133947_qfVtt NZ002L 2026-03-28T12:05:43.892Z 2026-04-05T12:34:29.755Z
9587499 9587499 20260327132857_5x9XE NZ002L 2026-03-28T12:05:40.671Z 2026-04-05T12:34:28.988Z
9587424 9587424 20260327124013_oTQhw NZ002L 2026-03-28T12:05:29.722Z 2026-04-05T12:34:26.024Z
9587310 9587310 20260327120210_hrhi0 NZ002L 2026-03-28T12:05:15.016Z 2026-04-05T12:34:12.670Z
9587269 9587269 20260327115808_QABwV NZ002L 2026-03-28T12:05:10.237Z 2026-04-05T12:34:10.885Z
9587252 9587252 20260327115441_gyPYk NZ002L 2026-03-28T12:05:08.506Z 2026-04-05T12:34:10.226Z
9587231 9587231 20260327114817_GI2N5 NZ002L 2026-03-28T12:05:04.889Z 2026-04-05T12:34:09.414Z
9587133 9587133 20260327112238_d2dT4 NZ002L 2026-03-28T12:04:51.771Z 2026-04-05T12:34:03.642Z
9586829 9586829 20260327095121_zoNTG NZ002L 2026-03-28T12:04:08.462Z 2026-04-05T12:33:50.758Z
9586564 9586564 20260327082348_YFQ36 NZ002L 2026-03-28T12:03:25.802Z 2026-04-05T12:33:30.615Z
9566624 9566624 20260323135820_akcWL NZ002L 2026-03-24T12:12:13.601Z 2026-03-31T12:27:54.782Z
9566038 9566038 20260323130059_HWWkC NZ002L 2026-03-24T12:11:15.003Z 2026-03-31T12:27:45.176Z
9566007 9566007 20260323125651_27qR9 NZ002L 2026-03-24T12:11:12.044Z 2026-03-31T12:27:44.734Z
9565329 9565329 20260323120107_5HDc2 NZ002L 2026-03-24T12:09:53.819Z 2026-03-31T12:27:33.299Z
9564747 9564747 20260323110626_Gd4tv NZ002L 2026-03-24T12:08:44.585Z 2026-03-31T12:27:14.896Z
9564607 9564607 20260323105539_hHw4P NZ002L 2026-03-24T12:08:27.332Z 2026-03-31T12:27:12.409Z
9564437 9564437 20260323103450_YoGH5 NZ002L 2026-03-24T12:08:04.737Z 2026-03-31T12:27:09.075Z
9563926 9563926 20260323093507_7HN2P NZ002L 2026-03-24T12:07:00.725Z 2026-03-31T12:26:59.208Z
9563867 9563867 20260323092423_5dxwf NZ002L 2026-03-24T12:06:53.737Z 2026-03-31T12:26:58.182Z
9559340 9559340 20260321165834_FBNWP NZ002L 2026-03-23T12:11:02.277Z 2026-03-29T12:20:37.861Z
9558553 9558553 20260322165841_FiqQI NZ002L 2026-03-23T12:06:48.803Z 2026-03-30T12:30:16.579Z
9558549 9558549 20260322165820_Dl9QG NZ002L 2026-03-23T12:06:48.564Z 2026-03-30T12:30:16.546Z
9557772 9557772 20260322145411_OInwy NZ002L 2026-03-23T12:06:09.224Z 2026-03-30T12:29:47.133Z
9557613 9557613 20260322143111_Dcxl1 NZ002L 2026-03-23T12:05:58.973Z 2026-03-30T12:29:43.015Z
9557541 9557541 20260322142309_9z34b NZ002L 2026-03-23T12:05:55.701Z 2026-03-30T12:29:41.266Z
9557421 9557421 20260322135733_VUtBu NZ002L 2026-03-23T12:05:49.617Z 2026-03-30T12:29:37.190Z
9557343 9557343 20260322133947_7zned NZ002L 2026-03-23T12:05:46.723Z 2026-03-30T12:29:34.988Z
9557260 9557260 20260322132223_c919U NZ002L 2026-03-23T12:05:43.385Z 2026-03-30T12:29:32.866Z
9557254 9557254 20260322132216_IoBbk NZ002L 2026-03-23T12:05:43.201Z 2026-03-30T12:29:32.670Z
9557111 9557111 20260322125304_QDjYD NZ002L 2026-03-23T12:05:36.616Z 2026-03-30T12:29:21.558Z
9557033 9557033 20260322123803_Tn1o7 NZ002L 2026-03-23T12:05:29.418Z 2026-03-30T12:29:19.432Z
9556929 9556929 20260322121345_ZHLqt NZ002L 2026-03-23T12:05:21.719Z 2026-03-30T12:29:15.218Z
9556734 9556734 20260322112627_0cZqi NZ002L 2026-03-23T12:05:09.881Z 2026-03-30T12:29:09.364Z
9556300 9556300 20260322095944_m3eCz NZ002L 2026-03-23T12:04:38.239Z 2026-03-30T12:28:56.964Z
9555980 9555980 20260322085946_6j3KR NZ002L 2026-03-23T12:04:13.944Z 2026-03-30T12:28:41.047Z
9550830 9550830 20260320171605_SBxOs NZ002L 2026-03-22T12:25:47.485Z 2026-03-28T12:36:36.367Z
9550413 9550413 20260320163722_OMLjI NZ002L 2026-03-22T12:25:14.034Z 2026-03-28T12:36:30.545Z
9550400 9550400 20260320163626_fc9Sm NZ002L 2026-03-22T12:25:13.332Z 2026-03-28T12:36:30.394Z
9550307 9550307 20260320162941_zQDYb NZ002L 2026-03-22T12:25:07.886Z 2026-03-28T12:36:29.438Z
9549377 9549377 20260320145325_3zvVI NZ002L 2026-03-22T12:23:55.441Z 2026-03-28T12:36:01.920Z
9548549 9548549 20260321151342_rWgxu NZ002L 2026-03-22T12:15:34.072Z 2026-03-29T12:20:27.166Z
9548433 9548433 20260321150437_0bZ3j NZ002L 2026-03-22T12:15:25.028Z 2026-03-29T12:20:26.403Z
9548243 9548243 20260321144437_FFYbn NZ002L 2026-03-22T12:15:06.587Z 2026-03-29T12:20:24.811Z
9547614 9547614 20260321134608_ZMLpN NZ002L 2026-03-22T12:13:59.140Z 2026-03-29T12:20:10.580Z
9547590 9547590 20260321134420_rEbol NZ002L 2026-03-22T12:13:57.078Z 2026-03-29T12:20:10.281Z
9546888 9546888 20260321123600_ztcZd NZ002L 2026-03-22T12:12:37.166Z 2026-03-29T12:20:05.051Z
9546728 9546728 20260321122232_2O7x3 NZ002L 2026-03-22T12:12:17.920Z 2026-03-29T12:20:03.533Z
9546580 9546580 20260321120950_R6YBw NZ002L 2026-03-22T12:12:01.180Z 2026-03-29T12:20:02.367Z
9546546 9546546 20260321120912_3GPTD NZ002L 2026-03-22T12:11:58.328Z 2026-03-29T12:20:02.196Z
9546305 9546305 20260321115036_IqHc5 NZ002L 2026-03-22T12:11:27.777Z 2026-03-29T12:19:49.253Z
9545336 9545336 20260321102243_184D7 NZ002L 2026-03-22T12:09:09.019Z 2026-03-29T12:19:39.314Z
9540489 9540489 20260319155003_l3tYJ NZ002L 2026-03-21T12:27:03.971Z 2026-03-27T12:42:22.714Z
9540183 9540183 20260319141334_hpkii NZ002L 2026-03-21T12:26:25.307Z 2026-03-27T12:42:02.814Z
9540175 9540175 20260319140850_SI7Gh NZ002L 2026-03-21T12:26:24.637Z 2026-03-27T12:42:02.608Z
9540000 9540000 20260319122436_4Yyji NZ002L 2026-03-21T12:25:52.481Z 2026-03-27T12:41:55.441Z
9539974 9539974 20260319120014_Jhpds NZ002L 2026-03-21T12:25:41.512Z 2026-03-27T12:41:53.207Z
9538968 9538968 20260320140039_DkKM1 NZ002L 2026-03-21T12:18:41.154Z 2026-03-28T12:35:55.275Z
9538803 9538803 20260320134710_ibZ4v NZ002L 2026-03-21T12:18:24.685Z 2026-03-28T12:35:52.615Z
9538713 9538713 20260320133745_gprxC NZ002L 2026-03-21T12:18:12.954Z 2026-03-28T12:35:51.768Z
9538566 9538566 20260320132038_pJ6QD NZ002L 2026-03-21T12:17:56.907Z 2026-03-28T12:35:50.044Z
9538414 9538414 20260320130045_ZkIeh NZ002L 2026-03-21T12:17:39.344Z 2026-03-28T12:35:48.201Z
9538307 9538307 20260320125046_yRIgA NZ002L 2026-03-21T12:17:28.074Z 2026-03-28T12:35:45.438Z
9538068 9538068 20260320122958_ZuPsJ NZ002L 2026-03-21T12:17:02.391Z 2026-03-28T12:35:34.371Z
9538009 9538009 20260320122353_hFw2e NZ002L 2026-03-21T12:16:57.112Z 2026-03-28T12:35:33.562Z
9537978 9537978 20260320121927_239Om NZ002L 2026-03-21T12:16:53.408Z 2026-03-28T12:35:33.010Z
9536984 9536984 20260320105614_BSZzt NZ002L 2026-03-21T12:14:50.333Z 2026-03-28T12:35:19.919Z
9536666 9536666 20260320101529_bTe3i NZ002L 2026-03-21T12:14:03.063Z 2026-03-28T12:35:05.152Z
9536476 9536476 20260320095549_SpT8N NZ002L 2026-03-21T12:13:35.181Z 2026-03-28T12:35:02.457Z
9536030 9536030 20260320090138_c5E5w NZ002L 2026-03-21T12:12:24.876Z 2026-03-28T12:34:55.679Z
9535812 9535812 20260320083529_vbwgR NZ002L 2026-03-21T12:11:57.204Z 2026-03-28T12:34:51.732Z
9535802 9535802 20260320083438_Y2x25 NZ002L 2026-03-21T12:11:56.502Z 2026-03-28T12:34:51.525Z
9535759 9535759 20260320083126_qPCP3 NZ002L 2026-03-21T12:11:48.346Z 2026-03-28T12:34:50.719Z
9535706 9535706 20260320082416_b1KBV NZ002L 2026-03-21T12:11:39.121Z 2026-03-28T12:34:49.503Z

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