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

387 rows where station_code = "NZ005R" 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
9270567 9270567 20260128160159_c3uzd NZ005R 2026-01-29T14:12:47.477Z 2026-01-29T14:12:47.477Z
9270475 9270475 20260128155401_y4Aw9 NZ005R 2026-01-29T14:12:22.885Z 2026-01-29T14:12:22.885Z
9270364 9270364 20260128153945_SwLuL NZ005R 2026-01-29T14:11:53.947Z 2026-01-29T14:11:53.947Z
9270352 9270352 20260128153515_WCJpy NZ005R 2026-01-29T14:11:51.125Z 2026-01-29T14:11:51.125Z
9270328 9270328 20260128153202_20sjI NZ005R 2026-01-29T14:11:46.589Z 2026-01-29T14:11:46.589Z
9270313 9270313 20260128153030_nBdjr NZ005R 2026-01-29T14:11:43.759Z 2026-01-29T14:11:43.759Z
9270295 9270295 20260128152819_LUaQa NZ005R 2026-01-29T14:11:39.884Z 2026-01-29T14:11:39.884Z
9269967 9269967 20260128143811_iUD6O NZ005R 2026-01-29T14:10:21.600Z 2026-01-29T14:10:21.600Z
9269913 9269913 20260128143111_iutBm NZ005R 2026-01-29T14:10:12.506Z 2026-01-29T14:10:12.506Z
9269607 9269607 20260128134414_zlQ5x NZ005R 2026-01-29T14:08:43.020Z 2026-01-29T14:08:43.020Z
9269560 9269560 20260128133318_QJKix NZ005R 2026-01-29T14:08:29.376Z 2026-01-29T14:08:29.376Z
9269533 9269533 20260128132957_sW7vn NZ005R 2026-01-29T14:08:23.996Z 2026-01-29T14:08:23.996Z
9269478 9269478 20260128132557_ROZ3X NZ005R 2026-01-29T14:08:09.374Z 2026-01-29T14:08:09.374Z
9269424 9269424 20260128131547_GHHEx NZ005R 2026-01-29T14:07:56.539Z 2026-01-29T14:07:56.539Z
9269190 9269190 20260128124421_TNs2h NZ005R 2026-01-29T14:06:55.937Z 2026-01-29T14:06:55.937Z
9269074 9269074 20260128121804_ueZO8 NZ005R 2026-01-29T14:06:18.700Z 2026-01-29T14:06:18.700Z
9269038 9269038 20260128120815_d8i0F NZ005R 2026-01-29T14:06:07.295Z 2026-01-29T14:06:07.295Z
9269035 9269035 20260128120703_n3uZT NZ005R 2026-01-29T14:06:06.582Z 2026-01-29T14:06:06.582Z
9268985 9268985 20260128115724_MmjOk NZ005R 2026-01-29T14:05:51.350Z 2026-01-29T14:05:51.350Z
9268970 9268970 20260128115534_M1CTq NZ005R 2026-01-29T14:05:46.082Z 2026-01-29T14:05:46.082Z
9268840 9268840 20260128113206_nEz36 NZ005R 2026-01-29T14:05:08.842Z 2026-01-29T14:05:08.842Z
9268835 9268835 20260128113126_wqLAJ NZ005R 2026-01-29T14:05:07.313Z 2026-01-29T14:05:07.313Z
9268684 9268684 20260128110140_rzfDp NZ005R 2026-01-29T14:04:20.090Z 2026-01-29T14:04:20.090Z
9261963 9261963 20260126145959_9xQHm NZ005R 2026-01-27T14:06:48.413Z 2026-01-29T14:33:20.894Z
9261895 9261895 20260126142733_vmA5k NZ005R 2026-01-27T14:06:17.361Z 2026-01-29T14:33:14.591Z
9257343 9257343 20260125125901_uql9G NZ005R 2026-01-26T14:04:53.315Z 2026-01-29T14:37:06.474Z
9253866 9253866 20260124152200_Ra8rc NZ005R 2026-01-25T14:04:44.642Z 2026-01-29T14:41:43.902Z
9253834 9253834 20260124150743_5kN0s NZ005R 2026-01-25T14:04:36.966Z 2026-01-29T14:41:40.634Z
9253804 9253804 20260124145211_vtfL7 NZ005R 2026-01-25T14:04:29.670Z 2026-01-29T14:41:31.986Z
9253694 9253694 20260124135207_CvXsz NZ005R 2026-01-25T14:03:59.117Z 2026-01-29T14:41:17.488Z
9253610 9253610 20260124130628_1sOW2 NZ005R 2026-01-25T14:03:31.194Z 2026-01-29T14:41:03.473Z
9253608 9253608 20260124130053_DOltW NZ005R 2026-01-25T14:03:30.477Z 2026-01-29T14:41:02.701Z
9253582 9253582 20260124125137_ZjGpA NZ005R 2026-01-25T14:03:24.298Z 2026-01-29T14:40:59.165Z
9250520 9250520 20260123155506_jPi6T NZ005R 2026-01-24T14:03:21.885Z 2026-01-29T14:45:45.039Z
9250506 9250506 20260123154602_UZUlH NZ005R 2026-01-24T14:03:17.300Z 2026-01-29T14:45:42.826Z
9250372 9250372 20260123140020_JPQyO NZ005R 2026-01-24T14:02:33.571Z 2026-01-29T14:45:27.505Z
9250035 9250035 20260123095116_PVAkb NZ005R 2026-01-24T14:00:44.601Z 2026-01-29T14:44:54.552Z
9250016 9250016 20260123093931_mMa42 NZ005R 2026-01-24T14:00:38.659Z 2026-01-29T14:44:47.960Z
9249833 9249833 20260122091646_MqSMo NZ005R 2026-01-23T14:16:20.537Z 2026-01-29T14:59:00.111Z
9249795 9249795 20260122085056_Y6dSq NZ005R 2026-01-23T14:16:15.224Z 2026-01-29T14:58:57.718Z
9245904 9245904 20260122152342_wtzYr NZ005R 2026-01-23T14:03:59.672Z 2026-01-29T14:50:21.696Z
9245772 9245772 20260122142100_rjkLZ NZ005R 2026-01-23T14:03:26.833Z 2026-01-29T14:50:10.602Z
9245690 9245690 20260122134608_qaEvj NZ005R 2026-01-23T14:03:00.196Z 2026-01-29T14:49:57.510Z
9245684 9245684 20260122134309_g691r NZ005R 2026-01-23T14:02:58.983Z 2026-01-29T14:49:57.070Z
9245626 9245626 20260122132507_htdwB NZ005R 2026-01-23T14:02:45.607Z 2026-01-29T14:49:51.486Z
9245510 9245510 20260122125103_AU8fa NZ005R 2026-01-23T14:02:15.304Z 2026-01-29T14:49:44.947Z
9245301 9245301 20260122114312_myOPa NZ005R 2026-01-23T14:01:23.856Z 2026-01-29T14:49:22.547Z
9245288 9245288 20260122113656_i8gt3 NZ005R 2026-01-23T14:01:20.993Z 2026-01-29T14:49:21.210Z
9245275 9245275 20260122113334_tX3Jr NZ005R 2026-01-23T14:01:17.458Z 2026-01-29T14:49:20.235Z
9245203 9245203 20260122111326_9Ph8A NZ005R 2026-01-23T14:01:00.616Z 2026-01-29T14:49:14.341Z
9245092 9245092 20260122100752_S23D9 NZ005R 2026-01-23T14:00:29.286Z 2026-01-29T14:48:58.154Z
9245088 9245088 20260122100202_m9Yxc NZ005R 2026-01-23T14:00:28.241Z 2026-01-29T14:48:57.248Z
9245079 9245079 20260122095714_HKJXB NZ005R 2026-01-23T14:00:25.955Z 2026-01-29T14:48:56.420Z
9245069 9245069 20260122095224_RqKw2 NZ005R 2026-01-23T14:00:23.356Z 2026-01-29T14:48:55.835Z
9245061 9245061 20260122094930_JA3bJ NZ005R 2026-01-23T14:00:20.919Z 2026-01-29T14:48:55.169Z
9245041 9245041 20260122093501_qGDD2 NZ005R 2026-01-23T14:00:16.253Z 2026-01-29T14:48:53.441Z
9197181 9197181 20260113102330_ftxuM NZ005R 2026-01-14T14:21:47.500Z 2026-01-21T15:06:14.914Z
9185295 9185295 20260111135221_EYuhq NZ005R 2026-01-12T14:22:59.084Z 2026-01-19T15:22:04.948Z
9185271 9185271 20260111134322_Nw6DY NZ005R 2026-01-12T14:22:55.816Z 2026-01-19T15:22:01.673Z
9185240 9185240 20260111133736_nU2TM NZ005R 2026-01-12T14:22:51.762Z 2026-01-19T15:22:00.019Z
9185070 9185070 20260111130355_8vAud NZ005R 2026-01-12T14:22:21.634Z 2026-01-19T15:21:47.946Z
9185062 9185062 20260111130314_HYXre NZ005R 2026-01-12T14:22:20.352Z 2026-01-19T15:21:47.643Z
9184851 9184851 20260111122811_U09gb NZ005R 2026-01-12T14:21:44.905Z 2026-01-19T15:21:18.353Z
9184513 9184513 20260111114608_4Z5Gd NZ005R 2026-01-12T14:20:48.273Z 2026-01-19T15:21:01.956Z
9184494 9184494 20260111114430_fnDHQ NZ005R 2026-01-12T14:20:44.807Z 2026-01-19T15:21:01.322Z
9184358 9184358 20260111111709_5PaEJ NZ005R 2026-01-12T14:20:22.601Z 2026-01-19T15:20:44.104Z
9184342 9184342 20260111111416_ML03L NZ005R 2026-01-12T14:20:17.926Z 2026-01-19T15:20:35.144Z
9184272 9184272 20260111110248_uLwRY NZ005R 2026-01-12T14:20:09.203Z 2026-01-19T15:20:31.191Z
9183907 9183907 20260111102709_UgQWK NZ005R 2026-01-12T14:19:10.907Z 2026-01-19T15:20:16.411Z
9183427 9183427 20260111092936_XzOHG NZ005R 2026-01-12T14:17:46.770Z 2026-01-19T15:19:38.961Z
9173555 9173555 20260109144639_8gc7o NZ005R 2026-01-10T14:18:01.244Z 2026-01-17T15:26:49.612Z
9173255 9173255 20260109132808_HQZ1p NZ005R 2026-01-10T14:16:52.516Z 2026-01-17T15:26:24.854Z
9173046 9173046 20260109124641_6YyeM NZ005R 2026-01-10T14:15:55.624Z 2026-01-17T15:26:12.973Z
9172812 9172812 20260109120110_kzJPg NZ005R 2026-01-10T14:14:55.108Z 2026-01-17T15:26:00.566Z
9172681 9172681 20260109112735_KQjCq NZ005R 2026-01-10T14:14:25.913Z 2026-01-17T15:25:46.962Z
9172651 9172651 20260109112157_gxr37 NZ005R 2026-01-10T14:14:19.595Z 2026-01-17T15:25:45.772Z
9172603 9172603 20260109111404_eLnuu NZ005R 2026-01-10T14:14:10.046Z 2026-01-17T15:25:43.800Z
9172263 9172263 20260109094403_o6mSr NZ005R 2026-01-10T14:12:30.211Z 2026-01-17T15:25:14.794Z
9170408 9170408 20260109150953_RACuN NZ005R 2026-01-10T14:00:21.843Z 2026-01-18T15:06:19.907Z
9169653 9169653 20260108151508_rQwSe NZ005R 2026-01-09T14:14:13.970Z 2026-01-16T15:14:23.024Z
9169643 9169643 20260108151429_wlOUO NZ005R 2026-01-09T14:14:11.282Z 2026-01-16T15:14:22.565Z
9169581 9169581 20260108150129_c0VGb NZ005R 2026-01-09T14:14:01.398Z 2026-01-16T15:14:18.146Z
9168903 9168903 20260108123855_jIZ17 NZ005R 2026-01-09T14:12:18.979Z 2026-01-16T15:13:19.722Z
9168334 9168334 20260108103935_fSy5R NZ005R 2026-01-09T14:10:52.868Z 2026-01-16T15:12:31.019Z
9165165 9165165 20260107151320_Rl3sm NZ005R 2026-01-08T14:15:35.031Z 2026-01-13T15:05:31.999Z
9165067 9165067 20260107150118_KsQVF NZ005R 2026-01-08T14:15:18.079Z 2026-01-13T15:05:27.268Z
9164774 9164774 20260107142444_sxcxA NZ005R 2026-01-08T14:14:19.265Z 2026-01-13T15:05:03.638Z
9164546 9164546 20260107134146_fhKyF NZ005R 2026-01-08T14:13:33.433Z 2026-01-13T15:04:51.079Z
9164532 9164532 20260107133800_OpxGY NZ005R 2026-01-08T14:13:30.183Z 2026-01-13T15:04:50.069Z
9164511 9164511 20260107133023_qQyG3 NZ005R 2026-01-08T14:13:27.289Z 2026-01-13T15:04:41.098Z
9164385 9164385 20260107125843_n6Zgw NZ005R 2026-01-08T14:12:58.453Z 2026-01-13T15:04:30.862Z
9163831 9163831 20260107104311_ycULS NZ005R 2026-01-08T14:10:40.930Z 2026-01-13T15:03:41.721Z
9157052 9157052 20260104145004_EPphD NZ005R 2026-01-06T14:41:36.288Z 2026-01-12T15:12:49.925Z
9156865 9156865 20260104135139_nbrKa NZ005R 2026-01-06T14:41:05.393Z 2026-01-12T15:12:40.561Z
9156855 9156855 20260104134441_1FXiJ NZ005R 2026-01-06T14:41:03.688Z 2026-01-12T15:12:40.185Z
9156815 9156815 20260104132331_ebPky NZ005R 2026-01-06T14:40:52.476Z 2026-01-12T15:12:38.409Z
9156786 9156786 20260104131707_0Vv4N NZ005R 2026-01-06T14:40:49.146Z 2026-01-12T15:12:37.386Z
9156642 9156642 20260104122511_yK46N NZ005R 2026-01-06T14:40:15.620Z 2026-01-12T15:12:21.020Z
9152957 9152957 20260105145006_3cF8D NZ005R 2026-01-06T14:19:04.604Z 2026-01-13T15:16:41.820Z
9152875 9152875 20260105141117_ggJJC NZ005R 2026-01-06T14:18:45.837Z 2026-01-13T15:16:35.048Z

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