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

8,086 rows where station_code = "NZ001N" 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
9626834 9626834 20260408151231_RkIst NZ001N 2026-04-09T12:09:17.133Z 2026-04-09T12:09:17.133Z
9626647 9626647 20260408143226_AVJi0 NZ001N 2026-04-09T12:08:51.884Z 2026-04-09T12:08:51.884Z
9626644 9626644 20260408143219_8T7vR NZ001N 2026-04-09T12:08:50.782Z 2026-04-09T12:08:50.782Z
9626606 9626606 20260408142709_V9Hka NZ001N 2026-04-09T12:08:46.781Z 2026-04-09T12:08:46.781Z
9626545 9626545 20260408141428_Awfkk NZ001N 2026-04-09T12:08:39.715Z 2026-04-09T12:08:39.715Z
9625938 9625938 20260408123121_R59f0 NZ001N 2026-04-09T12:07:09.203Z 2026-04-09T12:07:09.203Z
9625369 9625369 20260408104116_c7Wqb NZ001N 2026-04-09T12:05:16.421Z 2026-04-09T12:05:16.421Z
9625001 9625001 20260408090946_vDZJT NZ001N 2026-04-09T12:03:46.383Z 2026-04-09T12:03:46.383Z
9611883 9611883 20260330173107_HwvOp NZ001N 2026-04-06T12:32:55.141Z 2026-04-08T12:44:23.371Z
9610096 9610096 20260405125802_bM1ME NZ001N 2026-04-06T12:05:47.765Z 2026-04-09T12:36:21.289Z
9610007 9610007 20260405115043_F7jEE NZ001N 2026-04-06T12:05:14.757Z 2026-04-09T12:36:17.742Z
9606315 9606315 20260403170354_ujVnU NZ001N 2026-04-04T12:06:22.637Z 2026-04-09T12:42:13.980Z
9606308 9606308 20260403170030_uKPRi NZ001N 2026-04-04T12:06:21.112Z 2026-04-09T12:42:13.799Z
9606291 9606291 20260403165908_Tlm6P NZ001N 2026-04-04T12:06:16.938Z 2026-04-09T12:42:13.503Z
9606271 9606271 20260403164737_OsEo0 NZ001N 2026-04-04T12:06:13.862Z 2026-04-09T12:42:13.049Z
9606215 9606215 20260403162232_j3nHz NZ001N 2026-04-04T12:06:00.822Z 2026-04-09T12:42:11.554Z
9605616 9605616 20260403110935_EHZ9L NZ001N 2026-04-04T12:03:07.858Z 2026-04-09T12:41:27.875Z
9605556 9605556 20260403104151_dPEV4 NZ001N 2026-04-04T12:02:53.440Z 2026-04-09T12:41:25.026Z
9605530 9605530 20260403103432_Flxa8 NZ001N 2026-04-04T12:02:48.595Z 2026-04-09T12:41:24.380Z
9605409 9605409 20260403095043_96Imn NZ001N 2026-04-04T12:02:09.685Z 2026-04-09T12:41:21.868Z
9605198 9605198 20260403075000_O3H5g NZ001N 2026-04-04T12:01:06.992Z 2026-04-09T12:41:16.613Z
9603080 9603080 20260402073905_HAAuk NZ001N 2026-04-03T12:01:41.142Z 2026-04-09T12:43:19.443Z
9597999 9597999 20260330172806_Ni2IW NZ001N 2026-03-31T12:07:25.490Z 2026-04-08T12:44:22.796Z
9597983 9597983 20260330172726_CRu6d NZ001N 2026-03-31T12:07:23.802Z 2026-04-08T12:44:22.412Z
9597804 9597804 20260330170038_CI2P8 NZ001N 2026-03-31T12:07:02.225Z 2026-04-08T12:44:17.907Z
9597322 9597322 20260330160358_eU3Ia NZ001N 2026-03-31T12:06:09.455Z 2026-04-08T12:43:40.445Z
9597221 9597221 20260330154033_rf9ua NZ001N 2026-03-31T12:05:57.769Z 2026-04-08T12:43:36.171Z
9595680 9595680 20260330075907_lvc3a NZ001N 2026-03-31T12:02:11.620Z 2026-04-08T12:42:29.344Z
9593985 9593985 20260329172823_CNI50 NZ001N 2026-03-30T12:05:44.013Z 2026-04-07T12:27:41.945Z
9593979 9593979 20260329172338_sFlgG NZ001N 2026-03-30T12:05:42.427Z 2026-04-07T12:27:41.697Z
9591625 9591625 20260328173752_hFoK0 NZ001N 2026-03-29T12:04:45.903Z 2026-04-06T12:39:26.020Z
9591556 9591556 20260328170851_JtkPW NZ001N 2026-03-29T12:04:36.345Z 2026-04-06T12:39:22.745Z
9591547 9591547 20260328170715_eMYcQ NZ001N 2026-03-29T12:04:35.779Z 2026-04-06T12:39:22.574Z
9591483 9591483 20260328165202_nuIfH NZ001N 2026-03-29T12:04:29.810Z 2026-04-06T12:39:17.868Z
9591479 9591479 20260328165129_GFnmM NZ001N 2026-03-29T12:04:29.529Z 2026-04-06T12:39:17.725Z
9591404 9591404 20260328162423_o1i0R NZ001N 2026-03-29T12:04:21.998Z 2026-04-06T12:39:14.328Z
9591359 9591359 20260328155710_Frtbu NZ001N 2026-03-29T12:04:18.341Z 2026-04-06T12:39:12.318Z
9591355 9591355 20260328155307_QjlKc NZ001N 2026-03-29T12:04:18.097Z 2026-04-06T12:39:12.237Z
9591332 9591332 20260328154011_PX3B0 NZ001N 2026-03-29T12:04:15.851Z 2026-04-06T12:39:11.209Z
9591321 9591321 20260328153424_o7xvE NZ001N 2026-03-29T12:04:15.001Z 2026-04-06T12:39:10.876Z
9591315 9591315 20260328153424_JyHBr NZ001N 2026-03-29T12:04:14.765Z 2026-04-06T12:39:10.762Z
9591274 9591274 20260328150916_WaJra NZ001N 2026-03-29T12:04:09.222Z 2026-04-06T12:39:08.754Z
9591245 9591245 20260328150006_F7LMH NZ001N 2026-03-29T12:04:05.325Z 2026-04-06T12:39:07.669Z
9591233 9591233 20260328144744_VVhaQ NZ001N 2026-03-29T12:04:03.825Z 2026-04-06T12:39:06.752Z
9591219 9591219 20260328143559_glflg NZ001N 2026-03-29T12:04:02.473Z 2026-04-06T12:39:06.150Z
9591215 9591215 20260328143437_6hrFQ NZ001N 2026-03-29T12:04:01.785Z 2026-04-06T12:39:05.910Z
9591065 9591065 20260328125700_FJGqG NZ001N 2026-03-29T12:03:47.162Z 2026-04-06T12:38:49.388Z
9591057 9591057 20260328125032_mmkb3 NZ001N 2026-03-29T12:03:46.356Z 2026-04-06T12:38:48.969Z
9591047 9591047 20260328124736_A94ui NZ001N 2026-03-29T12:03:42.947Z 2026-04-06T12:38:48.428Z
9588025 9588025 20260327173252_D8JaN NZ001N 2026-03-28T12:06:58.142Z 2026-04-05T12:35:04.804Z
9588022 9588022 20260327173120_6y9nq NZ001N 2026-03-28T12:06:57.603Z 2026-04-05T12:35:04.644Z
9588007 9588007 20260327171759_EgnfN NZ001N 2026-03-28T12:06:54.569Z 2026-04-05T12:35:03.741Z
9587695 9587695 20260327151007_dtNT8 NZ001N 2026-03-28T12:06:09.493Z 2026-04-05T12:34:37.668Z
9587688 9587688 20260327150741_W2vg9 NZ001N 2026-03-28T12:06:08.592Z 2026-04-05T12:34:37.462Z
9587666 9587666 20260327145757_z12Vd NZ001N 2026-03-28T12:06:03.493Z 2026-04-05T12:34:36.082Z
9587615 9587615 20260327143436_EQeK3 NZ001N 2026-03-28T12:05:55.659Z 2026-04-05T12:34:33.845Z
9587440 9587440 20260327124902_FFYC1 NZ001N 2026-03-28T12:05:31.672Z 2026-04-05T12:34:26.586Z
9587353 9587353 20260327121526_kHICd NZ001N 2026-03-28T12:05:20.756Z 2026-04-05T12:34:23.341Z
9587076 9587076 20260327110456_e4vNF NZ001N 2026-03-28T12:04:44.042Z 2026-04-05T12:34:01.002Z
9587055 9587055 20260327110010_rkQ2O NZ001N 2026-03-28T12:04:41.987Z 2026-04-05T12:34:00.397Z
9586864 9586864 20260327100156_8z4oz NZ001N 2026-03-28T12:04:15.249Z 2026-04-05T12:33:52.378Z
9586597 9586597 20260327083636_coqlg NZ001N 2026-03-28T12:03:31.252Z 2026-04-05T12:33:32.116Z
9586593 9586593 20260327083619_uU4FM NZ001N 2026-03-28T12:03:30.589Z 2026-04-05T12:33:31.879Z
9566524 9566524 20260323134937_QxSty NZ001N 2026-03-24T12:12:02.013Z 2026-03-31T12:27:53.284Z
9566483 9566483 20260323134319_sGFm9 NZ001N 2026-03-24T12:11:57.248Z 2026-03-31T12:27:52.653Z
9566161 9566161 20260323131019_8DGoe NZ001N 2026-03-24T12:11:24.894Z 2026-03-31T12:27:46.814Z
9566032 9566032 20260323130059_I6z6b NZ001N 2026-03-24T12:11:14.658Z 2026-03-31T12:27:45.075Z
9565918 9565918 20260323125136_Ya1hC NZ001N 2026-03-24T12:11:01.660Z 2026-03-31T12:27:43.494Z
9565832 9565832 20260323124245_ehGkC NZ001N 2026-03-24T12:10:55.319Z 2026-03-31T12:27:42.176Z
9565452 9565452 20260323121011_Zgw33 NZ001N 2026-03-24T12:10:09.240Z 2026-03-31T12:27:35.530Z
9565369 9565369 20260323120307_bwLXy NZ001N 2026-03-24T12:09:57.775Z 2026-03-31T12:27:33.830Z
9565043 9565043 20260323114055_oW2VR NZ001N 2026-03-24T12:09:18.758Z 2026-03-31T12:27:21.822Z
9564852 9564852 20260323111330_Um8ca NZ001N 2026-03-24T12:08:54.097Z 2026-03-31T12:27:16.500Z
9564357 9564357 20260323102740_QTm4t NZ001N 2026-03-24T12:07:55.815Z 2026-03-31T12:27:07.776Z
9564272 9564272 20260323102006_L8uSH NZ001N 2026-03-24T12:07:47.207Z 2026-03-31T12:27:06.522Z
9564250 9564250 20260323101900_ZSUNL NZ001N 2026-03-24T12:07:44.233Z 2026-03-31T12:27:06.159Z
9559231 9559231 20260321164828_JIy7k NZ001N 2026-03-23T12:10:58.586Z 2026-03-29T12:20:35.524Z
9559076 9559076 20260321162600_X58Zh NZ001N 2026-03-23T12:10:53.116Z 2026-03-29T12:20:33.650Z
9559034 9559034 20260321162119_nYLOR NZ001N 2026-03-23T12:10:52.112Z 2026-03-29T12:20:33.371Z
9558666 9558666 20260322172216_9ZmWZ NZ001N 2026-03-23T12:06:53.862Z 2026-03-30T12:30:19.918Z
9558648 9558648 20260322171827_kgfyc NZ001N 2026-03-23T12:06:52.993Z 2026-03-30T12:30:19.474Z
9558627 9558627 20260322171404_jtonw NZ001N 2026-03-23T12:06:52.021Z 2026-03-30T12:30:18.743Z
9558579 9558579 20260322170231_DME2W NZ001N 2026-03-23T12:06:49.853Z 2026-03-30T12:30:17.239Z
9558487 9558487 20260322164942_jQCOj NZ001N 2026-03-23T12:06:46.459Z 2026-03-30T12:30:15.115Z
9558418 9558418 20260322163741_HV535 NZ001N 2026-03-23T12:06:43.132Z 2026-03-30T12:30:13.285Z
9558413 9558413 20260322163521_B2oEA NZ001N 2026-03-23T12:06:42.805Z 2026-03-30T12:30:12.847Z
9558172 9558172 20260322160032_VTeLz NZ001N 2026-03-23T12:06:28.103Z 2026-03-30T12:30:06.680Z
9558150 9558150 20260322155744_gqFOA NZ001N 2026-03-23T12:06:26.928Z 2026-03-30T12:30:06.027Z
9557953 9557953 20260322152340_x9MCd NZ001N 2026-03-23T12:06:17.177Z 2026-03-30T12:29:52.998Z
9557904 9557904 20260322151339_4s6sp NZ001N 2026-03-23T12:06:14.972Z 2026-03-30T12:29:51.202Z
9557876 9557876 20260322151105_ops7O NZ001N 2026-03-23T12:06:13.844Z 2026-03-30T12:29:50.663Z
9557711 9557711 20260322144403_6O33s NZ001N 2026-03-23T12:06:06.551Z 2026-03-30T12:29:45.792Z
9557572 9557572 20260322142640_VAVPZ NZ001N 2026-03-23T12:05:56.983Z 2026-03-30T12:29:42.126Z
9557461 9557461 20260322140642_XE1jp NZ001N 2026-03-23T12:05:51.135Z 2026-03-30T12:29:38.507Z
9557457 9557457 20260322140243_yLElS NZ001N 2026-03-23T12:05:50.873Z 2026-03-30T12:29:38.208Z
9557427 9557427 20260322135755_cEAXS NZ001N 2026-03-23T12:05:49.775Z 2026-03-30T12:29:37.267Z
9557269 9557269 20260322132238_TWMUx NZ001N 2026-03-23T12:05:43.729Z 2026-03-30T12:29:33.013Z
9556970 9556970 20260322122720_ymyd2 NZ001N 2026-03-23T12:05:25.767Z 2026-03-30T12:29:17.837Z
9556936 9556936 20260322121401_lB7oe NZ001N 2026-03-23T12:05:22.019Z 2026-03-30T12:29:15.300Z
9556640 9556640 20260322111541_n3qL8 NZ001N 2026-03-23T12:05:04.472Z 2026-03-30T12:29:06.862Z

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