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,807 rows where station_code = "NZ002J" 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
8672663 8672663 20251201150228_xukR0 NZ002J 2025-12-03T14:16:07.310Z 2025-12-05T14:25:37.880Z
8672281 8672281 20251201140932_WvoE0 NZ002J 2025-12-03T14:15:12.722Z 2025-12-05T14:25:16.338Z
8672265 8672265 20251201140829_mj9n8 NZ002J 2025-12-03T14:15:11.747Z 2025-12-05T14:25:15.984Z
8672106 8672106 20251201135325_smPHM NZ002J 2025-12-03T14:14:42.865Z 2025-12-05T14:25:08.814Z
8672085 8672085 20251201134912_6dAQ7 NZ002J 2025-12-03T14:14:40.615Z 2025-12-05T14:25:07.361Z
8671476 8671476 20251201122244_UACJG NZ002J 2025-12-03T14:12:42.819Z 2025-12-05T14:24:30.783Z
8671381 8671381 20251201121148_F7Pmn NZ002J 2025-12-03T14:12:18.882Z 2025-12-05T14:24:26.457Z
8671293 8671293 20251201115315_b2ImH NZ002J 2025-12-03T14:12:05.122Z 2025-12-05T14:24:22.529Z
8671273 8671273 20251201115043_Cp7IO NZ002J 2025-12-03T14:12:02.326Z 2025-12-05T14:24:21.463Z
8671159 8671159 20251201112705_3xt4e NZ002J 2025-12-03T14:11:31.805Z 2025-12-05T14:24:16.264Z
8670956 8670956 20251201105518_AM7BZ NZ002J 2025-12-03T14:10:51.210Z 2025-12-05T14:23:57.639Z
8642069 8642069 20251128152948_TMVam NZ002J 2025-11-30T14:17:19.205Z 2025-12-05T14:48:55.128Z
8640690 8640690 20251129153015_3AE3M NZ002J 2025-11-30T14:09:16.714Z 2025-12-05T14:39:25.327Z
8640634 8640634 20251129151024_fNOg1 NZ002J 2025-11-30T14:08:59.229Z 2025-12-05T14:39:22.675Z
8640457 8640457 20251129142513_jwlRE NZ002J 2025-11-30T14:08:27.665Z 2025-12-05T14:39:15.531Z
8640413 8640413 20251129141019_l3dGO NZ002J 2025-11-30T14:08:18.089Z 2025-12-05T14:39:12.901Z
8640375 8640375 20251129135747_BXHJa NZ002J 2025-11-30T14:08:11.512Z 2025-12-05T14:39:11.936Z
8639289 8639289 20251129105140_r3vV6 NZ002J 2025-11-30T14:04:23.990Z 2025-12-05T14:38:12.974Z
8638985 8638985 20251129101416_kEtuP NZ002J 2025-11-30T14:03:16.234Z 2025-12-05T14:37:50.056Z
8638883 8638883 20251129095853_qJG1g NZ002J 2025-11-30T14:02:44.232Z 2025-12-05T14:37:46.800Z
8638869 8638869 20251129095703_EBGYJ NZ002J 2025-11-30T14:02:39.243Z 2025-12-05T14:37:46.140Z
8629971 8629971 20251128145115_wxX4M NZ002J 2025-11-29T14:09:23.655Z 2025-12-05T14:48:36.234Z
8629949 8629949 20251128144814_ggnOK NZ002J 2025-11-29T14:09:21.007Z 2025-12-05T14:48:32.759Z
8629571 8629571 20251128141950_s4EMS NZ002J 2025-11-29T14:08:43.184Z 2025-12-05T14:48:06.899Z
8629438 8629438 20251128140817_Ybc7W NZ002J 2025-11-29T14:08:23.446Z 2025-12-05T14:48:00.465Z
8629366 8629366 20251128140149_9Nv5p NZ002J 2025-11-29T14:08:18.644Z 2025-12-05T14:47:59.367Z
8628456 8628456 20251128124631_KBquE NZ002J 2025-11-29T14:06:21.551Z 2025-12-05T14:47:43.289Z
8627618 8627618 20251128112021_FZXKD NZ002J 2025-11-29T14:04:04.925Z 2025-12-05T14:47:03.320Z
8627565 8627565 20251128111447_oK8bJ NZ002J 2025-11-29T14:03:59.774Z 2025-12-05T14:47:02.331Z
8627536 8627536 20251128111141_45yns NZ002J 2025-11-29T14:03:55.921Z 2025-12-05T14:47:01.585Z
8626751 8626751 20251128093257_T4uS1 NZ002J 2025-11-29T14:01:26.413Z 2025-12-05T14:46:18.247Z
8621368 8621368 20251126150235_qNIOZ NZ002J 2025-11-28T14:15:34.611Z 2025-12-05T15:02:43.647Z
8621326 8621326 20251126145413_52qTU NZ002J 2025-11-28T14:15:18.645Z 2025-12-05T15:02:43.096Z
8621321 8621321 20251126145409_gSdL3 NZ002J 2025-11-28T14:15:18.458Z 2025-12-05T15:02:43.093Z
8621030 8621030 20251126141844_8193d NZ002J 2025-11-28T14:14:34.940Z 2025-12-05T15:02:39.909Z
8621024 8621024 20251126141703_FbbgZ NZ002J 2025-11-28T14:14:34.234Z 2025-12-05T15:02:39.874Z
8594696 8594696 20251124123206_pEtI6 NZ002J 2025-11-26T14:08:18.938Z 2025-12-02T15:05:35.393Z
8593976 8593976 20251125144346_tr3fB NZ002J 2025-11-26T14:04:00.727Z 2025-12-04T15:05:30.115Z
8593721 8593721 20251125123526_fzZYp NZ002J 2025-11-26T14:03:14.330Z 2025-12-04T15:05:23.291Z
8593685 8593685 20251125122603_6VWSJ NZ002J 2025-11-26T14:03:04.986Z 2025-12-04T15:05:22.488Z
8576647 8576647 20251122153524_bKtvo NZ002J 2025-11-24T14:06:20.662Z 2025-12-01T15:18:38.834Z
8576584 8576584 20251122152638_yIwkS NZ002J 2025-11-24T14:06:11.957Z 2025-12-01T15:18:38.234Z
8576408 8576408 20251122150546_X6jKG NZ002J 2025-11-24T14:05:46.981Z 2025-12-01T15:18:36.513Z
8576260 8576260 20251122144311_Ypkq6 NZ002J 2025-11-24T14:05:17.049Z 2025-12-01T15:18:34.755Z
8563109 8563109 20251121151554_qbKz2 NZ002J 2025-11-23T14:07:23.384Z 2025-11-30T15:03:35.574Z
8562972 8562972 20251121150426_RZ3US NZ002J 2025-11-23T14:06:59.858Z 2025-11-30T15:03:34.467Z
8562878 8562878 20251121145624_60i95 NZ002J 2025-11-23T14:06:49.558Z 2025-11-30T15:03:33.585Z
8562761 8562761 20251121144521_Lw4It NZ002J 2025-11-23T14:06:30.235Z 2025-11-30T15:03:32.972Z
8561505 8561505 20251121122217_Nfw4Q NZ002J 2025-11-23T14:02:52.212Z 2025-11-30T15:02:57.976Z
8561454 8561454 20251121121641_a3knM NZ002J 2025-11-23T14:02:44.514Z 2025-11-30T15:02:57.310Z
8554229 8554229 20251120090710_3oF73 NZ002J 2025-11-22T14:34:54.962Z 2025-11-28T14:58:48.632Z
8544804 8544804 20251120153425_LMpoc NZ002J 2025-11-22T14:08:54.302Z 2025-11-29T14:53:53.376Z
8544362 8544362 20251120150919_okYU1 NZ002J 2025-11-22T14:07:41.406Z 2025-11-29T14:53:43.722Z
8544170 8544170 20251120145459_66kZ7 NZ002J 2025-11-22T14:07:11.002Z 2025-11-29T14:53:41.778Z
8544038 8544038 20251120144351_wYz8r NZ002J 2025-11-22T14:06:50.028Z 2025-11-29T14:53:36.632Z
8544019 8544019 20251120144255_HWPvu NZ002J 2025-11-22T14:06:48.101Z 2025-11-29T14:53:36.553Z
8543684 8543684 20251120141555_qdbk7 NZ002J 2025-11-22T14:05:50.944Z 2025-11-29T14:53:28.352Z
8543342 8543342 20251120134804_T5hMW NZ002J 2025-11-22T14:04:51.761Z 2025-11-29T14:53:24.831Z
8543184 8543184 20251120133227_Ux6qv NZ002J 2025-11-22T14:04:20.222Z 2025-11-29T14:53:19.240Z
8542889 8542889 20251120130739_4xOaw NZ002J 2025-11-22T14:03:26.709Z 2025-11-29T14:53:16.457Z
8542821 8542821 20251120125603_P9fva NZ002J 2025-11-22T14:03:15.378Z 2025-11-29T14:53:15.933Z
8542784 8542784 20251120125139_rz7x0 NZ002J 2025-11-22T14:03:11.145Z 2025-11-29T14:53:14.963Z
8542580 8542580 20251120122759_6qEhQ NZ002J 2025-11-22T14:02:35.464Z 2025-11-29T14:53:13.084Z
8542528 8542528 20251120122346_WC0Wp NZ002J 2025-11-22T14:02:23.895Z 2025-11-29T14:53:12.699Z
8542524 8542524 20251120122346_NNFDU NZ002J 2025-11-22T14:02:23.662Z 2025-11-29T14:53:12.695Z
8531580 8531580 20251119144248_nAycJ NZ002J 2025-11-21T14:05:39.472Z 2025-11-28T14:53:36.779Z
8531554 8531554 20251119144041_Q7Voh NZ002J 2025-11-21T14:05:33.396Z 2025-11-28T14:53:36.502Z
8531366 8531366 20251119142243_22vuP NZ002J 2025-11-21T14:04:55.661Z 2025-11-28T14:53:33.708Z
8530894 8530894 20251119131732_rQOS3 NZ002J 2025-11-21T14:03:20.948Z 2025-11-28T14:53:26.035Z
8530798 8530798 20251119125857_pG2HW NZ002J 2025-11-21T14:02:56.408Z 2025-11-28T14:53:20.971Z
8530474 8530474 20251119120810_IDKYs NZ002J 2025-11-21T14:01:43.291Z 2025-11-28T14:53:13.678Z
8501590 8501590 20251116112435_9Ogfm NZ002J 2025-11-18T14:47:30.796Z 2025-11-24T15:06:43.724Z
8488836 8488836 20251116150221_dmIw1 NZ002J 2025-11-18T14:07:42.270Z 2025-11-25T15:06:57.833Z
8488819 8488819 20251116150202_3zpqF NZ002J 2025-11-18T14:07:39.490Z 2025-11-25T15:06:57.786Z
8488666 8488666 20251116145024_kT6yf NZ002J 2025-11-18T14:07:15.227Z 2025-11-25T15:06:52.593Z
8488323 8488323 20251116141622_3XpsV NZ002J 2025-11-18T14:06:08.691Z 2025-11-25T15:06:46.111Z
8488319 8488319 20251116141618_PfIOl NZ002J 2025-11-18T14:06:07.713Z 2025-11-25T15:06:46.090Z
8488247 8488247 20251116141034_mimIm NZ002J 2025-11-18T14:05:58.449Z 2025-11-25T15:06:42.989Z
8488244 8488244 20251116141033_4TZQ7 NZ002J 2025-11-18T14:05:57.657Z 2025-11-25T15:06:42.965Z
8488076 8488076 20251116135604_23gJe NZ002J 2025-11-18T14:05:23.123Z 2025-11-25T15:06:36.588Z
8487552 8487552 20251116130338_qByMD NZ002J 2025-11-18T14:03:37.872Z 2025-11-25T15:06:17.435Z
8487546 8487546 20251116130312_onLGe NZ002J 2025-11-18T14:03:37.324Z 2025-11-25T15:06:17.366Z
8486863 8486863 20251116114502_RzMEu NZ002J 2025-11-18T14:00:59.639Z 2025-11-25T15:06:00.988Z
8477554 8477554 20251115154002_ZI0eU NZ002J 2025-11-17T14:11:22.859Z 2025-11-24T15:03:42.090Z
8477403 8477403 20251115153105_0Re2R NZ002J 2025-11-17T14:11:05.982Z 2025-11-24T15:03:36.340Z
8475712 8475712 20251115141024_UjiPt NZ002J 2025-11-17T14:07:14.943Z 2025-11-24T15:03:04.229Z
8475404 8475404 20251115135559_aF98S NZ002J 2025-11-17T14:06:37.214Z 2025-11-24T15:03:02.255Z
8475302 8475302 20251115134855_3vUPb NZ002J 2025-11-17T14:06:26.255Z 2025-11-24T15:03:01.497Z
8475229 8475229 20251115134416_IfsvE NZ002J 2025-11-17T14:06:09.155Z 2025-11-24T15:03:01.045Z
8474783 8474783 20251115132511_NBckt NZ002J 2025-11-17T14:05:22.160Z 2025-11-24T15:02:58.498Z
8472377 8472377 20251114112121_8EUxj NZ002J 2025-11-16T14:33:18.404Z 2025-11-22T15:24:14.862Z
8463607 8463607 20251114132422_rYM07 NZ002J 2025-11-16T14:03:44.492Z 2025-11-23T15:16:00.154Z
8463552 8463552 20251114131940_cs33J NZ002J 2025-11-16T14:03:29.154Z 2025-11-23T15:15:55.805Z
8463392 8463392 20251114130406_yi0SD NZ002J 2025-11-16T14:03:04.056Z 2025-11-23T15:15:51.305Z
8463177 8463177 20251114123815_DY707 NZ002J 2025-11-16T14:02:16.376Z 2025-11-23T15:15:45.647Z
8462728 8462728 20251114115245_dIXFt NZ002J 2025-11-16T14:00:23.929Z 2025-11-23T15:15:30.903Z
8462641 8462641 20251109133234_oOhcy NZ002J 2025-11-15T14:48:10.290Z 2025-11-18T15:18:39.393Z
8442884 8442884 20251111103200_aDKI1 NZ002J 2025-11-13T14:49:44.991Z 2025-11-19T15:18:48.979Z
8431002 8431002 20251111132851_smHzk NZ002J 2025-11-13T14:03:05.717Z 2025-11-20T15:19:47.795Z
8430872 8430872 20251111131700_7xN0n NZ002J 2025-11-13T14:02:41.627Z 2025-11-20T15:19:44.497Z

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