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

>10,000 rows count all where station_code = "NZ0019" 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
9626809 9626809 20260408150916_X5kbW NZ0019 2026-04-09T12:09:14.087Z 2026-04-10T12:14:22.417Z
9626745 9626745 20260408150014_aeKaA NZ0019 2026-04-09T12:09:07.222Z 2026-04-10T12:14:22.407Z
9626696 9626696 20260408145235_R8ocR NZ0019 2026-04-09T12:09:03.315Z 2026-04-10T12:14:22.402Z
9626662 9626662 20260408143736_3of7c NZ0019 2026-04-09T12:08:53.280Z 2026-04-10T12:14:22.394Z
9626614 9626614 20260408142750_XnW6t NZ0019 2026-04-09T12:08:47.880Z 2026-04-10T12:14:22.385Z
9626034 9626034 20260408125545_ymnr3 NZ0019 2026-04-09T12:07:22.350Z 2026-04-10T12:14:22.284Z
9625909 9625909 20260408122313_ZBhFw NZ0019 2026-04-09T12:07:05.742Z 2026-04-10T12:14:22.262Z
9625657 9625657 20260408113310_6Vpsp NZ0019 2026-04-09T12:06:13.927Z 2026-04-10T12:14:22.219Z
9604328 9604328 20260402171450_Id3gV NZ0019 2026-04-03T12:06:54.730Z 2026-04-10T12:34:48.138Z
9604318 9604318 20260402170637_0wlW6 NZ0019 2026-04-03T12:06:52.317Z 2026-04-10T12:34:47.873Z
9604263 9604263 20260402164830_3hKUP NZ0019 2026-04-03T12:06:34.712Z 2026-04-10T12:34:46.492Z
9604164 9604164 20260402162030_Ofa3M NZ0019 2026-04-03T12:06:14.983Z 2026-04-10T12:34:44.156Z
9603980 9603980 20260402143541_FTzJV NZ0019 2026-04-03T12:05:25.471Z 2026-04-10T12:34:16.979Z
9603916 9603916 20260402134457_wM6PO NZ0019 2026-04-03T12:05:05.760Z 2026-04-10T12:34:15.519Z
9603612 9603612 20260402112311_DeKqB NZ0019 2026-04-03T12:03:48.733Z 2026-04-10T12:34:05.320Z
9603123 9603123 20260402075844_l1G2g NZ0019 2026-04-03T12:01:54.192Z 2026-04-10T12:33:56.224Z
9602009 9602009 20260401174818_G2Gud NZ0019 2026-04-02T12:04:30.153Z 2026-04-10T12:35:51.823Z
9602000 9602000 20260401174725_ratek NZ0019 2026-04-02T12:04:28.530Z 2026-04-10T12:35:51.232Z
9601996 9601996 20260401174641_efhcw NZ0019 2026-04-02T12:04:27.423Z 2026-04-10T12:35:50.938Z
9601981 9601981 20260401174035_VIYQ9 NZ0019 2026-04-02T12:04:23.646Z 2026-04-10T12:35:50.761Z
9601945 9601945 20260401173332_mJY4c NZ0019 2026-04-02T12:04:16.093Z 2026-04-10T12:35:50.213Z
9601891 9601891 20260401171911_iIfWr NZ0019 2026-04-02T12:04:02.836Z 2026-04-10T12:35:49.115Z
9601826 9601826 20260401170924_I5xVs NZ0019 2026-04-02T12:03:51.381Z 2026-04-10T12:35:48.169Z
9601820 9601820 20260401170837_bfSdJ NZ0019 2026-04-02T12:03:50.618Z 2026-04-10T12:35:48.138Z
9601681 9601681 20260401162915_sXpU8 NZ0019 2026-04-02T12:03:27.021Z 2026-04-10T12:35:43.534Z
9601165 9601165 20260401123724_9yMUc NZ0019 2026-04-02T12:01:50.554Z 2026-04-10T12:35:34.377Z
9601158 9601158 20260401123625_EbEwk NZ0019 2026-04-02T12:01:49.037Z 2026-04-10T12:35:34.316Z
9601031 9601031 20260401104123_ton29 NZ0019 2026-04-02T12:01:20.749Z 2026-04-10T12:35:31.927Z
9600966 9600966 20260401095444_YfwbU NZ0019 2026-04-02T12:01:09.757Z 2026-04-10T12:35:30.834Z
9600942 9600942 20260401091154_cnS9h NZ0019 2026-04-02T12:01:02.435Z 2026-04-10T12:35:30.160Z
9600932 9600932 20260401090216_nn7wN NZ0019 2026-04-02T12:01:00.865Z 2026-04-10T12:35:29.995Z
9600917 9600917 20260401084327_FLLEm NZ0019 2026-04-02T12:00:58.282Z 2026-04-10T12:35:29.651Z
9600904 9600904 20260401082840_RPJVi NZ0019 2026-04-02T12:00:55.522Z 2026-04-10T12:35:29.331Z
9600000 9600000 20260331180005_HjqJR NZ0019 2026-04-01T12:05:33.445Z 2026-04-09T12:48:04.628Z
9599820 9599820 20260331165934_TvYXY NZ0019 2026-04-01T12:04:58.392Z 2026-04-09T12:47:34.688Z
9599746 9599746 20260331163549_z3y2W NZ0019 2026-04-01T12:04:41.678Z 2026-04-09T12:47:22.859Z
9599707 9599707 20260331162727_3Bh97 NZ0019 2026-04-01T12:04:34.732Z 2026-04-09T12:47:16.212Z
9599515 9599515 20260331152309_ze12I NZ0019 2026-04-01T12:03:54.432Z 2026-04-09T12:46:52.557Z
9599504 9599504 20260331151722_3Mp8F NZ0019 2026-04-01T12:03:50.226Z 2026-04-09T12:46:51.829Z
9599418 9599418 20260331143026_NXiQt NZ0019 2026-04-01T12:03:32.033Z 2026-04-09T12:46:47.282Z
9595875 9595875 20260330093804_dL9PV NZ0019 2026-03-31T12:02:44.670Z 2026-04-08T12:42:35.080Z
9595862 9595862 20260330093026_s2M1d NZ0019 2026-03-31T12:02:43.218Z 2026-04-08T12:42:34.668Z
9595791 9595791 20260330084321_44UvP NZ0019 2026-03-31T12:02:31.180Z 2026-04-08T12:42:32.479Z
9593814 9593814 20260329154728_yQnlW NZ0019 2026-03-30T12:05:11.649Z 2026-04-07T12:27:36.784Z
9588032 9588032 20260327174020_AHTPV NZ0019 2026-03-28T12:06:59.623Z 2026-04-05T12:35:05.098Z
9587992 9587992 20260327171432_X9dNW NZ0019 2026-03-28T12:06:52.841Z 2026-04-05T12:35:03.032Z
9587976 9587976 20260327170827_xCW8K NZ0019 2026-03-28T12:06:50.489Z 2026-04-05T12:35:02.207Z
9587957 9587957 20260327165922_KxXQo NZ0019 2026-03-28T12:06:47.431Z 2026-04-05T12:35:01.192Z
9587955 9587955 20260327165849_3iZsm NZ0019 2026-03-28T12:06:47.098Z 2026-04-05T12:35:01.026Z
9587916 9587916 20260327165029_Odlru NZ0019 2026-03-28T12:06:42.887Z 2026-04-05T12:34:59.345Z
9587913 9587913 20260327165029_67D1T NZ0019 2026-03-28T12:06:42.721Z 2026-04-05T12:34:59.282Z
9587905 9587905 20260327164655_oSXt8 NZ0019 2026-03-28T12:06:41.626Z 2026-04-05T12:34:55.969Z
9587864 9587864 20260327162923_jvaD8 NZ0019 2026-03-28T12:06:36.525Z 2026-04-05T12:34:47.291Z
9587833 9587833 20260327162305_EmzZ2 NZ0019 2026-03-28T12:06:29.475Z 2026-04-05T12:34:45.825Z
9587810 9587810 20260327161122_n7tqi NZ0019 2026-03-28T12:06:24.017Z 2026-04-05T12:34:44.565Z
9587801 9587801 20260327160734_h9dJ7 NZ0019 2026-03-28T12:06:22.592Z 2026-04-05T12:34:44.170Z
9587799 9587799 20260327160451_RpBnr NZ0019 2026-03-28T12:06:22.181Z 2026-04-05T12:34:44.032Z
9587794 9587794 20260327160432_VsCKC NZ0019 2026-03-28T12:06:21.658Z 2026-04-05T12:34:43.741Z
9587612 9587612 20260327143432_3hUSg NZ0019 2026-03-28T12:05:55.330Z 2026-04-05T12:34:33.717Z
9587605 9587605 20260327142933_Z8p7z NZ0019 2026-03-28T12:05:54.217Z 2026-04-05T12:34:33.393Z
9587575 9587575 20260327141431_7h25u NZ0019 2026-03-28T12:05:51.055Z 2026-04-05T12:34:32.191Z
9587537 9587537 20260327135027_MbN4K NZ0019 2026-03-28T12:05:46.339Z 2026-04-05T12:34:30.674Z
9587521 9587521 20260327134348_Fazgx NZ0019 2026-03-28T12:05:44.355Z 2026-04-05T12:34:29.981Z
9587469 9587469 20260327131017_88m60 NZ0019 2026-03-28T12:05:36.817Z 2026-04-05T12:34:27.654Z
9587409 9587409 20260327123113_55RHD NZ0019 2026-03-28T12:05:27.282Z 2026-04-05T12:34:25.489Z
9587374 9587374 20260327122012_tklcf NZ0019 2026-03-28T12:05:22.949Z 2026-04-05T12:34:24.188Z
9587234 9587234 20260327114933_MgY3M NZ0019 2026-03-28T12:05:05.259Z 2026-04-05T12:34:09.558Z
9574910 9574910 20260323173647_Q7Yw8 NZ0019 2026-03-25T12:19:51.944Z 2026-03-31T12:28:44.227Z
9574368 9574368 20260324163808_fXkxJ NZ0019 2026-03-25T12:10:24.736Z 2026-04-02T12:36:49.141Z
9568734 9568734 20260323171642_v97aK NZ0019 2026-03-24T12:15:38.937Z 2026-03-31T12:28:41.212Z
9568605 9568605 20260323170224_3B3Sd NZ0019 2026-03-24T12:15:21.919Z 2026-03-31T12:28:38.564Z
9568257 9568257 20260323162547_vjSp9 NZ0019 2026-03-24T12:14:48.058Z 2026-03-31T12:28:26.494Z
9567988 9567988 20260323160426_RvsE9 NZ0019 2026-03-24T12:14:22.019Z 2026-03-31T12:28:21.336Z
9567982 9567982 20260323160347_YwISi NZ0019 2026-03-24T12:14:21.307Z 2026-03-31T12:28:21.251Z
9567874 9567874 20260323155501_x9AHW NZ0019 2026-03-24T12:14:14.806Z 2026-03-31T12:28:19.968Z
9567384 9567384 20260323151228_Wdpyx NZ0019 2026-03-24T12:13:29.467Z 2026-03-31T12:28:13.526Z
9567316 9567316 20260323150547_nRc9G NZ0019 2026-03-24T12:13:22.566Z 2026-03-31T12:28:12.627Z
9567260 9567260 20260323150007_twuBU NZ0019 2026-03-24T12:13:18.480Z 2026-03-31T12:28:11.491Z
9566860 9566860 20260323142003_2BSch NZ0019 2026-03-24T12:12:33.735Z 2026-03-31T12:28:05.220Z
9566740 9566740 20260323140916_d3syN NZ0019 2026-03-24T12:12:22.743Z 2026-03-31T12:27:56.293Z
9566495 9566495 20260323134612_5dh2L NZ0019 2026-03-24T12:11:58.119Z 2026-03-31T12:27:52.827Z
9566075 9566075 20260323130343_xFoev NZ0019 2026-03-24T12:11:18.890Z 2026-03-31T12:27:45.841Z
9565996 9565996 20260323125616_jDNOH NZ0019 2026-03-24T12:11:11.232Z 2026-03-31T12:27:44.569Z
9565893 9565893 20260323124855_Cwjyu NZ0019 2026-03-24T12:10:59.339Z 2026-03-31T12:27:43.011Z
9565796 9565796 20260323124114_lHMD1 NZ0019 2026-03-24T12:10:52.402Z 2026-03-31T12:27:41.618Z
9565777 9565777 20260323124034_2503J NZ0019 2026-03-24T12:10:50.405Z 2026-03-31T12:27:41.228Z
9565594 9565594 20260323122423_9XMBc NZ0019 2026-03-24T12:10:28.302Z 2026-03-31T12:27:38.081Z
9565081 9565081 20260323114247_uIgyt NZ0019 2026-03-24T12:09:22.036Z 2026-03-31T12:27:22.390Z
9565033 9565033 20260323113837_UJUvx NZ0019 2026-03-24T12:09:17.300Z 2026-03-31T12:27:21.505Z
9565019 9565019 20260323113830_P9b61 NZ0019 2026-03-24T12:09:15.944Z 2026-03-31T12:27:21.195Z
9564784 9564784 20260323110809_pIRyP NZ0019 2026-03-24T12:08:47.394Z 2026-03-31T12:27:15.432Z
9564741 9564741 20260323110454_TFNUt NZ0019 2026-03-24T12:08:43.726Z 2026-03-31T12:27:14.695Z
9564615 9564615 20260323105553_tf2iq NZ0019 2026-03-24T12:08:28.081Z 2026-03-31T12:27:12.585Z
9563694 9563694 20260323090132_d3hZO NZ0019 2026-03-24T12:06:35.052Z 2026-03-31T12:26:49.542Z
9563515 9563515 20260323082630_JrY3P NZ0019 2026-03-24T12:06:08.959Z 2026-03-31T12:26:45.981Z
9563393 9563393 20260323081226_xPe58 NZ0019 2026-03-24T12:05:55.066Z 2026-03-31T12:26:42.388Z
9559480 9559480 20260321172544_ghxm8 NZ0019 2026-03-23T12:11:07.295Z 2026-03-29T12:20:39.713Z
9559426 9559426 20260321171626_6W9Sq NZ0019 2026-03-23T12:11:05.470Z 2026-03-29T12:20:39.079Z
9559298 9559298 20260321165442_A7rsJ NZ0019 2026-03-23T12:11:01.091Z 2026-03-29T12:20:36.325Z
9559287 9559287 20260321165312_eaxyw NZ0019 2026-03-23T12:11:00.862Z 2026-03-29T12:20:36.244Z

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