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

204 rows where station_code = "NZ006L" 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
9611835 9611835 20260403151018_vJpG0 NZ006L 2026-04-06T12:18:52.682Z 2026-04-09T12:42:08.042Z
9609651 9609651 20260405085822_vLIww NZ006L 2026-04-06T12:03:03.972Z 2026-04-09T12:36:03.632Z
9609073 9609073 20260330124053_UHRsU NZ006L 2026-04-05T12:23:21.687Z 2026-04-08T12:43:13.182Z
9609071 9609071 20260330083722_BTZwO NZ006L 2026-04-05T12:22:36.931Z 2026-04-08T12:42:31.984Z
9609053 9609053 20260402165350_L0qcP NZ006L 2026-04-05T12:15:21.859Z 2026-04-09T12:44:19.367Z
9567264 9567264 20260323150023_ZI93q NZ006L 2026-03-24T12:13:18.737Z 2026-03-31T12:28:11.538Z
9567131 9567131 20260323144217_3KQHy NZ006L 2026-03-24T12:13:02.442Z 2026-03-31T12:28:08.806Z
9567078 9567078 20260323143727_5SBg2 NZ006L 2026-03-24T12:12:56.637Z 2026-03-31T12:28:08.066Z
9567017 9567017 20260323143207_wDMok NZ006L 2026-03-24T12:12:51.386Z 2026-03-31T12:28:07.192Z
9566953 9566953 20260323142955_1M6Vn NZ006L 2026-03-24T12:12:45.944Z 2026-03-24T12:24:25.186Z
9566021 9566021 20260323125845_rHEoK NZ006L 2026-03-24T12:11:13.109Z 2026-03-31T12:27:44.907Z
9565980 9565980 20260323125545_DsIcZ NZ006L 2026-03-24T12:11:07.582Z 2026-03-31T12:27:44.292Z
9565695 9565695 20260323123315_wEilM NZ006L 2026-03-24T12:10:39.330Z 2026-03-31T12:27:39.826Z
9565630 9565630 20260323122710_MQ4F9 NZ006L 2026-03-24T12:10:32.475Z 2026-03-31T12:27:38.701Z
9564071 9564071 20260323095648_xFaMq NZ006L 2026-03-24T12:07:22.165Z 2026-03-31T12:27:01.945Z
9559496 9559496 20260321173101_Q6FfZ NZ006L 2026-03-23T12:11:07.965Z 2026-03-29T12:20:40.018Z
9559187 9559187 20260321164506_LXLCF NZ006L 2026-03-23T12:10:57.011Z 2026-03-29T12:20:35.013Z
9558908 9558908 20260321160332_F9r9K NZ006L 2026-03-23T12:10:39.362Z 2026-03-29T12:20:31.600Z
9557129 9557129 20260322125955_LRgbS NZ006L 2026-03-23T12:05:37.629Z 2026-03-30T12:29:29.460Z
9557096 9557096 20260322125103_z8c6K NZ006L 2026-03-23T12:05:36.018Z 2026-03-30T12:29:21.267Z
9557015 9557015 20260322123624_e33Su NZ006L 2026-03-23T12:05:28.288Z 2026-03-30T12:29:18.876Z
9556940 9556940 20260322121401_N40NY NZ006L 2026-03-23T12:05:22.275Z 2026-03-30T12:29:15.422Z
9556226 9556226 20260322093730_Ra96F NZ006L 2026-03-23T12:04:29.864Z 2026-03-30T12:28:47.907Z
9556168 9556168 20260322092926_F3pgM NZ006L 2026-03-23T12:04:26.296Z 2026-03-30T12:28:46.442Z
9556120 9556120 20260322092104_Mt2Le NZ006L 2026-03-23T12:04:22.478Z 2026-03-30T12:28:45.400Z
9555873 9555873 20260322082720_3tocE NZ006L 2026-03-23T12:04:04.941Z 2026-03-30T12:28:37.774Z
9555659 9555659 20260322072037_CzFFT NZ006L 2026-03-23T12:03:44.952Z 2026-03-30T12:28:31.619Z
9550409 9550409 20260320163720_xEE2Y NZ006L 2026-03-22T12:25:13.855Z 2026-03-28T12:36:30.535Z
9550131 9550131 20260320161133_lLZxC NZ006L 2026-03-22T12:24:56.669Z 2026-03-28T12:36:27.289Z
9549492 9549492 20260320150445_cbOJ9 NZ006L 2026-03-22T12:24:03.118Z 2026-03-28T12:36:04.764Z
9549440 9549440 20260320145938_0W1XY NZ006L 2026-03-22T12:23:59.679Z 2026-03-28T12:36:03.952Z
9549010 9549010 20260321164208_c2zhf NZ006L 2026-03-22T12:16:24.391Z 2026-03-29T12:20:34.854Z
9549008 9549008 20260321164204_kKTEd NZ006L 2026-03-22T12:16:24.056Z 2026-03-29T12:20:34.853Z
9548947 9548947 20260321160226_yqdRy NZ006L 2026-03-22T12:16:16.660Z 2026-03-29T12:20:31.403Z
9548922 9548922 20260321155018_GPtvp NZ006L 2026-03-22T12:16:13.751Z 2026-03-29T12:20:30.533Z
9548920 9548920 20260321154935_1Hxgi NZ006L 2026-03-22T12:16:13.523Z 2026-03-29T12:20:30.312Z
9548811 9548811 20260321153539_f2PPF NZ006L 2026-03-22T12:16:00.111Z 2026-03-29T12:20:29.027Z
9548780 9548780 20260321153339_989s7 NZ006L 2026-03-22T12:15:57.639Z 2026-03-29T12:20:28.810Z
9548668 9548668 20260321152544_nLAAz NZ006L 2026-03-22T12:15:47.543Z 2026-03-29T12:20:27.886Z
9548649 9548649 20260321152307_zEO5t NZ006L 2026-03-22T12:15:45.652Z 2026-03-29T12:20:27.754Z
9548611 9548611 20260321151756_pXgel NZ006L 2026-03-22T12:15:40.169Z 2026-03-29T12:20:27.509Z
9547691 9547691 20260321135139_E7RRv NZ006L 2026-03-22T12:14:06.536Z 2026-03-29T12:20:11.220Z
9547665 9547665 20260321135004_Y630T NZ006L 2026-03-22T12:14:04.305Z 2026-03-29T12:20:11.092Z
9547498 9547498 20260321133323_Agok4 NZ006L 2026-03-22T12:13:47.112Z 2026-03-29T12:20:09.867Z
9547359 9547359 20260321132039_ZJnC0 NZ006L 2026-03-22T12:13:29.911Z 2026-03-29T12:20:08.972Z
9547345 9547345 20260321131928_A8iB4 NZ006L 2026-03-22T12:13:27.628Z 2026-03-29T12:20:08.797Z
9546838 9546838 20260321123042_F9hh7 NZ006L 2026-03-22T12:12:29.535Z 2026-03-22T12:27:38.336Z
9546719 9546719 20260321122158_NXBla NZ006L 2026-03-22T12:12:17.268Z 2026-03-29T12:20:03.418Z
9546708 9546708 20260321122149_HWXrt NZ006L 2026-03-22T12:12:16.276Z 2026-03-29T12:20:03.403Z
9546095 9546095 20260321113559_1n6Eh NZ006L 2026-03-22T12:11:00.794Z 2026-03-29T12:19:47.481Z
9545490 9545490 20260321103947_MZUv3 NZ006L 2026-03-22T12:09:32.204Z 2026-03-29T12:19:40.565Z
9545457 9545457 20260321103806_nWLiI NZ006L 2026-03-22T12:09:27.855Z 2026-03-29T12:19:40.362Z
9545400 9545400 20260321103102_V7IAA NZ006L 2026-03-22T12:09:20.083Z 2026-03-22T12:27:38.028Z
9545387 9545387 20260321102835_lqUBs NZ006L 2026-03-22T12:09:18.056Z 2026-03-22T12:27:38.024Z
9545049 9545049 20260321095543_vTdeZ NZ006L 2026-03-22T12:08:28.908Z 2026-03-29T12:19:36.535Z
9544326 9544326 20260321081843_3MmUS NZ006L 2026-03-22T12:06:29.042Z 2026-03-29T12:19:28.361Z
9539822 9539822 20260320171036_7RHus NZ006L 2026-03-21T12:20:17.365Z 2026-03-28T12:36:35.811Z
9539775 9539775 20260320164905_8N0SM NZ006L 2026-03-21T12:20:11.570Z 2026-03-28T12:36:32.173Z
9539720 9539720 20260320162758_WJ4fl NZ006L 2026-03-21T12:20:05.447Z 2026-03-28T12:36:29.226Z
9539639 9539639 20260320154915_0hSs1 NZ006L 2026-03-21T12:19:55.101Z 2026-03-28T12:36:22.815Z
9539619 9539619 20260320153729_5y9Ct NZ006L 2026-03-21T12:19:50.003Z 2026-03-28T12:36:20.820Z
9539598 9539598 20260320152952_m7vrs NZ006L 2026-03-21T12:19:47.980Z 2026-03-21T12:30:07.001Z
9539528 9539528 20260320150833_C0qe8 NZ006L 2026-03-21T12:19:40.618Z 2026-03-28T12:36:05.492Z
9539513 9539513 20260320150017_IjBjh NZ006L 2026-03-21T12:19:39.330Z 2026-03-28T12:36:04.368Z
9539476 9539476 20260320145407_Z3533 NZ006L 2026-03-21T12:19:35.612Z 2026-03-28T12:36:02.074Z
9539454 9539454 20260320144849_KFTQi NZ006L 2026-03-21T12:19:34.073Z 2026-03-28T12:36:01.541Z
9539130 9539130 20260320141226_ftwN6 NZ006L 2026-03-21T12:18:59.400Z 2026-03-28T12:35:56.915Z
9539115 9539115 20260320141130_TejI8 NZ006L 2026-03-21T12:18:58.042Z 2026-03-21T12:30:06.764Z
9539077 9539077 20260320140747_Tz4tp NZ006L 2026-03-21T12:18:55.252Z 2026-03-28T12:35:56.622Z
9538990 9538990 20260320140122_o2NH2 NZ006L 2026-03-21T12:18:43.397Z 2026-03-28T12:35:55.531Z
9538922 9538922 20260320135732_fX3Gg NZ006L 2026-03-21T12:18:36.286Z 2026-03-28T12:35:54.709Z
9538870 9538870 20260320135308_Udj4q NZ006L 2026-03-21T12:18:31.760Z 2026-03-28T12:35:53.944Z
9538777 9538777 20260320134608_Xbcot NZ006L 2026-03-21T12:18:22.352Z 2026-03-21T12:30:06.609Z
9538742 9538742 20260320134127_8tpH5 NZ006L 2026-03-21T12:18:15.154Z 2026-03-28T12:35:51.981Z
9538655 9538655 20260320133002_lR8WJ NZ006L 2026-03-21T12:18:06.540Z 2026-03-21T12:30:06.550Z
9538585 9538585 20260320132101_LEMKo NZ006L 2026-03-21T12:17:59.252Z 2026-03-28T12:35:50.375Z
9538482 9538482 20260320130942_smduL NZ006L 2026-03-21T12:17:49.911Z 2026-03-28T12:35:48.800Z
9538346 9538346 20260320125303_MfY3G NZ006L 2026-03-21T12:17:32.658Z 2026-03-28T12:35:47.238Z
9538320 9538320 20260320125114_d1TmB NZ006L 2026-03-21T12:17:29.246Z 2026-03-28T12:35:46.853Z
9538287 9538287 20260320124751_zw5yB NZ006L 2026-03-21T12:17:26.273Z 2026-03-28T12:35:44.231Z
9538248 9538248 20260320124537_75yut NZ006L 2026-03-21T12:17:23.146Z 2026-03-28T12:35:38.259Z
9538196 9538196 20260320124028_KQlwk NZ006L 2026-03-21T12:17:15.280Z 2026-03-28T12:35:35.724Z
9538043 9538043 20260320122805_gOKjw NZ006L 2026-03-21T12:16:59.148Z 2026-03-28T12:35:33.844Z
9538040 9538040 20260320122803_1Qji9 NZ006L 2026-03-21T12:16:58.866Z 2026-03-21T12:30:06.351Z
9537805 9537805 20260320120408_LGuao NZ006L 2026-03-21T12:16:30.680Z 2026-03-28T12:35:29.469Z
9537182 9537182 20260320111242_Lksrh NZ006L 2026-03-21T12:15:13.561Z 2026-03-28T12:35:22.800Z
9536967 9536967 20260320105339_ujGN1 NZ006L 2026-03-21T12:14:47.914Z 2026-03-28T12:35:19.538Z
9536399 9536399 20260320094453_xweR3 NZ006L 2026-03-21T12:13:18.253Z 2026-03-21T12:30:05.829Z
9536258 9536258 20260320092833_tEy2V NZ006L 2026-03-21T12:12:55.793Z 2026-03-21T12:30:05.782Z
9536255 9536255 20260320092750_HPKxf NZ006L 2026-03-21T12:12:55.404Z 2026-03-28T12:34:59.013Z
9536176 9536176 20260320092035_S8mNC NZ006L 2026-03-21T12:12:45.298Z 2026-03-28T12:34:58.335Z
9535696 9535696 20260320082053_Mm6L2 NZ006L 2026-03-21T12:11:36.519Z 2026-03-28T12:34:49.397Z
9528633 9528633 20260318163332_7PtXK NZ006L 2026-03-20T12:22:25.215Z 2026-03-26T12:38:37.387Z
9528408 9528408 20260318161230_nwf0Q NZ006L 2026-03-20T12:22:16.302Z 2026-03-26T12:38:36.017Z
9528351 9528351 20260318160805_XdjZX NZ006L 2026-03-20T12:22:13.526Z 2026-03-26T12:38:35.600Z
9528176 9528176 20260318154753_jjnc0 NZ006L 2026-03-20T12:21:58.024Z 2026-03-26T12:38:34.354Z
9527875 9527875 20260318152217_L8FFI NZ006L 2026-03-20T12:21:47.083Z 2026-03-26T12:38:31.864Z
9527707 9527707 20260318150719_dPghT NZ006L 2026-03-20T12:21:39.330Z 2026-03-26T12:38:30.732Z
9527236 9527236 20260318141944_X6lmK NZ006L 2026-03-20T12:21:06.431Z 2026-03-26T12:38:27.024Z
9527131 9527131 20260318140421_FinnB NZ006L 2026-03-20T12:21:01.222Z 2026-03-26T12:38:26.204Z

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