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

7,330 rows where station_code = "NZ0008" 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
9270100 9270100 20260128145550_Vm12h NZ0008 2026-01-29T14:10:50.515Z 2026-01-29T14:10:50.515Z
9269975 9269975 20260128143902_ubUNj NZ0008 2026-01-29T14:10:24.733Z 2026-01-29T14:10:24.733Z
9269941 9269941 20260128143512_eRJO2 NZ0008 2026-01-29T14:10:17.701Z 2026-01-29T14:10:17.701Z
9269935 9269935 20260128143415_8K75K NZ0008 2026-01-29T14:10:16.617Z 2026-01-29T14:10:16.617Z
9269878 9269878 20260128142655_7tr1l NZ0008 2026-01-29T14:10:02.722Z 2026-01-29T14:10:02.722Z
9269828 9269828 20260128141905_Xj0D4 NZ0008 2026-01-29T14:09:47.140Z 2026-01-29T14:09:47.140Z
9269661 9269661 20260128135200_ZZUV2 NZ0008 2026-01-29T14:09:00.232Z 2026-01-29T14:09:00.232Z
9269579 9269579 20260128133937_A963x NZ0008 2026-01-29T14:08:33.220Z 2026-01-29T14:08:33.220Z
9269499 9269499 20260128132803_ekCw1 NZ0008 2026-01-29T14:08:18.125Z 2026-01-29T14:08:18.125Z
9269202 9269202 20260128124446_D39Gp NZ0008 2026-01-29T14:06:58.116Z 2026-01-29T14:06:58.116Z
9268963 9268963 20260128115328_MO8Uc NZ0008 2026-01-29T14:05:44.830Z 2026-01-29T14:05:44.830Z
9268647 9268647 20260128105724_XL3vH NZ0008 2026-01-29T14:04:10.479Z 2026-01-29T14:04:10.479Z
9268541 9268541 20260128104340_JbBOn NZ0008 2026-01-29T14:03:37.079Z 2026-01-29T14:03:37.079Z
9268537 9268537 20260128104339_VaQwK NZ0008 2026-01-29T14:03:36.004Z 2026-01-29T14:03:36.004Z
9268488 9268488 20260128103102_L6GPu NZ0008 2026-01-29T14:03:20.839Z 2026-01-29T14:03:20.839Z
9268397 9268397 20260128100610_72nuh NZ0008 2026-01-29T14:02:49.093Z 2026-01-29T14:02:49.093Z
9265971 9265971 20260127162416_s3Wts NZ0008 2026-01-28T14:11:54.962Z 2026-01-29T14:30:24.803Z
9265872 9265872 20260127160815_lsoqF NZ0008 2026-01-28T14:11:38.518Z 2026-01-29T14:30:24.705Z
9265669 9265669 20260127154633_Lsayd NZ0008 2026-01-28T14:10:55.763Z 2026-01-29T14:30:24.650Z
9265632 9265632 20260127154254_kD58F NZ0008 2026-01-28T14:10:47.341Z 2026-01-29T14:30:24.636Z
9265624 9265624 20260127154229_ZdqAf NZ0008 2026-01-28T14:10:45.947Z 2026-01-29T14:30:24.634Z
9265509 9265509 20260127152319_03u1X NZ0008 2026-01-28T14:10:24.979Z 2026-01-29T14:30:24.595Z
9265303 9265303 20260127145820_CkHm6 NZ0008 2026-01-28T14:09:46.496Z 2026-01-29T14:30:24.523Z
9265216 9265216 20260127144127_naJWS NZ0008 2026-01-28T14:09:32.351Z 2026-01-29T14:30:24.506Z
9265172 9265172 20260127143021_3xsDV NZ0008 2026-01-28T14:09:19.836Z 2026-01-29T14:30:24.484Z
9265082 9265082 20260127141507_8Sc22 NZ0008 2026-01-28T14:08:58.615Z 2026-01-29T14:30:24.433Z
9265070 9265070 20260127141229_L2JrK NZ0008 2026-01-28T14:08:56.272Z 2026-01-29T14:30:24.431Z
9265022 9265022 20260127135655_XPZ59 NZ0008 2026-01-28T14:08:42.257Z 2026-01-29T14:30:24.417Z
9264711 9264711 20260127130058_j5s2C NZ0008 2026-01-28T14:07:19.072Z 2026-01-29T14:30:24.261Z
9264530 9264530 20260127124257_ioXE8 NZ0008 2026-01-28T14:06:35.470Z 2026-01-29T14:30:24.196Z
9257223 9257223 20260125122523_wddNE NZ0008 2026-01-26T14:04:15.363Z 2026-01-29T14:37:00.149Z
9257070 9257070 20260125114803_Zyqb3 NZ0008 2026-01-26T14:03:33.380Z 2026-01-29T14:36:44.834Z
9253679 9253679 20260124134004_XTRE8 NZ0008 2026-01-25T14:03:55.797Z 2026-01-29T14:41:16.227Z
9253494 9253494 20260124121255_aYZuT NZ0008 2026-01-25T14:03:00.485Z 2026-01-29T14:40:53.441Z
9246041 9246041 20260122161027_TbvOP NZ0008 2026-01-23T14:04:34.156Z 2026-01-29T14:50:39.110Z
9245917 9245917 20260122152931_gQ67C NZ0008 2026-01-23T14:04:01.904Z 2026-01-29T14:50:22.527Z
9245881 9245881 20260122151410_xHw6f NZ0008 2026-01-23T14:03:56.312Z 2026-01-29T14:50:20.581Z
9245859 9245859 20260122150405_2rTEt NZ0008 2026-01-23T14:03:46.322Z 2026-01-29T14:50:18.664Z
9245755 9245755 20260122141355_IqEZW NZ0008 2026-01-23T14:03:22.566Z 2026-01-29T14:50:08.831Z
9245725 9245725 20260122140330_m4SX9 NZ0008 2026-01-23T14:03:09.777Z 2026-01-29T14:50:00.303Z
9245720 9245720 20260122140134_iyBxr NZ0008 2026-01-23T14:03:07.384Z 2026-01-29T14:49:59.809Z
9245545 9245545 20260122125845_1WBqB NZ0008 2026-01-23T14:02:20.727Z 2026-01-29T14:49:46.106Z
9245537 9245537 20260122125712_TLV89 NZ0008 2026-01-23T14:02:19.490Z 2026-01-29T14:49:45.707Z
9245485 9245485 20260122124409_Pnjbm NZ0008 2026-01-23T14:02:11.166Z 2026-01-29T14:49:43.502Z
9245252 9245252 20260122112536_upXl1 NZ0008 2026-01-23T14:01:12.826Z 2026-01-29T14:49:18.225Z
9245226 9245226 20260122112112_gEyvn NZ0008 2026-01-23T14:01:08.151Z 2026-01-29T14:49:16.201Z
9231924 9231924 20260119101740_sfmlE NZ0008 2026-01-20T14:34:48.663Z 2026-01-27T15:07:06.171Z
9226336 9226336 20260119114724_H5H0f NZ0008 2026-01-20T14:02:32.630Z 2026-01-28T14:54:55.448Z
9226270 9226270 20260119113825_G8ztf NZ0008 2026-01-20T14:02:09.220Z 2026-01-28T14:54:51.716Z
9226128 9226128 20260119111308_86o1X NZ0008 2026-01-20T14:01:19.025Z 2026-01-28T14:54:36.157Z
9225586 9225586 20260118101837_42EEK NZ0008 2026-01-19T14:29:30.128Z 2026-01-26T15:04:39.097Z
9221394 9221394 20260118153227_MPt3j NZ0008 2026-01-19T14:07:47.480Z 2026-01-27T15:00:12.776Z
9221231 9221231 20260118150935_ubMuF NZ0008 2026-01-19T14:07:10.194Z 2026-01-27T14:59:58.140Z
9221145 9221145 20260118145445_NumNY NZ0008 2026-01-19T14:06:53.630Z 2026-01-27T14:59:55.216Z
9221058 9221058 20260118144516_gAaKO NZ0008 2026-01-19T14:06:41.501Z 2026-01-27T14:59:52.339Z
9221012 9221012 20260118144241_wUVlA NZ0008 2026-01-19T14:06:27.940Z 2026-01-27T14:59:50.631Z
9220993 9220993 20260118143923_8noJ6 NZ0008 2026-01-19T14:06:24.972Z 2026-01-27T14:59:49.994Z
9220976 9220976 20260118143222_nTytM NZ0008 2026-01-19T14:06:20.630Z 2026-01-27T14:59:48.910Z
9220792 9220792 20260118135107_OHacZ NZ0008 2026-01-19T14:05:37.150Z 2026-01-27T14:59:30.020Z
9220731 9220731 20260118133906_7bfqT NZ0008 2026-01-19T14:05:23.175Z 2026-01-27T14:59:26.525Z
9220681 9220681 20260118132706_8fs4x NZ0008 2026-01-19T14:05:13.598Z 2026-01-27T14:59:24.808Z
9220655 9220655 20260118132057_wlG22 NZ0008 2026-01-19T14:05:06.896Z 2026-01-27T14:59:24.079Z
9220547 9220547 20260118130730_U3rpY NZ0008 2026-01-19T14:04:42.356Z 2026-01-27T14:59:20.221Z
9220095 9220095 20260118120558_6DUtq NZ0008 2026-01-19T14:02:41.482Z 2026-01-27T14:58:49.501Z
9219709 9219709 20260118110838_y0WCu NZ0008 2026-01-19T14:00:18.956Z 2026-01-27T14:58:27.824Z
9217043 9217043 20260117141930_z234O NZ0008 2026-01-18T14:04:00.050Z 2026-01-26T14:59:53.732Z
9216489 9216489 20260117120121_FtRlL NZ0008 2026-01-18T14:00:58.136Z 2026-01-26T14:59:16.482Z
9216440 9216440 20260117114840_9FfWZ NZ0008 2026-01-18T14:00:35.310Z 2026-01-26T14:59:14.639Z
9161087 9161087 20260106105150_mSX8M NZ0008 2026-01-07T14:15:06.742Z 2026-01-13T15:10:17.914Z
9160976 9160976 20260106100807_wBj7v NZ0008 2026-01-07T14:14:39.396Z 2026-01-13T15:10:11.396Z
9157058 9157058 20260104145154_2OtOO NZ0008 2026-01-06T14:41:37.467Z 2026-01-12T15:12:50.301Z
9156613 9156613 20260104121242_V2nW7 NZ0008 2026-01-06T14:40:09.431Z 2026-01-12T15:12:19.451Z
9156520 9156520 20260104112423_5mlLj NZ0008 2026-01-06T14:39:49.243Z 2026-01-12T15:12:14.041Z
9156470 9156470 20260104110458_OAvdB NZ0008 2026-01-06T14:39:41.027Z 2026-01-12T15:12:11.709Z
9156330 9156330 20260104094303_tamuO NZ0008 2026-01-06T14:39:16.148Z 2026-01-12T15:12:05.489Z
9153011 9153011 20260105152257_ko00v NZ0008 2026-01-06T14:19:15.784Z 2026-01-13T15:16:51.150Z
9152965 9152965 20260105145443_UTVVp NZ0008 2026-01-06T14:19:05.870Z 2026-01-13T15:16:42.193Z
9152654 9152654 20260105124455_Am5mi NZ0008 2026-01-06T14:18:01.886Z 2026-01-13T15:16:11.637Z
9152639 9152639 20260105123858_Yo9z3 NZ0008 2026-01-06T14:17:57.191Z 2026-01-13T15:16:10.156Z
9152622 9152622 20260105123325_cLSCs NZ0008 2026-01-06T14:17:53.855Z 2026-01-13T15:16:07.989Z
9133770 9133770 20260103151653_AAmuP NZ0008 2026-01-04T14:22:41.269Z 2026-01-10T15:03:42.055Z
9132974 9132974 20260103113926_Aw8kf NZ0008 2026-01-04T14:19:15.568Z 2026-01-10T15:02:18.424Z
9122721 9122721 20260101120843_SYSWw NZ0008 2026-01-02T14:14:40.257Z 2026-01-09T14:53:50.357Z
9122690 9122690 20260101115049_EJ0S0 NZ0008 2026-01-02T14:14:32.112Z 2026-01-09T14:53:48.652Z
9122670 9122670 20260101113752_G7vq4 NZ0008 2026-01-02T14:14:23.262Z 2026-01-09T14:53:41.079Z
9122559 9122559 20260101100229_9TMmW NZ0008 2026-01-02T14:13:45.731Z 2026-01-09T14:53:33.439Z
9097249 9097249 20251227154327_0Aeql NZ0008 2025-12-30T15:08:29.368Z 2026-01-04T15:33:46.627Z
9096862 9096862 20251227151212_ov8Sj NZ0008 2025-12-30T15:08:00.593Z 2026-01-04T15:33:26.539Z
9096678 9096678 20251227150115_My7Qd NZ0008 2025-12-30T15:07:53.191Z 2026-01-04T15:33:20.419Z
9096371 9096371 20251227144523_P3qtA NZ0008 2025-12-30T15:07:25.046Z 2026-01-04T15:33:12.593Z
9096249 9096249 20251227143824_ueu2O NZ0008 2025-12-30T15:07:19.660Z 2026-01-04T15:33:09.344Z
9095941 9095941 20251227141947_RQlnl NZ0008 2025-12-30T15:07:06.832Z 2026-01-04T15:32:47.366Z
9095784 9095784 20251227141048_6zntF NZ0008 2025-12-30T15:07:01.117Z 2026-01-04T15:32:44.257Z
9094929 9094929 20251227131622_epApE NZ0008 2025-12-30T15:05:58.017Z 2026-01-04T15:32:09.694Z
9094924 9094924 20251227131618_QHk4B NZ0008 2025-12-30T15:05:57.682Z 2026-01-04T15:32:09.409Z
9094866 9094866 20251227130620_rCQNb NZ0008 2025-12-30T15:05:54.261Z 2026-01-04T15:32:06.832Z
9094487 9094487 20251227122818_XCw3e NZ0008 2025-12-30T15:05:20.410Z 2026-01-04T15:31:45.284Z
9094161 9094161 20251227114922_3JOX0 NZ0008 2025-12-30T15:05:02.368Z 2026-01-04T15:31:34.970Z
9094106 9094106 20251227113707_2SSw8 NZ0008 2025-12-30T15:04:57.335Z 2026-01-04T15:31:32.600Z
9093856 9093856 20251227105406_UUMna NZ0008 2025-12-30T15:04:26.964Z 2026-01-04T15:31:13.692Z

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