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 = "NZ002P" 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
9609655 9609655 20260405090005_lJeAC NZ002P 2026-04-06T12:03:08.357Z 2026-04-10T12:26:20.649Z
9609598 9609598 20260405083414_pDJnn NZ002P 2026-04-06T12:02:50.967Z 2026-04-10T12:26:19.324Z
9606321 9606321 20260403170451_GcOo3 NZ002P 2026-04-04T12:06:23.146Z 2026-04-10T12:32:27.470Z
9605636 9605636 20260403111451_rgIM5 NZ002P 2026-04-04T12:03:16.807Z 2026-04-10T12:31:41.409Z
9605524 9605524 20260403103114_7WnlR NZ002P 2026-04-04T12:02:46.792Z 2026-04-10T12:31:37.807Z
9605447 9605447 20260403100203_8SDMl NZ002P 2026-04-04T12:02:23.209Z 2026-04-10T12:31:36.176Z
9605346 9605346 20260403085430_fOXwc NZ002P 2026-04-04T12:01:52.005Z 2026-04-10T12:31:33.938Z
9605195 9605195 20260403074943_r0BB4 NZ002P 2026-04-04T12:01:06.306Z 2026-04-10T12:31:30.524Z
9603363 9603363 20260402094402_mDEZA NZ002P 2026-04-03T12:02:43.146Z 2026-04-10T12:34:00.658Z
9603321 9603321 20260402093201_mV4Et NZ002P 2026-04-03T12:02:36.294Z 2026-04-10T12:33:59.944Z
9603206 9603206 20260402084341_HvYD1 NZ002P 2026-04-03T12:02:08.430Z 2026-04-10T12:33:57.923Z
9601671 9601671 20260401162823_h7yI8 NZ002P 2026-04-02T12:03:26.117Z 2026-04-10T12:35:43.434Z
9601606 9601606 20260401160215_5AWdM NZ002P 2026-04-02T12:03:14.877Z 2026-04-10T12:35:42.035Z
9601507 9601507 20260401153117_r1Reo NZ002P 2026-04-02T12:02:57.545Z 2026-04-10T12:35:40.397Z
9601488 9601488 20260401152922_FcPbQ NZ002P 2026-04-02T12:02:55.213Z 2026-04-10T12:35:40.125Z
9601449 9601449 20260401152159_LZFmx NZ002P 2026-04-02T12:02:49.421Z 2026-04-10T12:35:39.250Z
9600870 9600870 20260401072513_NxiUM NZ002P 2026-04-02T12:00:44.665Z 2026-04-10T12:35:24.398Z
9599798 9599798 20260331165402_w1XcW NZ002P 2026-04-01T12:04:52.416Z 2026-04-09T12:47:32.618Z
9599673 9599673 20260331161830_x7BYl NZ002P 2026-04-01T12:04:26.918Z 2026-04-09T12:47:13.988Z
9599434 9599434 20260331143909_GraaR NZ002P 2026-04-01T12:03:35.811Z 2026-04-09T12:46:47.489Z
9599390 9599390 20260331142425_nwm3D NZ002P 2026-04-01T12:03:26.136Z 2026-04-09T12:46:46.943Z
9599381 9599381 20260331142152_bZIKA NZ002P 2026-04-01T12:03:24.117Z 2026-04-09T12:46:46.822Z
9599325 9599325 20260331135855_3f83R NZ002P 2026-04-01T12:03:12.325Z 2026-04-09T12:46:46.006Z
9599318 9599318 20260331135445_XJ38o NZ002P 2026-04-01T12:03:10.391Z 2026-04-09T12:46:45.876Z
9599219 9599219 20260331125619_btF02 NZ002P 2026-04-01T12:02:46.733Z 2026-04-09T12:46:44.188Z
9599127 9599127 20260331115610_lEonM NZ002P 2026-04-01T12:02:28.402Z 2026-04-09T12:46:42.089Z
9599124 9599124 20260331115539_mu7el NZ002P 2026-04-01T12:02:27.377Z 2026-04-09T12:46:42.031Z
9599048 9599048 20260331111555_OwwmI NZ002P 2026-04-01T12:02:11.286Z 2026-04-09T12:46:40.643Z
9599039 9599039 20260331110804_K6qWV NZ002P 2026-04-01T12:02:09.243Z 2026-04-09T12:46:40.496Z
9599030 9599030 20260331105448_XS5H3 NZ002P 2026-04-01T12:02:06.688Z 2026-04-09T12:46:40.230Z
9599017 9599017 20260331104238_MiAAD NZ002P 2026-04-01T12:02:03.627Z 2026-04-09T12:46:39.960Z
9599008 9599008 20260331104002_vRDJ1 NZ002P 2026-04-01T12:02:01.374Z 2026-04-09T12:46:39.813Z
9598821 9598821 20260331074010_p6EmH NZ002P 2026-04-01T12:01:13.048Z 2026-04-09T12:46:36.405Z
9597741 9597741 20260330165520_59I4d NZ002P 2026-03-31T12:06:57.127Z 2026-04-08T12:44:16.512Z
9597702 9597702 20260330165055_BL53F NZ002P 2026-03-31T12:06:53.779Z 2026-04-08T12:44:15.661Z
9597668 9597668 20260330164947_UtEak NZ002P 2026-03-31T12:06:51.658Z 2026-04-08T12:44:14.715Z
9597365 9597365 20260330161126_EogyG NZ002P 2026-03-31T12:06:14.484Z 2026-04-08T12:43:41.416Z
9597242 9597242 20260330154712_8cA27 NZ002P 2026-03-31T12:06:00.526Z 2026-04-08T12:43:36.822Z
9597114 9597114 20260330151847_UR6A0 NZ002P 2026-03-31T12:05:41.194Z 2026-04-08T12:43:33.155Z
9597045 9597045 20260330150633_o8278 NZ002P 2026-03-31T12:05:34.045Z 2026-04-08T12:43:31.537Z
9597023 9597023 20260330150115_yu67m NZ002P 2026-03-31T12:05:30.934Z 2026-04-08T12:43:30.762Z
9596985 9596985 20260330145228_X2oAh NZ002P 2026-03-31T12:05:24.888Z 2026-04-08T12:43:29.529Z
9596828 9596828 20260330141104_arupn NZ002P 2026-03-31T12:05:02.449Z 2026-04-08T12:43:25.374Z
9596814 9596814 20260330140659_6ij5S NZ002P 2026-03-31T12:05:00.948Z 2026-04-08T12:43:25.199Z
9596764 9596764 20260330135651_3Tgyx NZ002P 2026-03-31T12:04:55.199Z 2026-04-08T12:43:23.931Z
9596734 9596734 20260330134939_gJQBL NZ002P 2026-03-31T12:04:51.887Z 2026-04-08T12:43:23.324Z
9596464 9596464 20260330124353_1ktyM NZ002P 2026-03-31T12:04:19.439Z 2026-04-08T12:43:13.620Z
9596462 9596462 20260330124324_cUv7w NZ002P 2026-03-31T12:04:18.909Z 2026-04-08T12:43:13.369Z
9596406 9596406 20260330123106_J17nD NZ002P 2026-03-31T12:04:11.014Z 2026-04-08T12:42:53.479Z
9596355 9596355 20260330122307_furic NZ002P 2026-03-31T12:04:05.279Z 2026-04-08T12:42:50.234Z
9596316 9596316 20260330121858_Nnfrt NZ002P 2026-03-31T12:04:01.325Z 2026-04-08T12:42:49.390Z
9595687 9595687 20260330080350_h3QJt NZ002P 2026-03-31T12:02:12.641Z 2026-04-08T12:42:29.489Z
9595645 9595645 20260330073807_ZR39V NZ002P 2026-03-31T12:02:04.334Z 2026-04-08T12:42:28.154Z
9591517 9591517 20260328170111_Yz7yH NZ002P 2026-03-29T12:04:31.982Z 2026-04-06T12:39:19.350Z
9587270 9587270 20260327115808_QABwV NZ002P 2026-03-28T12:05:10.237Z 2026-04-05T12:34:10.885Z
9587253 9587253 20260327115441_gyPYk NZ002P 2026-03-28T12:05:08.506Z 2026-04-05T12:34:10.226Z
9569605 9569605 20260322162403_oKvs3 NZ002P 2026-03-24T12:21:28.898Z 2026-03-30T12:30:10.763Z
9569595 9569595 20260322162403_E6Lw8 NZ002P 2026-03-24T12:21:28.703Z 2026-03-30T12:30:10.753Z
9569487 9569487 20260322155244_EKz6y NZ002P 2026-03-24T12:21:08.559Z 2026-03-30T12:30:05.388Z
9569471 9569471 20260322154558_s2Ia1 NZ002P 2026-03-24T12:21:05.732Z 2026-03-30T12:30:04.566Z
9568978 9568978 20260322120459_CNxE5 NZ002P 2026-03-24T12:19:17.161Z 2026-03-30T12:29:14.028Z
9567087 9567087 20260323143758_Jo7xf NZ002P 2026-03-24T12:12:58.976Z 2026-03-31T12:28:08.243Z
9567052 9567052 20260323143538_TXlfg NZ002P 2026-03-24T12:12:54.132Z 2026-03-31T12:28:07.707Z
9567041 9567041 20260323143347_bgh6W NZ002P 2026-03-24T12:12:53.370Z 2026-03-31T12:28:07.563Z
9567001 9567001 20260323143145_U3325 NZ002P 2026-03-24T12:12:50.507Z 2026-03-31T12:28:07.083Z
9565298 9565298 20260323115832_aIIsf NZ002P 2026-03-24T12:09:50.031Z 2026-03-31T12:27:32.805Z
9564983 9564983 20260323113402_UVMCh NZ002P 2026-03-24T12:09:11.848Z 2026-03-31T12:27:20.332Z
9564916 9564916 20260323112304_tquP1 NZ002P 2026-03-24T12:09:01.853Z 2026-03-31T12:27:19.045Z
9559070 9559070 20260321162600_fZAY3 NZ002P 2026-03-23T12:10:53.030Z 2026-03-29T12:20:33.634Z
9558958 9558958 20260321160949_Zkx3L NZ002P 2026-03-23T12:10:48.221Z 2026-03-29T12:20:32.365Z
9558016 9558016 20260322153230_K5IJU NZ002P 2026-03-23T12:06:19.771Z 2026-03-30T12:29:54.406Z
9557945 9557945 20260322152016_r6DiE NZ002P 2026-03-23T12:06:16.995Z 2026-03-30T12:29:52.505Z
9557814 9557814 20260322145838_49wZ0 NZ002P 2026-03-23T12:06:11.059Z 2026-03-30T12:29:48.286Z
9557484 9557484 20260322141352_Hhq3U NZ002P 2026-03-23T12:05:52.499Z 2026-03-30T12:29:39.454Z
9557344 9557344 20260322133947_7zned NZ002P 2026-03-23T12:05:46.723Z 2026-03-30T12:29:34.988Z
9557329 9557329 20260322133707_zgci5 NZ002P 2026-03-23T12:05:46.340Z 2026-03-30T12:29:34.817Z
9557261 9557261 20260322132223_c919U NZ002P 2026-03-23T12:05:43.385Z 2026-03-30T12:29:32.866Z
9557255 9557255 20260322132216_IoBbk NZ002P 2026-03-23T12:05:43.201Z 2026-03-30T12:29:32.670Z
9557188 9557188 20260322131331_IGYVY NZ002P 2026-03-23T12:05:40.842Z 2026-03-30T12:29:31.367Z
9557131 9557131 20260322130100_sSpXB NZ002P 2026-03-23T12:05:37.767Z 2026-03-23T12:12:22.674Z
9550785 9550785 20260320171147_1j5It NZ002P 2026-03-22T12:25:44.973Z 2026-03-28T12:36:36.047Z
9550713 9550713 20260320170515_k3M8C NZ002P 2026-03-22T12:25:39.235Z 2026-03-28T12:36:35.356Z
9550684 9550684 20260320165943_a7IOz NZ002P 2026-03-22T12:25:36.398Z 2026-03-28T12:36:34.349Z
9550560 9550560 20260320165124_Z35YP NZ002P 2026-03-22T12:25:30.444Z 2026-03-28T12:36:32.709Z
9550401 9550401 20260320163626_fc9Sm NZ002P 2026-03-22T12:25:13.332Z 2026-03-28T12:36:30.394Z
9550308 9550308 20260320162941_zQDYb NZ002P 2026-03-22T12:25:07.886Z 2026-03-28T12:36:29.438Z
9549164 9549164 20260320084948_DYnLC NZ002P 2026-03-22T12:19:46.745Z 2026-03-28T12:34:54.424Z
9548989 9548989 20260321162947_A4vaR NZ002P 2026-03-22T12:16:22.256Z 2026-03-29T12:20:33.900Z
9548939 9548939 20260321155800_UK3QC NZ002P 2026-03-22T12:16:16.285Z 2026-03-29T12:20:31.085Z
9548930 9548930 20260321155322_CNUU3 NZ002P 2026-03-22T12:16:15.060Z 2026-03-29T12:20:30.801Z
9548622 9548622 20260321152002_JYvAt NZ002P 2026-03-22T12:15:43.921Z 2026-03-29T12:20:27.604Z
9548587 9548587 20260321151646_sgpLk NZ002P 2026-03-22T12:15:37.953Z 2026-03-29T12:20:27.364Z
9548438 9548438 20260321150437_9PFOb NZ002P 2026-03-22T12:15:25.347Z 2026-03-29T12:20:26.442Z
9548358 9548358 20260321145910_Nqn5E NZ002P 2026-03-22T12:15:18.203Z 2026-03-29T12:20:25.621Z
9548097 9548097 20260321143257_01eqR NZ002P 2026-03-22T12:14:53.389Z 2026-03-29T12:20:23.940Z
9546720 9546720 20260321122232_nGvcy NZ002P 2026-03-22T12:12:17.591Z 2026-03-29T12:20:03.452Z
9540075 9540075 20260319124650_VFY76 NZ002P 2026-03-21T12:26:01.878Z 2026-03-27T12:41:57.811Z
9539975 9539975 20260319120014_Jhpds NZ002P 2026-03-21T12:25:41.512Z 2026-03-27T12:41:53.207Z
9539291 9539291 20260320143052_7RSCi NZ002P 2026-03-21T12:19:13.984Z 2026-03-28T12:35:59.062Z
9538706 9538706 20260320133732_zVqdJ NZ002P 2026-03-21T12:18:12.594Z 2026-03-28T12:35:51.766Z

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