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

406 rows where station_code = "NZ006C" 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
9627070 9627070 20260408160748_vSEO6 NZ006C 2026-04-09T12:09:53.133Z 2026-04-10T12:14:22.474Z
9626995 9626995 20260408154616_6zhLG NZ006C 2026-04-09T12:09:42.218Z 2026-04-10T12:14:22.453Z
9626985 9626985 20260408154431_NdxtZ NZ006C 2026-04-09T12:09:41.352Z 2026-04-10T12:14:22.451Z
9626533 9626533 20260408141137_IWNEi NZ006C 2026-04-09T12:08:38.432Z 2026-04-10T12:14:22.369Z
9626471 9626471 20260408140456_iPY4W NZ006C 2026-04-09T12:08:23.877Z 2026-04-10T12:14:22.358Z
9626300 9626300 20260408134009_hnk83 NZ006C 2026-04-09T12:07:56.226Z 2026-04-10T12:14:22.330Z
9626287 9626287 20260408133803_CCnSr NZ006C 2026-04-09T12:07:55.243Z 2026-04-10T12:14:22.329Z
9626223 9626223 20260408132621_ALeQP NZ006C 2026-04-09T12:07:47.336Z 2026-04-10T12:14:22.319Z
9626082 9626082 20260408130736_EaLyR NZ006C 2026-04-09T12:07:33.353Z 2026-04-10T12:14:22.293Z
9625919 9625919 20260408122428_yYO1J NZ006C 2026-04-09T12:07:06.718Z 2026-04-10T12:14:22.264Z
9625754 9625754 20260408114406_NSYyw NZ006C 2026-04-09T12:06:35.477Z 2026-04-10T12:14:22.234Z
9625683 9625683 20260408113421_md17c NZ006C 2026-04-09T12:06:16.959Z 2026-04-10T12:14:22.223Z
9625471 9625471 20260408105847_pSdVM NZ006C 2026-04-09T12:05:38.053Z 2026-04-10T12:14:21.931Z
9625271 9625271 20260408101250_Wsn6C NZ006C 2026-04-09T12:04:56.662Z 2026-04-10T12:14:21.892Z
9625267 9625267 20260408101250_cNIAS NZ006C 2026-04-09T12:04:56.259Z 2026-04-10T12:14:21.892Z
9624745 9624745 20260408082019_CRZGz NZ006C 2026-04-09T12:02:47.561Z 2026-04-10T12:14:21.451Z
9624584 9624584 20260408074710_MqPqy NZ006C 2026-04-09T12:02:04.700Z 2026-04-10T12:14:21.413Z
9624530 9624530 20260408073200_3T3xb NZ006C 2026-04-09T12:01:52.559Z 2026-04-10T12:14:21.400Z
9613243 9613243 20260405130140_lgf26 NZ006C 2026-04-07T12:05:36.761Z 2026-04-10T12:26:36.218Z
9612844 9612844 20260406171344_wpTde NZ006C 2026-04-07T12:03:02.917Z 2026-04-10T12:22:22.646Z
9612707 9612707 20260406153919_kJ8eq NZ006C 2026-04-07T12:02:36.231Z 2026-04-10T12:22:16.334Z
9612604 9612604 20260406142644_ZV3vA NZ006C 2026-04-07T12:02:17.138Z 2026-04-10T12:22:13.631Z
9612255 9612255 20260406091217_9hNwf NZ006C 2026-04-07T12:01:13.916Z 2026-04-10T12:22:02.647Z
9611868 9611868 20260401161228_XjRRt NZ006C 2026-04-06T12:25:15.680Z 2026-04-10T12:35:42.387Z
9611867 9611867 20260401153914_kMBSX NZ006C 2026-04-06T12:25:09.241Z 2026-04-10T12:35:40.513Z
9611832 9611832 20260403103727_G7dZb NZ006C 2026-04-06T12:18:03.225Z 2026-04-10T12:31:38.192Z
9611829 9611829 20260403103328_g7Obj NZ006C 2026-04-06T12:18:01.869Z 2026-04-10T12:31:37.845Z
9611826 9611826 20260403100322_T3l4e NZ006C 2026-04-06T12:17:53.361Z 2026-04-10T12:31:36.337Z
9599847 9599847 20260331170719_3n3jR NZ006C 2026-04-01T12:05:02.601Z 2026-04-09T12:47:39.540Z
9599805 9599805 20260331165518_23kod NZ006C 2026-04-01T12:04:54.250Z 2026-04-09T12:47:32.670Z
9599667 9599667 20260331161224_3MwBu NZ006C 2026-04-01T12:04:23.647Z 2026-04-09T12:47:11.186Z
9599664 9599664 20260331161224_ETspz NZ006C 2026-04-01T12:04:23.194Z 2026-04-09T12:47:11.138Z
9595772 9595772 20260330083416_g32U3 NZ006C 2026-03-31T12:02:27.058Z 2026-04-08T12:42:31.679Z
9595672 9595672 20260330075358_vr0pu NZ006C 2026-03-31T12:02:09.929Z 2026-04-08T12:42:29.081Z
9588743 9588743 20260325123613_vEBPq NZ006C 2026-03-28T12:14:33.505Z 2026-04-03T12:38:10.592Z
9588740 9588740 20260325115605_wbxJr NZ006C 2026-03-28T12:14:23.443Z 2026-04-03T12:38:04.828Z
9588734 9588734 20260325100245_UmwtJ NZ006C 2026-03-28T12:13:59.204Z 2026-04-03T12:37:37.594Z
9588728 9588728 20260325093254_IvjEq NZ006C 2026-03-28T12:13:55.815Z 2026-04-03T12:37:34.330Z
9588723 9588723 20260325083812_hazhX NZ006C 2026-03-28T12:13:43.077Z 2026-04-03T12:37:27.202Z
9588210 9588210 20260326171813_MFo4F NZ006C 2026-03-28T12:10:22.707Z 2026-04-04T12:41:31.938Z
9588192 9588192 20260326162459_gzlET NZ006C 2026-03-28T12:10:15.647Z 2026-04-04T12:41:26.956Z
9588175 9588175 20260326151832_KrwvV NZ006C 2026-03-28T12:10:07.420Z 2026-04-04T12:41:17.498Z
9588168 9588168 20260326143104_LRu32 NZ006C 2026-03-28T12:10:01.177Z 2026-04-04T12:41:09.255Z
9588157 9588157 20260326140329_jSEss NZ006C 2026-03-28T12:09:59.337Z 2026-04-04T12:41:06.412Z
9580208 9580208 20260323171549_3ex6v NZ006C 2026-03-26T12:19:36.363Z 2026-03-31T12:28:40.906Z
9580206 9580206 20260323170131_l74IT NZ006C 2026-03-26T12:19:32.505Z 2026-03-31T12:28:38.496Z
9580204 9580204 20260323164845_nof2H NZ006C 2026-03-26T12:19:29.309Z 2026-03-31T12:28:29.848Z
9580198 9580198 20260323140402_YTKfL NZ006C 2026-03-26T12:18:37.749Z 2026-03-31T12:27:55.412Z
9580196 9580196 20260323132958_6nQLa NZ006C 2026-03-26T12:18:29.037Z 2026-03-31T12:27:49.632Z
9580194 9580194 20260323132704_apSKP NZ006C 2026-03-26T12:18:27.669Z 2026-03-31T12:27:48.962Z
9580190 9580190 20260323125319_HF75g NZ006C 2026-03-26T12:18:15.081Z 2026-03-31T12:27:43.909Z
9580189 9580189 20260323125006_19CFb NZ006C 2026-03-26T12:18:13.622Z 2026-03-31T12:27:43.248Z
9580187 9580187 20260323124441_eYKZh NZ006C 2026-03-26T12:18:12.126Z 2026-03-31T12:27:42.376Z
9580185 9580185 20260323122828_6JfX2 NZ006C 2026-03-26T12:18:06.311Z 2026-03-31T12:27:38.875Z
9580181 9580181 20260323101317_cgygs NZ006C 2026-03-26T12:17:18.240Z 2026-03-31T12:27:05.218Z
9580177 9580177 20260323091524_Gd7Pg NZ006C 2026-03-26T12:17:03.594Z 2026-03-31T12:26:57.169Z
9580175 9580175 20260323082342_4XWTj NZ006C 2026-03-26T12:16:51.850Z 2026-03-31T12:26:43.788Z
9580173 9580173 20260323081505_FsTYe NZ006C 2026-03-26T12:16:49.783Z 2026-03-31T12:26:42.712Z
9579358 9579358 20260324174918_oLh4r NZ006C 2026-03-26T12:13:12.430Z 2026-04-02T12:37:02.940Z
9579244 9579244 20260324141904_TvCdk NZ006C 2026-03-26T12:12:13.052Z 2026-04-02T12:36:31.007Z
9579194 9579194 20260324125835_sMjN0 NZ006C 2026-03-26T12:11:53.398Z 2026-04-02T12:36:15.895Z
9557016 9557016 20260322123706_GtdS5 NZ006C 2026-03-23T12:05:28.562Z 2026-03-30T12:29:18.981Z
9549476 9549476 20260320150240_UWbyc NZ006C 2026-03-22T12:24:01.944Z 2026-03-28T12:36:04.586Z
9549115 9549115 20260321173626_1p48g NZ006C 2026-03-22T12:16:35.250Z 2026-03-29T12:20:40.120Z
9549077 9549077 20260321171401_XR13l NZ006C 2026-03-22T12:16:30.573Z 2026-03-29T12:20:38.744Z
9549041 9549041 20260321165639_nSp2F NZ006C 2026-03-22T12:16:27.801Z 2026-03-29T12:20:37.509Z
9549023 9549023 20260321164748_TLXQS NZ006C 2026-03-22T12:16:25.795Z 2026-03-29T12:20:35.371Z
9549001 9549001 20260321163628_jyXNZ NZ006C 2026-03-22T12:16:23.277Z 2026-03-29T12:20:34.178Z
9548199 9548199 20260321144022_yh4La NZ006C 2026-03-22T12:15:02.160Z 2026-03-29T12:20:24.592Z
9547026 9547026 20260321124801_LgXOn NZ006C 2026-03-22T12:12:49.446Z 2026-03-29T12:20:06.031Z
9547006 9547006 20260321124602_2iKv2 NZ006C 2026-03-22T12:12:46.656Z 2026-03-29T12:20:05.775Z
9546470 9546470 20260321120200_c4xjB NZ006C 2026-03-22T12:11:48.298Z 2026-03-29T12:20:01.469Z
9546391 9546391 20260321115705_h68fp NZ006C 2026-03-22T12:11:38.040Z 2026-03-29T12:20:00.593Z
9546276 9546276 20260321114928_2233s NZ006C 2026-03-22T12:11:25.448Z 2026-03-29T12:19:49.069Z
9546125 9546125 20260321113836_WVz3u NZ006C 2026-03-22T12:11:07.759Z 2026-03-29T12:19:47.701Z
9546066 9546066 20260321113424_Y8qu3 NZ006C 2026-03-22T12:10:55.747Z 2026-03-29T12:19:47.245Z
9545910 9545910 20260321112118_hI5gP NZ006C 2026-03-22T12:10:38.387Z 2026-03-29T12:19:45.487Z
9545856 9545856 20260321111428_9Eh9k NZ006C 2026-03-22T12:10:25.837Z 2026-03-29T12:19:45.042Z
9545798 9545798 20260321110717_a0tVL NZ006C 2026-03-22T12:10:17.265Z 2026-03-29T12:19:44.436Z
9545777 9545777 20260321110623_AtTky NZ006C 2026-03-22T12:10:15.008Z 2026-03-29T12:19:43.162Z
9545729 9545729 20260321110050_tfSrv NZ006C 2026-03-22T12:10:06.366Z 2026-03-29T12:19:42.812Z
9545369 9545369 20260321102649_9KElo NZ006C 2026-03-22T12:09:14.854Z 2026-03-29T12:19:39.550Z
9545180 9545180 20260321101107_EMuYY NZ006C 2026-03-22T12:08:50.569Z 2026-03-29T12:19:37.771Z
9545146 9545146 20260321100545_3ezR2 NZ006C 2026-03-22T12:08:41.469Z 2026-03-29T12:19:37.326Z
9545118 9545118 20260321100348_RrBIy NZ006C 2026-03-22T12:08:36.829Z 2026-03-29T12:19:37.059Z
9544666 9544666 20260321090730_nwcrB NZ006C 2026-03-22T12:07:26.934Z 2026-03-29T12:19:32.383Z
9544528 9544528 20260321085132_V0syj NZ006C 2026-03-22T12:07:06.016Z 2026-03-29T12:19:30.852Z
9544468 9544468 20260321084310_HrP8G NZ006C 2026-03-22T12:06:54.805Z 2026-03-29T12:19:30.144Z
9544454 9544454 20260321083914_X6T3G NZ006C 2026-03-22T12:06:52.478Z 2026-03-29T12:19:30.062Z
9539593 9539593 20260320152941_Br3Br NZ006C 2026-03-21T12:19:47.782Z 2026-03-28T12:36:16.058Z
9539516 9539516 20260320150441_cFx2k NZ006C 2026-03-21T12:19:39.805Z 2026-03-28T12:36:04.698Z
9539464 9539464 20260320145109_FcQLD NZ006C 2026-03-21T12:19:35.014Z 2026-03-28T12:36:01.795Z
9539345 9539345 20260320143504_kljVg NZ006C 2026-03-21T12:19:19.313Z 2026-03-28T12:35:59.578Z
9539209 9539209 20260320142217_ukiAx NZ006C 2026-03-21T12:19:08.554Z 2026-03-28T12:35:58.166Z
9539198 9539198 20260320141938_JBHXN NZ006C 2026-03-21T12:19:06.840Z 2026-03-21T12:30:06.807Z
9539194 9539194 20260320141938_GBDR9 NZ006C 2026-03-21T12:19:06.594Z 2026-03-21T12:30:06.806Z
9538939 9538939 20260320135754_BQ0ck NZ006C 2026-03-21T12:18:37.378Z 2026-03-28T12:35:54.918Z
9538896 9538896 20260320135521_90f2o NZ006C 2026-03-21T12:18:33.754Z 2026-03-28T12:35:54.362Z
9538732 9538732 20260320134019_3CuWP NZ006C 2026-03-21T12:18:14.493Z 2026-03-28T12:35:51.938Z
9538668 9538668 20260320133335_QoFzT NZ006C 2026-03-21T12:18:08.572Z 2026-03-28T12:35:51.558Z

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