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

3,906 rows where station_code = "NZ003G" 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
8689367 8689367 20251205153222_INPjj NZ003G 2025-12-06T14:08:07.611Z 2025-12-06T14:08:07.611Z
8689308 8689308 20251205150836_s2Pg0 NZ003G 2025-12-06T14:07:49.128Z 2025-12-06T14:07:49.128Z
8689163 8689163 20251205143441_zHox8 NZ003G 2025-12-06T14:07:16.236Z 2025-12-06T14:07:16.236Z
8688078 8688078 20251205101405_bOS6p NZ003G 2025-12-06T14:03:03.854Z 2025-12-06T14:03:03.854Z
8688011 8688011 20251205095707_vW14f NZ003G 2025-12-06T14:02:43.539Z 2025-12-06T14:02:43.539Z
8684973 8684973 20251204144914_f1VMN NZ003G 2025-12-05T14:05:10.066Z 2025-12-06T14:18:00.639Z
8684630 8684630 20251204133010_TSUbd NZ003G 2025-12-05T14:04:05.107Z 2025-12-06T14:18:00.561Z
8684530 8684530 20251204130447_nvxS5 NZ003G 2025-12-05T14:03:38.381Z 2025-12-06T14:18:00.536Z
8683987 8683987 20251204100321_neZNJ NZ003G 2025-12-05T14:01:28.444Z 2025-12-06T14:18:00.388Z
8661473 8661473 20251130152852_NIatH NZ003G 2025-12-02T14:11:35.361Z 2025-12-06T14:38:06.554Z
8661349 8661349 20251130151038_3bun2 NZ003G 2025-12-02T14:11:08.760Z 2025-12-06T14:38:02.833Z
8661303 8661303 20251130150649_L53kc NZ003G 2025-12-02T14:11:02.873Z 2025-12-06T14:38:01.406Z
8661166 8661166 20251130145340_BDsfP NZ003G 2025-12-02T14:10:35.874Z 2025-12-06T14:37:39.551Z
8661049 8661049 20251130143242_2TF7R NZ003G 2025-12-02T14:10:12.326Z 2025-12-06T14:37:36.241Z
8642209 8642209 20251128153827_U2v2M NZ003G 2025-11-30T14:17:40.474Z 2025-12-06T14:53:22.785Z
8629956 8629956 20251128144825_DYkDW NZ003G 2025-11-29T14:09:21.254Z 2025-12-06T14:52:36.029Z
8629913 8629913 20251128144413_8qDrs NZ003G 2025-11-29T14:09:18.428Z 2025-12-06T14:52:35.381Z
8629735 8629735 20251128143417_rAAAf NZ003G 2025-11-29T14:08:57.324Z 2025-12-06T14:52:31.972Z
8628587 8628587 20251128125804_yxk72 NZ003G 2025-11-29T14:06:48.577Z 2025-12-06T14:52:01.916Z
8628535 8628535 20251128125502_22kbp NZ003G 2025-11-29T14:06:31.267Z 2025-12-06T14:51:56.669Z
8621270 8621270 20251126144835_DnftQ NZ003G 2025-11-28T14:15:11.080Z 2025-12-05T15:02:42.525Z
8594494 8594494 20251124113106_EyW7q NZ003G 2025-11-26T14:07:04.687Z 2025-12-02T15:05:32.289Z
8594059 8594059 20251125152256_tw8s4 NZ003G 2025-11-26T14:04:17.649Z 2025-12-04T15:05:34.509Z
8593973 8593973 20251125144155_Yc2YL NZ003G 2025-11-26T14:04:00.293Z 2025-11-26T14:04:00.293Z
8593574 8593574 20251125115912_NxhE2 NZ003G 2025-11-26T14:02:35.661Z 2025-12-04T15:05:20.210Z
8593368 8593368 20251125110807_EOofa NZ003G 2025-11-26T14:01:50.251Z 2025-12-04T15:05:16.501Z
8585435 8585435 20251123154440_Ftu85 NZ003G 2025-11-25T14:09:33.684Z 2025-12-02T15:09:57.839Z
8584525 8584525 20251123123247_EKBML NZ003G 2025-11-25T14:06:42.624Z 2025-12-02T15:09:50.222Z
8570242 8570242 20251121084213_YJEvF NZ003G 2025-11-23T14:33:12.097Z 2025-11-29T14:54:55.929Z
8562250 8562250 20251121135418_earQ4 NZ003G 2025-11-23T14:05:10.337Z 2025-11-30T15:03:25.487Z
8562214 8562214 20251121134922_fWgHX NZ003G 2025-11-23T14:04:57.431Z 2025-11-30T15:03:24.887Z
8562105 8562105 20251121133540_PMcsL NZ003G 2025-11-23T14:04:39.212Z 2025-11-30T15:03:23.035Z
8560678 8560678 20251121103732_pdgPx NZ003G 2025-11-23T14:00:34.549Z 2025-11-30T15:02:35.206Z
8560566 8560566 20251121102102_pVDc8 NZ003G 2025-11-23T14:00:10.134Z 2025-11-30T15:02:32.765Z
8554185 8554185 20251120085628_2hf8h NZ003G 2025-11-22T14:34:50.503Z 2025-11-28T14:58:47.725Z
8541737 8541737 20251120103959_pcKyB NZ003G 2025-11-22T14:00:16.944Z 2025-11-29T14:52:52.543Z
8531568 8531568 20251119144154_OYzz6 NZ003G 2025-11-21T14:05:37.473Z 2025-11-28T14:53:36.675Z
8530749 8530749 20251119124914_jQpOb NZ003G 2025-11-21T14:02:48.552Z 2025-11-28T14:53:20.364Z
8530521 8530521 20251119121642_PPefi NZ003G 2025-11-21T14:01:52.282Z 2025-11-28T14:53:15.168Z
8530502 8530502 20251119121343_ZaB1i NZ003G 2025-11-21T14:01:49.122Z 2025-11-28T14:53:13.902Z
8530132 8530132 20251119110704_PVsX1 NZ003G 2025-11-21T14:00:32.923Z 2025-11-28T14:53:00.625Z
8529632 8529632 20251119101304_RaVP6 NZ003G 2025-11-20T14:45:07.081Z 2025-11-27T15:13:34.488Z
8489253 8489253 20251116154405_c3VYs NZ003G 2025-11-18T14:09:17.945Z 2025-11-25T15:07:22.113Z
8477763 8477763 20251115160131_rfO8k NZ003G 2025-11-17T14:11:57.401Z 2025-11-24T15:03:48.421Z
8476835 8476835 20251115150300_y6RGJ NZ003G 2025-11-17T14:09:52.421Z 2025-11-24T15:03:14.399Z
8475657 8475657 20251115140705_huB7A NZ003G 2025-11-17T14:07:11.084Z 2025-11-24T15:03:03.937Z
8475652 8475652 20251115140605_4Ig2u NZ003G 2025-11-17T14:07:10.326Z 2025-11-24T15:03:03.879Z
8475490 8475490 20251115135906_dSaFa NZ003G 2025-11-17T14:06:42.489Z 2025-11-24T15:03:02.661Z
8475176 8475176 20251115134148_xpsms NZ003G 2025-11-17T14:06:04.537Z 2025-11-24T15:03:00.794Z
8474925 8474925 20251115133058_eo2r7 NZ003G 2025-11-17T14:05:44.772Z 2025-11-24T15:02:59.297Z
8474906 8474906 20251115133039_5JqVT NZ003G 2025-11-17T14:05:43.177Z 2025-11-24T15:02:59.248Z
8474724 8474724 20251115131929_ONgzA NZ003G 2025-11-17T14:05:15.636Z 2025-11-24T15:02:57.859Z
8473986 8473986 20251115124053_L0PrS NZ003G 2025-11-17T14:03:28.260Z 2025-11-24T15:02:53.280Z
8472833 8472833 20251115114352_M5A7J NZ003G 2025-11-17T14:00:29.284Z 2025-11-24T15:02:17.177Z
8472427 8472427 20251114112754_mxfMe NZ003G 2025-11-16T14:33:44.536Z 2025-11-22T15:24:17.382Z
8472373 8472373 20251114112053_diBfG NZ003G 2025-11-16T14:33:18.331Z 2025-11-22T15:24:14.784Z
8471981 8471981 20251114103134_euMkb NZ003G 2025-11-16T14:32:45.913Z 2025-11-22T15:23:54.393Z
8471744 8471744 20251114094855_vMcSr NZ003G 2025-11-16T14:31:56.995Z 2025-11-22T15:23:36.074Z
8471520 8471520 20251114091127_2Ts6l NZ003G 2025-11-16T14:31:16.669Z 2025-11-22T15:23:20.504Z
8465194 8465194 20251114160238_ds6T0 NZ003G 2025-11-16T14:08:34.594Z 2025-11-23T15:16:49.948Z
8464405 8464405 20251114144437_eE2mu NZ003G 2025-11-16T14:06:18.238Z 2025-11-23T15:16:18.254Z
8464079 8464079 20251114141517_DlKHw NZ003G 2025-11-16T14:05:13.382Z 2025-11-23T15:16:09.817Z
8463990 8463990 20251114140743_2Kj70 NZ003G 2025-11-16T14:05:03.081Z 2025-11-23T15:16:07.301Z
8463211 8463211 20251114124200_qnFay NZ003G 2025-11-16T14:02:21.664Z 2025-11-23T15:15:46.370Z
8462902 8462902 20251114121316_1ZhEF NZ003G 2025-11-16T14:01:07.582Z 2025-11-23T15:15:36.274Z
8462823 8462823 20251114120443_2emwR NZ003G 2025-11-16T14:00:46.722Z 2025-11-23T15:15:34.212Z
8453954 8453954 20251113143338_HFz1D NZ003G 2025-11-15T14:04:24.448Z 2025-11-22T15:18:58.907Z
8453537 8453537 20251113133346_RFXB4 NZ003G 2025-11-15T14:02:46.214Z 2025-11-22T15:18:36.432Z
8453526 8453526 20251113132644_bBVAx NZ003G 2025-11-15T14:02:44.391Z 2025-11-22T15:18:34.524Z
8453216 8453216 20251113123933_BBwXJ NZ003G 2025-11-15T14:01:46.597Z 2025-11-22T15:18:19.974Z
8452737 8452737 20251113114345_4BbGD NZ003G 2025-11-14T14:29:44.223Z 2025-11-21T15:13:51.038Z
8452727 8452727 20251113113922_tOMYe NZ003G 2025-11-14T14:29:41.304Z 2025-11-21T15:13:50.060Z
8452423 8452423 20251113090425_sdL3H NZ003G 2025-11-14T14:28:34.582Z 2025-11-21T15:13:21.976Z
8442819 8442819 20251111101401_QOjoJ NZ003G 2025-11-13T14:49:41.395Z 2025-11-19T15:18:45.368Z
8442813 8442813 20251111101140_S1der NZ003G 2025-11-13T14:49:40.550Z 2025-11-19T15:18:44.822Z
8431069 8431069 20251111133326_kvtdV NZ003G 2025-11-13T14:03:16.003Z 2025-11-20T15:19:51.243Z
8419241 8419241 20251110155551_7UI4Q NZ003G 2025-11-12T14:06:02.803Z 2025-11-19T15:13:04.476Z
8408475 8408475 20251109120355_clsUi NZ003G 2025-11-10T14:24:19.732Z 2025-11-17T14:59:28.870Z
8400473 8400473 20251108114125_81rWO NZ003G 2025-11-09T14:20:50.675Z 2025-11-16T15:06:00.063Z
8383397 8383397 20251104095825_nJjKq NZ003G 2025-11-06T14:27:36.201Z 2025-11-12T15:11:46.561Z
8383351 8383351 20251104093044_BkL1i NZ003G 2025-11-06T14:27:04.640Z 2025-11-12T15:11:35.155Z
8383269 8383269 20251104083004_Ob0Ib NZ003G 2025-11-06T14:26:49.672Z 2025-11-12T15:11:20.633Z
8382689 8382689 20251105114647_qXW41 NZ003G 2025-11-06T14:18:27.134Z 2025-11-13T15:16:13.070Z
8382376 8382376 20251105102628_PtBZw NZ003G 2025-11-06T14:17:43.643Z 2025-11-13T15:16:02.732Z
8382169 8382169 20251105093638_hIXc6 NZ003G 2025-11-06T14:17:12.182Z 2025-11-13T15:15:52.485Z
8377392 8377392 20251105132521_192a1 NZ003G 2025-11-06T14:00:30.327Z 2025-11-14T15:07:25.038Z
8366074 8366074 20251102100726_8o2Ut NZ003G 2025-11-04T14:34:21.055Z 2025-11-10T15:10:28.675Z
8366046 8366046 20251102100513_2tGUG NZ003G 2025-11-04T14:34:18.057Z 2025-11-10T15:10:28.445Z
8360898 8360898 20251102160157_BoFIp NZ003G 2025-11-04T14:06:17.665Z 2025-11-11T15:02:41.071Z
8360889 8360889 20251102160030_oKxgn NZ003G 2025-11-04T14:06:15.848Z 2025-11-11T15:02:41.005Z
8360480 8360480 20251102152757_GRd8R NZ003G 2025-11-04T14:04:50.204Z 2025-11-11T15:02:32.985Z
8360115 8360115 20251102145341_2Ndmz NZ003G 2025-11-04T14:03:26.895Z 2025-11-11T15:02:27.873Z
8359379 8359379 20251102125948_dTQKd NZ003G 2025-11-04T14:00:23.879Z 2025-11-11T15:02:16.731Z
8358907 8358907 20251102092730_N0jiP NZ003G 2025-11-03T14:46:42.876Z 2025-11-03T14:46:42.876Z
8358778 8358778 20251102091318_Y8h1g NZ003G 2025-11-03T14:46:25.007Z 2025-11-10T15:10:23.665Z
8348430 8348430 20251101152008_oFNmp NZ003G 2025-11-03T14:02:53.877Z 2025-11-10T15:03:12.049Z
8348421 8348421 20251101151818_T5BFi NZ003G 2025-11-03T14:02:51.972Z 2025-11-10T15:03:11.222Z
8348404 8348404 20251101151510_pKXKy NZ003G 2025-11-03T14:02:46.161Z 2025-11-10T15:03:10.491Z
8348222 8348222 20251101144210_gq5Wb NZ003G 2025-11-03T14:02:00.821Z 2025-11-10T15:02:57.812Z
8346906 8346906 20251101091045_EMv0Q NZ003G 2025-11-02T14:45:11.911Z 2025-11-09T15:05:36.829Z

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