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

653 rows where station_code = "NZ005J" 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
9270639 9270639 20260128161707_sHGIm NZ005J 2026-01-29T14:13:09.823Z 2026-01-29T14:13:09.823Z
9270283 9270283 20260128152522_JYtQh NZ005J 2026-01-29T14:11:31.811Z 2026-01-29T14:11:31.811Z
9270203 9270203 20260128151420_LVv0Y NZ005J 2026-01-29T14:11:18.161Z 2026-01-29T14:11:18.161Z
9270188 9270188 20260128150930_SruCA NZ005J 2026-01-29T14:11:13.844Z 2026-01-29T14:11:13.844Z
9270102 9270102 20260128145550_Vm12h NZ005J 2026-01-29T14:10:50.515Z 2026-01-29T14:10:50.515Z
9270006 9270006 20260128144320_iMXI8 NZ005J 2026-01-29T14:10:36.919Z 2026-01-29T14:10:36.919Z
9269958 9269958 20260128143717_BbXEG NZ005J 2026-01-29T14:10:20.616Z 2026-01-29T14:10:20.616Z
9269937 9269937 20260128143415_8K75K NZ005J 2026-01-29T14:10:16.617Z 2026-01-29T14:10:16.617Z
9268891 9268891 20260128113818_2Qsfr NZ005J 2026-01-29T14:05:19.767Z 2026-01-29T14:05:19.767Z
9268886 9268886 20260128113818_Cnj3s NZ005J 2026-01-29T14:05:19.017Z 2026-01-29T14:05:19.017Z
9268789 9268789 20260128112243_UrcPx NZ005J 2026-01-29T14:04:52.989Z 2026-01-29T14:04:52.989Z
9268154 9268154 20260128090540_S3BqB NZ005J 2026-01-29T14:01:25.394Z 2026-01-29T14:01:25.394Z
9268130 9268130 20260128085715_ij2Xa NZ005J 2026-01-29T14:01:15.870Z 2026-01-29T14:01:15.870Z
9265671 9265671 20260127154633_Lsayd NZ005J 2026-01-28T14:10:55.763Z 2026-01-29T14:30:24.650Z
9265628 9265628 20260127154229_ZdqAf NZ005J 2026-01-28T14:10:45.947Z 2026-01-29T14:30:24.634Z
9265615 9265615 20260127153823_9uFWZ NZ005J 2026-01-28T14:10:43.958Z 2026-01-29T14:30:24.622Z
9265589 9265589 20260127153623_KoAfb NZ005J 2026-01-28T14:10:38.469Z 2026-01-29T14:30:24.618Z
9265544 9265544 20260127153049_u0CtK NZ005J 2026-01-28T14:10:29.861Z 2026-01-29T14:30:24.602Z
9265510 9265510 20260127152319_03u1X NZ005J 2026-01-28T14:10:24.979Z 2026-01-29T14:30:24.595Z
9265448 9265448 20260127151634_z3srJ NZ005J 2026-01-28T14:10:11.654Z 2026-01-29T14:30:24.551Z
9265294 9265294 20260127145740_9Ea2q NZ005J 2026-01-28T14:09:45.327Z 2026-01-29T14:30:24.521Z
9265217 9265217 20260127144127_naJWS NZ005J 2026-01-28T14:09:32.351Z 2026-01-29T14:30:24.506Z
9265202 9265202 20260127143632_K37In NZ005J 2026-01-28T14:09:26.452Z 2026-01-29T14:30:24.500Z
9265085 9265085 20260127141507_8Sc22 NZ005J 2026-01-28T14:08:58.615Z 2026-01-29T14:30:24.433Z
9265059 9265059 20260127141018_ZIJqp NZ005J 2026-01-28T14:08:52.697Z 2026-01-29T14:30:24.428Z
9265024 9265024 20260127135655_XPZ59 NZ005J 2026-01-28T14:08:42.257Z 2026-01-29T14:30:24.417Z
9264902 9264902 20260127133132_X2eku NZ005J 2026-01-28T14:08:12.403Z 2026-01-29T14:30:24.323Z
9264747 9264747 20260127130521_5Gyn8 NZ005J 2026-01-28T14:07:27.812Z 2026-01-29T14:30:24.269Z
9264733 9264733 20260127130331_Isi2V NZ005J 2026-01-28T14:07:23.930Z 2026-01-29T14:30:24.265Z
9264712 9264712 20260127130058_j5s2C NZ005J 2026-01-28T14:07:19.072Z 2026-01-29T14:30:24.261Z
9264351 9264351 20260127120512_lDqWa NZ005J 2026-01-28T14:05:37.703Z 2026-01-29T14:30:20.874Z
9264137 9264137 20260127112008_3M6cq NZ005J 2026-01-28T14:04:34.138Z 2026-01-29T14:30:20.070Z
9227157 9227157 20260119145131_8Wtnf NZ005J 2026-01-20T14:06:51.188Z 2026-01-28T14:55:54.541Z
9227138 9227138 20260119144441_2TUR7 NZ005J 2026-01-20T14:06:44.373Z 2026-01-28T14:55:53.452Z
9227077 9227077 20260119142340_ZTfMa NZ005J 2026-01-20T14:06:28.006Z 2026-01-28T14:55:50.193Z
9219324 9219324 20260117095657_BViY3 NZ005J 2026-01-18T14:15:55.781Z 2026-01-25T14:59:10.519Z
9192813 9192813 20260112130338_QN9xJ NZ005J 2026-01-13T14:29:21.266Z 2026-01-20T15:26:34.071Z
9192453 9192453 20260112123626_BiyIn NZ005J 2026-01-13T14:28:25.733Z 2026-01-20T15:26:22.668Z
9192249 9192249 20260112121538_cbp2T NZ005J 2026-01-13T14:27:51.667Z 2026-01-20T15:26:16.018Z
9191807 9191807 20260112114548_kumOf NZ005J 2026-01-13T14:26:28.275Z 2026-01-20T15:25:47.299Z
9191750 9191750 20260112114209_i5SyR NZ005J 2026-01-13T14:26:18.320Z 2026-01-20T15:25:45.668Z
9191600 9191600 20260112112323_FT5a4 NZ005J 2026-01-13T14:25:49.958Z 2026-01-20T15:25:39.942Z
9191092 9191092 20260112103242_3fm05 NZ005J 2026-01-13T14:24:25.351Z 2026-01-20T15:25:09.790Z
9190999 9190999 20260112102630_4FBCv NZ005J 2026-01-13T14:24:08.505Z 2026-01-20T15:25:07.193Z
9186848 9186848 20260112155044_yM2GH NZ005J 2026-01-13T14:03:43.356Z 2026-01-21T15:03:02.893Z
9186645 9186645 20260112151424_v4NhU NZ005J 2026-01-13T14:02:49.800Z 2026-01-21T15:02:49.029Z
9186633 9186633 20260112151348_r3q5U NZ005J 2026-01-13T14:02:48.081Z 2026-01-21T15:02:48.784Z
9186618 9186618 20260112150700_psyZR NZ005J 2026-01-13T14:02:43.539Z 2026-01-21T15:02:47.344Z
9173252 9173252 20260109132724_5mm0a NZ005J 2026-01-10T14:16:51.945Z 2026-01-17T15:26:24.716Z
9170545 9170545 20260109154012_blMBX NZ005J 2026-01-10T14:01:13.002Z 2026-01-18T15:06:27.442Z
9170422 9170422 20260109151252_Cz2ci NZ005J 2026-01-10T14:00:27.466Z 2026-01-18T15:06:20.376Z
9169477 9169477 20260108144232_m3ox5 NZ005J 2026-01-09T14:13:39.206Z 2026-01-16T15:14:01.595Z
9169243 9169243 20260108134813_dUkVl NZ005J 2026-01-09T14:13:06.913Z 2026-01-16T15:13:47.385Z
9168715 9168715 20260108120615_4Bcb4 NZ005J 2026-01-09T14:11:48.477Z 2026-01-09T14:11:48.477Z
9165458 9165458 20260107155115_Hu1c2 NZ005J 2026-01-08T14:16:29.671Z 2026-01-13T15:05:57.330Z
9165350 9165350 20260107153115_8Zljj NZ005J 2026-01-08T14:16:11.551Z 2026-01-13T15:05:48.706Z
9165263 9165263 20260107152329_pevrI NZ005J 2026-01-08T14:15:52.690Z 2026-01-13T15:05:37.433Z
9165205 9165205 20260107151712_Q1E22 NZ005J 2026-01-08T14:15:40.329Z 2026-01-13T15:05:35.206Z
9165063 9165063 20260107150029_gnP6D NZ005J 2026-01-08T14:15:17.211Z 2026-01-13T15:05:27.091Z
9165038 9165038 20260107145458_2vuUt NZ005J 2026-01-08T14:15:11.829Z 2026-01-13T15:05:25.035Z
9164431 9164431 20260107131408_QAjr2 NZ005J 2026-01-08T14:13:07.747Z 2026-01-13T15:04:34.736Z
9164261 9164261 20260107124136_jiekJ NZ005J 2026-01-08T14:12:30.090Z 2026-01-13T15:04:22.914Z
9164232 9164232 20260107123746_oGlDv NZ005J 2026-01-08T14:12:26.007Z 2026-01-13T15:04:21.721Z
9164229 9164229 20260107123744_vfeCZ NZ005J 2026-01-08T14:12:25.392Z 2026-01-13T15:04:21.514Z
9163847 9163847 20260107104857_vZR8Z NZ005J 2026-01-08T14:10:46.684Z 2026-01-13T15:03:42.885Z
9161451 9161451 20260106130959_TngLO NZ005J 2026-01-07T14:16:36.671Z 2026-01-13T15:10:47.684Z
9160941 9160941 20260106095729_s2lSi NZ005J 2026-01-07T14:14:26.563Z 2026-01-13T15:10:01.853Z
9160904 9160904 20260106094404_QibWG NZ005J 2026-01-07T14:14:19.615Z 2026-01-13T15:10:00.242Z
9156833 9156833 20260104133630_0HSGE NZ005J 2026-01-06T14:40:56.037Z 2026-01-12T15:12:39.248Z
9156474 9156474 20260104110458_OAvdB NZ005J 2026-01-06T14:39:41.027Z 2026-01-12T15:12:11.709Z
9156332 9156332 20260104094303_tamuO NZ005J 2026-01-06T14:39:16.148Z 2026-01-12T15:12:05.489Z
9153000 9153000 20260105151436_2HI3D NZ005J 2026-01-06T14:19:12.415Z 2026-01-13T15:16:43.782Z
9152767 9152767 20260105131821_tFSZz NZ005J 2026-01-06T14:18:26.208Z 2026-01-13T15:16:27.060Z
9152731 9152731 20260105130407_QQTIl NZ005J 2026-01-06T14:18:17.659Z 2026-01-13T15:16:24.415Z
9152690 9152690 20260105125321_cc8a4 NZ005J 2026-01-06T14:18:11.815Z 2026-01-13T15:16:13.675Z
9152039 9152039 20260105090931_xizgA NZ005J 2026-01-06T14:15:35.395Z 2026-01-13T15:15:27.081Z
9133451 9133451 20260103130516_VEKu8 NZ005J 2026-01-04T14:20:50.809Z 2026-01-10T15:02:56.247Z
9132813 9132813 20260103104622_bFSsF NZ005J 2026-01-04T14:18:27.619Z 2026-01-10T15:02:02.822Z
9120099 9120099 20251228113835_n2VWR NZ005J 2026-01-01T15:28:15.432Z 2026-01-05T15:11:48.055Z
9096693 9096693 20251227150149_wuUmA NZ005J 2025-12-30T15:07:53.530Z 2026-01-04T15:33:20.704Z
9096582 9096582 20251227145443_bZm3R NZ005J 2025-12-30T15:07:48.704Z 2026-01-04T15:33:17.939Z
9095787 9095787 20251227141048_6zntF NZ005J 2025-12-30T15:07:01.117Z 2026-01-04T15:32:44.257Z
9095722 9095722 20251227140635_UKY2W NZ005J 2025-12-30T15:06:44.330Z 2026-01-04T15:32:42.184Z
9095605 9095605 20251227140049_Wh3CP NZ005J 2025-12-30T15:06:39.196Z 2026-01-04T15:32:38.731Z
9094925 9094925 20251227131618_QHk4B NZ005J 2025-12-30T15:05:57.682Z 2026-01-04T15:32:09.409Z
9094632 9094632 20251227124319_U32yJ NZ005J 2025-12-30T15:05:42.485Z 2026-01-04T15:31:59.431Z
9094424 9094424 20251227122259_90UuS NZ005J 2025-12-30T15:05:15.198Z 2026-01-04T15:31:42.494Z
9094256 9094256 20251227120051_h3Eo2 NZ005J 2025-12-30T15:05:07.273Z 2026-01-04T15:31:37.662Z
9094136 9094136 20251227114105_2LzO6 NZ005J 2025-12-30T15:04:59.866Z 2026-01-04T15:31:33.518Z
9093858 9093858 20251227105406_UUMna NZ005J 2025-12-30T15:04:26.965Z 2026-01-04T15:31:13.692Z
9093566 9093566 20251227100223_lWScx NZ005J 2025-12-30T15:03:55.735Z 2026-01-04T15:31:02.385Z
9093553 9093553 20251227095411_Ylg4f NZ005J 2025-12-30T15:03:53.760Z 2026-01-04T15:31:01.491Z
9093501 9093501 20251227093107_aSzyb NZ005J 2025-12-30T15:03:48.924Z 2026-01-04T15:30:59.667Z
9090215 9090215 20251228144338_arIpY NZ005J 2025-12-30T14:49:52.804Z 2026-01-05T15:13:03.790Z
9090060 9090060 20251228143006_i9oI3 NZ005J 2025-12-30T14:49:37.708Z 2026-01-05T15:13:00.330Z
9089903 9089903 20251228140706_teoGB NZ005J 2025-12-30T14:49:16.760Z 2026-01-05T15:12:56.544Z
9089763 9089763 20251228134726_UOW63 NZ005J 2025-12-30T14:49:05.813Z 2026-01-05T15:12:53.214Z
9089684 9089684 20251228133509_AaSZ7 NZ005J 2025-12-30T14:48:58.246Z 2026-01-05T15:12:50.546Z
9089674 9089674 20251228133433_J0Q20 NZ005J 2025-12-30T14:48:57.795Z 2026-01-05T15:12:50.344Z
9089651 9089651 20251228133343_Kfzfz NZ005J 2025-12-30T14:48:49.390Z 2026-01-05T15:12:49.871Z

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