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

1,300 rows where station_code = "NZ005T" 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
9626769 9626769 20260408150158_2J11c NZ005T 2026-04-09T12:09:09.102Z 2026-04-10T12:14:22.410Z
9626764 9626764 20260408150100_LANIy NZ005T 2026-04-09T12:09:08.606Z 2026-04-10T12:14:22.409Z
9626633 9626633 20260408142914_sz32p NZ005T 2026-04-09T12:08:48.900Z 2026-04-10T12:14:22.385Z
9626370 9626370 20260408134648_DauvQ NZ005T 2026-04-09T12:08:12.534Z 2026-04-10T12:14:22.340Z
9626319 9626319 20260408134147_2sYUZ NZ005T 2026-04-09T12:07:59.479Z 2026-04-10T12:14:22.333Z
9626202 9626202 20260408132400_QCzf0 NZ005T 2026-04-09T12:07:45.556Z 2026-04-10T12:14:22.316Z
9626186 9626186 20260408132247_nVUHv NZ005T 2026-04-09T12:07:44.327Z 2026-04-10T12:14:22.314Z
9626146 9626146 20260408131735_9oYft NZ005T 2026-04-09T12:07:40.773Z 2026-04-10T12:14:22.309Z
9626105 9626105 20260408131125_z2XNH NZ005T 2026-04-09T12:07:35.271Z 2026-04-10T12:14:22.296Z
9625981 9625981 20260408124610_htOla NZ005T 2026-04-09T12:07:14.142Z 2026-04-10T12:14:22.275Z
9625900 9625900 20260408122303_BTFwd NZ005T 2026-04-09T12:07:04.723Z 2026-04-10T12:14:22.261Z
9625873 9625873 20260408121946_hJNuM NZ005T 2026-04-09T12:07:01.869Z 2026-04-10T12:14:22.257Z
9625805 9625805 20260408115527_0zcu3 NZ005T 2026-04-09T12:06:46.911Z 2026-04-10T12:14:22.245Z
9625674 9625674 20260408113400_JUUP3 NZ005T 2026-04-09T12:06:16.276Z 2026-04-10T12:14:22.222Z
9606372 9606372 20260403173655_tTH5F NZ005T 2026-04-04T12:06:37.242Z 2026-04-10T12:32:28.748Z
9606230 9606230 20260403162840_X58ve NZ005T 2026-04-04T12:06:06.242Z 2026-04-10T12:32:25.499Z
9606154 9606154 20260403154737_338s6 NZ005T 2026-04-04T12:05:38.235Z 2026-04-10T12:32:22.923Z
9606031 9606031 20260403142641_bfA1a NZ005T 2026-04-04T12:05:01.480Z 2026-04-10T12:32:19.419Z
9605988 9605988 20260403134016_cRu2p NZ005T 2026-04-04T12:04:46.388Z 2026-04-10T12:32:18.016Z
9605981 9605981 20260403133937_4A0m0 NZ005T 2026-04-04T12:04:45.412Z 2026-04-10T12:32:17.948Z
9605690 9605690 20260403112817_G5V2X NZ005T 2026-04-04T12:03:28.765Z 2026-04-10T12:31:43.620Z
9604204 9604204 20260402163119_9PDKm NZ005T 2026-04-03T12:06:21.991Z 2026-04-10T12:34:45.138Z
9604034 9604034 20260402151023_Adslo NZ005T 2026-04-03T12:05:43.233Z 2026-04-10T12:34:18.033Z
9603804 9603804 20260402124416_Z5NIY NZ005T 2026-04-03T12:04:43.088Z 2026-04-10T12:34:10.009Z
9603695 9603695 20260402115259_DIclS NZ005T 2026-04-03T12:04:12.191Z 2026-04-10T12:34:07.444Z
9603139 9603139 20260402075941_aYr2i NZ005T 2026-04-03T12:01:56.200Z 2026-04-10T12:33:56.521Z
9601750 9601750 20260401165138_59qoL NZ005T 2026-04-02T12:03:35.129Z 2026-04-10T12:35:46.776Z
9601553 9601553 20260401154414_3SMh2 NZ005T 2026-04-02T12:03:04.419Z 2026-04-10T12:35:41.020Z
9601247 9601247 20260401133221_QEUgc NZ005T 2026-04-02T12:02:07.188Z 2026-04-10T12:35:35.488Z
9601115 9601115 20260401115909_7iEr8 NZ005T 2026-04-02T12:01:38.853Z 2026-04-10T12:35:33.375Z
9599275 9599275 20260331133710_zBhZ2 NZ005T 2026-04-01T12:02:59.450Z 2026-04-09T12:46:45.269Z
9597827 9597827 20260330170145_a512v NZ005T 2026-03-31T12:07:03.326Z 2026-04-08T12:44:18.112Z
9597717 9597717 20260330165223_lGO34 NZ005T 2026-03-31T12:06:55.257Z 2026-04-08T12:44:16.044Z
9597697 9597697 20260330165016_I172A NZ005T 2026-03-31T12:06:53.367Z 2026-04-08T12:44:15.560Z
9597601 9597601 20260330164128_8WUkE NZ005T 2026-03-31T12:06:45.279Z 2026-04-08T12:43:56.918Z
9597575 9597575 20260330163622_XcMLz NZ005T 2026-03-31T12:06:39.301Z 2026-04-08T12:43:50.208Z
9597550 9597550 20260330163441_Vtk6C NZ005T 2026-03-31T12:06:36.218Z 2026-04-08T12:43:48.844Z
9597528 9597528 20260330162927_KWbfg NZ005T 2026-03-31T12:06:32.415Z 2026-04-08T12:43:44.905Z
9596843 9596843 20260330141400_CqS62 NZ005T 2026-03-31T12:05:04.002Z 2026-04-08T12:43:25.765Z
9596267 9596267 20260330120016_ZI5aH NZ005T 2026-03-31T12:03:53.513Z 2026-04-08T12:42:47.914Z
9595902 9595902 20260330095706_PrsWo NZ005T 2026-03-31T12:02:47.124Z 2026-04-08T12:42:35.583Z
9595705 9595705 20260330081011_TS6d2 NZ005T 2026-03-31T12:02:15.299Z 2026-04-08T12:42:30.029Z
9587417 9587417 20260327123543_IJ4ih NZ005T 2026-03-28T12:05:28.049Z 2026-04-05T12:34:25.720Z
9587301 9587301 20260327120127_7Y2iW NZ005T 2026-03-28T12:05:13.615Z 2026-04-05T12:34:12.157Z
9586575 9586575 20260327082638_v3T5b NZ005T 2026-03-28T12:03:27.684Z 2026-04-05T12:33:31.084Z
9577961 9577961 20260325092416_xdyW1 NZ005T 2026-03-26T12:06:26.762Z 2026-04-03T12:37:32.555Z
9573100 9573100 20260324111851_3z35E NZ005T 2026-03-25T12:07:11.050Z 2026-04-02T12:35:55.741Z
9572857 9572857 20260324104118_3wtll NZ005T 2026-03-25T12:06:30.605Z 2026-04-02T12:35:41.063Z
9572519 9572519 20260324092102_fRmKw NZ005T 2026-03-25T12:05:26.540Z 2026-04-02T12:35:28.266Z
9569551 9569551 20260322161023_naSaR NZ005T 2026-03-24T12:21:21.307Z 2026-03-30T12:30:08.456Z
9569101 9569101 20260322132403_JZGW2 NZ005T 2026-03-24T12:19:48.297Z 2026-03-30T12:29:33.318Z
9568411 9568411 20260323164134_FW4b5 NZ005T 2026-03-24T12:15:04.902Z 2026-03-31T12:28:28.852Z
9568294 9568294 20260323162727_sRxCQ NZ005T 2026-03-24T12:14:50.639Z 2026-03-31T12:28:26.930Z
9568285 9568285 20260323162645_BTAyW NZ005T 2026-03-24T12:14:50.039Z 2026-03-31T12:28:26.839Z
9568269 9568269 20260323162642_2Vv5T NZ005T 2026-03-24T12:14:49.368Z 2026-03-31T12:28:26.724Z
9568241 9568241 20260323162229_Abv9n NZ005T 2026-03-24T12:14:46.092Z 2026-03-31T12:28:26.215Z
9567970 9567970 20260323160304_P2cQ2 NZ005T 2026-03-24T12:14:20.412Z 2026-03-31T12:28:21.195Z
9567735 9567735 20260323154425_2Sakz NZ005T 2026-03-24T12:14:04.859Z 2026-03-31T12:28:18.090Z
9567662 9567662 20260323153846_WAiL8 NZ005T 2026-03-24T12:13:55.340Z 2026-03-31T12:28:17.255Z
9567120 9567120 20260323144119_l08rc NZ005T 2026-03-24T12:13:01.321Z 2026-03-31T12:28:08.604Z
9566955 9566955 20260323143008_Htfhi NZ005T 2026-03-24T12:12:46.188Z 2026-03-31T12:28:06.467Z
9566949 9566949 20260323142947_rHz3w NZ005T 2026-03-24T12:12:45.473Z 2026-03-31T12:28:06.363Z
9566840 9566840 20260323141803_woNU2 NZ005T 2026-03-24T12:12:31.770Z 2026-03-31T12:28:04.922Z
9566816 9566816 20260323141532_gwrnv NZ005T 2026-03-24T12:12:28.731Z 2026-03-31T12:28:04.657Z
9566785 9566785 20260323141256_jMoyP NZ005T 2026-03-24T12:12:25.982Z 2026-03-31T12:28:03.232Z
9566639 9566639 20260323135837_xXRFF NZ005T 2026-03-24T12:12:14.001Z 2026-03-31T12:27:54.872Z
9566613 9566613 20260323135716_MBAYd NZ005T 2026-03-24T12:12:12.441Z 2026-03-31T12:27:54.621Z
9566581 9566581 20260323135557_vjDtZ NZ005T 2026-03-24T12:12:09.321Z 2026-03-31T12:27:54.123Z
9565964 9565964 20260323125458_auhqx NZ005T 2026-03-24T12:11:06.500Z 2026-03-31T12:27:44.035Z
9565899 9565899 20260323124959_kpS6U NZ005T 2026-03-24T12:11:00.217Z 2026-03-31T12:27:43.185Z
9565603 9565603 20260323122444_Kfs4F NZ005T 2026-03-24T12:10:28.815Z 2026-03-31T12:27:38.124Z
9565581 9565581 20260323122102_lcr9x NZ005T 2026-03-24T12:10:25.295Z 2026-03-31T12:27:37.628Z
9565525 9565525 20260323121638_irduP NZ005T 2026-03-24T12:10:20.946Z 2026-03-29T12:15:02.419Z
9565377 9565377 20260323120359_iOTQe NZ005T 2026-03-24T12:09:58.633Z 2026-03-31T12:27:33.930Z
9565315 9565315 20260323120013_rDLXl NZ005T 2026-03-24T12:09:52.316Z 2026-03-31T12:27:33.155Z
9565284 9565284 20260323115634_HTOTk NZ005T 2026-03-24T12:09:48.276Z 2026-03-31T12:27:32.458Z
9565247 9565247 20260323115258_6z3KD NZ005T 2026-03-24T12:09:43.043Z 2026-03-31T12:27:31.771Z
9565204 9565204 20260323115001_GtQIq NZ005T 2026-03-24T12:09:37.228Z 2026-03-31T12:27:30.934Z
9565190 9565190 20260323114857_26Tmn NZ005T 2026-03-24T12:09:35.064Z 2026-03-31T12:27:30.547Z
9565166 9565166 20260323114800_iAtw5 NZ005T 2026-03-24T12:09:31.706Z 2026-03-29T12:14:56.635Z
9565140 9565140 20260323114633_m5iaX NZ005T 2026-03-24T12:09:28.602Z 2026-03-31T12:27:23.379Z
9565058 9565058 20260323114132_ARxtH NZ005T 2026-03-24T12:09:19.850Z 2026-03-31T12:27:22.026Z
9564966 9564966 20260323113308_KQr2q NZ005T 2026-03-24T12:09:08.344Z 2026-03-31T12:27:20.082Z
9564830 9564830 20260323111045_GYv2H NZ005T 2026-03-24T12:08:52.023Z 2026-03-31T12:27:16.065Z
9564808 9564808 20260323110954_7myV4 NZ005T 2026-03-24T12:08:50.190Z 2026-03-31T12:27:15.759Z
9564789 9564789 20260323110816_eA5gT NZ005T 2026-03-24T12:08:47.875Z 2026-03-31T12:27:15.478Z
9564684 9564684 20260323110051_DWNGL NZ005T 2026-03-24T12:08:33.398Z 2026-03-31T12:27:13.522Z
9564659 9564659 20260323105955_oJvSc NZ005T 2026-03-24T12:08:31.688Z 2026-03-31T12:27:13.155Z
9564634 9564634 20260323105824_sMvD4 NZ005T 2026-03-24T12:08:29.800Z 2026-03-31T12:27:12.850Z
9564490 9564490 20260323104146_pv3g6 NZ005T 2026-03-24T12:08:11.532Z 2026-03-31T12:27:09.913Z
9564384 9564384 20260323102929_iJ1VQ NZ005T 2026-03-24T12:07:59.706Z 2026-03-31T12:27:08.362Z
9564172 9564172 20260323100710_EuPRh NZ005T 2026-03-24T12:07:33.561Z 2026-03-31T12:27:04.271Z
9564135 9564135 20260323100237_cb25h NZ005T 2026-03-24T12:07:29.257Z 2026-03-31T12:27:03.238Z
9564099 9564099 20260323095742_Prpsd NZ005T 2026-03-24T12:07:25.075Z 2026-03-31T12:27:02.440Z
9564036 9564036 20260323095058_rfmCs NZ005T 2026-03-24T12:07:16.980Z 2026-03-31T12:27:01.238Z
9563984 9563984 20260323094513_j4HLz NZ005T 2026-03-24T12:07:06.751Z 2026-03-31T12:27:00.194Z
9563850 9563850 20260323092101_U6UAM NZ005T 2026-03-24T12:06:51.516Z 2026-03-31T12:26:57.948Z
9563786 9563786 20260323090840_GorHN NZ005T 2026-03-24T12:06:43.263Z 2026-03-31T12:26:56.570Z
9563435 9563435 20260323082053_xlhO7 NZ005T 2026-03-24T12:06:00.610Z 2026-03-31T12:26:43.263Z
9563362 9563362 20260323080447_395V3 NZ005T 2026-03-24T12:05:49.787Z 2026-03-31T12:26:41.488Z

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