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,000 rows where station_code = "NZ004H" 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
9270597 9270597 20260128160924_ImpKX NZ004H 2026-01-29T14:12:54.171Z 2026-01-29T14:12:54.171Z
9270565 9270565 20260128160159_2bzPs NZ004H 2026-01-29T14:12:46.940Z 2026-01-29T14:12:46.940Z
9270532 9270532 20260128155810_jrsJ2 NZ004H 2026-01-29T14:12:32.576Z 2026-01-29T14:12:32.576Z
9270523 9270523 20260128155725_zIdEw NZ004H 2026-01-29T14:12:31.603Z 2026-01-29T14:12:31.603Z
9270515 9270515 20260128155718_xgOeL NZ004H 2026-01-29T14:12:30.241Z 2026-01-29T14:12:30.241Z
9270371 9270371 20260128153946_TGSio NZ004H 2026-01-29T14:11:57.275Z 2026-01-29T14:11:57.275Z
9270166 9270166 20260128150446_3w2gM NZ004H 2026-01-29T14:11:09.755Z 2026-01-29T14:11:09.755Z
9270070 9270070 20260128145132_veUaf NZ004H 2026-01-29T14:10:46.230Z 2026-01-29T14:10:46.230Z
9269974 9269974 20260128143811_ng788 NZ004H 2026-01-29T14:10:22.307Z 2026-01-29T14:10:22.307Z
9269605 9269605 20260128134414_rKAJp NZ004H 2026-01-29T14:08:42.613Z 2026-01-29T14:08:42.613Z
9269592 9269592 20260128133957_4qAYK NZ004H 2026-01-29T14:08:39.122Z 2026-01-29T14:08:39.122Z
9269549 9269549 20260128133150_Hgnn2 NZ004H 2026-01-29T14:08:27.238Z 2026-01-29T14:08:27.238Z
9269537 9269537 20260128132957_wbiNU NZ004H 2026-01-29T14:08:24.504Z 2026-01-29T14:08:24.504Z
9269422 9269422 20260128131547_GHHEx NZ004H 2026-01-29T14:07:56.539Z 2026-01-29T14:07:56.539Z
9269336 9269336 20260128130314_zWEtF NZ004H 2026-01-29T14:07:29.237Z 2026-01-29T14:07:29.237Z
9269223 9269223 20260128124612_os2YS NZ004H 2026-01-29T14:07:02.451Z 2026-01-29T14:07:02.451Z
9269196 9269196 20260128124432_6HF5v NZ004H 2026-01-29T14:06:56.886Z 2026-01-29T14:06:56.886Z
9269034 9269034 20260128120703_n3uZT NZ004H 2026-01-29T14:06:06.582Z 2026-01-29T14:06:06.582Z
9268990 9268990 20260128115724_zghWs NZ004H 2026-01-29T14:05:51.972Z 2026-01-29T14:05:51.972Z
9268976 9268976 20260128115614_rBkA3 NZ004H 2026-01-29T14:05:49.599Z 2026-01-29T14:05:49.599Z
9268969 9268969 20260128115534_M1CTq NZ004H 2026-01-29T14:05:46.082Z 2026-01-29T14:05:46.082Z
9268912 9268912 20260128114306_roqnR NZ004H 2026-01-29T14:05:27.247Z 2026-01-29T14:05:27.247Z
9268833 9268833 20260128113126_dyStx NZ004H 2026-01-29T14:05:06.749Z 2026-01-29T14:05:06.749Z
9268683 9268683 20260128110140_rzfDp NZ004H 2026-01-29T14:04:20.090Z 2026-01-29T14:04:20.090Z
9268642 9268642 20260128105715_kKHbO NZ004H 2026-01-29T14:04:09.079Z 2026-01-29T14:04:09.079Z
9268259 9268259 20260128093249_ZUJ7l NZ004H 2026-01-29T14:02:06.059Z 2026-01-29T14:02:06.059Z
9268159 9268159 20260128090605_Onh32 NZ004H 2026-01-29T14:01:26.245Z 2026-01-29T14:01:26.245Z
9268102 9268102 20260128084859_j6pD3 NZ004H 2026-01-29T14:01:06.114Z 2026-01-29T14:01:06.114Z
9265878 9265878 20260127160938_6SM1C NZ004H 2026-01-28T14:11:39.037Z 2026-01-29T14:30:24.706Z
9265767 9265767 20260127155706_BnQKw NZ004H 2026-01-28T14:11:16.657Z 2026-01-29T14:30:24.670Z
9265705 9265705 20260127155027_sk9o1 NZ004H 2026-01-28T14:11:02.778Z 2026-01-29T14:30:24.658Z
9265659 9265659 20260127154547_YG9En NZ004H 2026-01-28T14:10:52.686Z 2026-01-29T14:30:24.647Z
9265521 9265521 20260127152412_R6Al1 NZ004H 2026-01-28T14:10:26.665Z 2026-01-29T14:30:24.598Z
9265441 9265441 20260127151627_2nLxx NZ004H 2026-01-28T14:10:11.220Z 2026-01-29T14:30:24.550Z
9265285 9265285 20260127145528_93wPr NZ004H 2026-01-28T14:09:44.610Z 2026-01-29T14:30:24.520Z
9265245 9265245 20260127144831_FUzGb NZ004H 2026-01-28T14:09:38.207Z 2026-01-29T14:30:24.513Z
9265141 9265141 20260127142429_Y6wcY NZ004H 2026-01-28T14:09:11.806Z 2026-01-29T14:30:24.458Z
9265008 9265008 20260127135434_KyL2j NZ004H 2026-01-28T14:08:36.003Z 2026-01-29T14:30:24.412Z
9264993 9264993 20260127134852_M5uJ3 NZ004H 2026-01-28T14:08:32.378Z 2026-01-29T14:30:24.408Z
9264980 9264980 20260127134612_glDix NZ004H 2026-01-28T14:08:28.522Z 2026-01-29T14:30:24.404Z
9264944 9264944 20260127133939_hO4Lu NZ004H 2026-01-28T14:08:19.702Z 2026-01-29T14:30:24.396Z
9264935 9264935 20260127133931_GDtEN NZ004H 2026-01-28T14:08:19.042Z 2026-01-29T14:30:24.395Z
9264794 9264794 20260127131331_3w6cC NZ004H 2026-01-28T14:07:41.956Z 2026-01-29T14:30:24.293Z
9264722 9264722 20260127130158_393A7 NZ004H 2026-01-28T14:07:21.212Z 2026-01-29T14:30:24.263Z
9264677 9264677 20260127125436_LiB0z NZ004H 2026-01-28T14:07:07.997Z 2026-01-29T14:30:24.252Z
9264593 9264593 20260127124904_B4bCv NZ004H 2026-01-28T14:06:47.822Z 2026-01-29T14:30:24.225Z
9264485 9264485 20260127123056_ivTDl NZ004H 2026-01-28T14:06:18.747Z 2026-01-29T14:30:24.183Z
9264480 9264480 20260127123044_tCmto NZ004H 2026-01-28T14:06:18.117Z 2026-01-29T14:30:24.182Z
9264434 9264434 20260127122100_02WUs NZ004H 2026-01-28T14:06:07.163Z 2026-01-29T14:30:21.707Z
9264402 9264402 20260127121415_1g7Uz NZ004H 2026-01-28T14:05:54.938Z 2026-01-29T14:30:21.196Z
9264393 9264393 20260127121149_DUjrB NZ004H 2026-01-28T14:05:49.415Z 2026-01-29T14:30:21.193Z
9264378 9264378 20260127120901_SRCPJ NZ004H 2026-01-28T14:05:45.080Z 2026-01-29T14:30:21.188Z
9264370 9264370 20260127120758_29byJ NZ004H 2026-01-28T14:05:43.677Z 2026-01-29T14:30:20.879Z
9253077 9253077 20260124090320_smfHl NZ004H 2026-01-25T14:00:31.978Z 2026-01-29T14:40:13.695Z
9250493 9250493 20260123153504_c5WpO NZ004H 2026-01-24T14:03:13.804Z 2026-01-29T14:45:40.914Z
9250490 9250490 20260123153447_Y1MkP NZ004H 2026-01-24T14:03:12.971Z 2026-01-29T14:45:40.642Z
9250417 9250417 20260123143132_Gwi90 NZ004H 2026-01-24T14:02:50.682Z 2026-01-29T14:45:32.429Z
9250410 9250410 20260123142659_N2l0e NZ004H 2026-01-24T14:02:47.152Z 2026-01-29T14:45:31.773Z
9250352 9250352 20260123133412_KJr83 NZ004H 2026-01-24T14:02:28.516Z 2026-01-29T14:45:25.734Z
9250135 9250135 20260123103847_Z2RAV NZ004H 2026-01-24T14:01:20.923Z 2026-01-29T14:45:01.157Z
9250020 9250020 20260123094252_JZqcz NZ004H 2026-01-24T14:00:40.555Z 2026-01-29T14:44:52.041Z
9250000 9250000 20260123093359_PmkJP NZ004H 2026-01-24T14:00:32.949Z 2026-01-29T14:44:47.119Z
9249979 9249979 20260123092449_EzVEF NZ004H 2026-01-24T14:00:26.071Z 2026-01-29T14:44:46.064Z
9249832 9249832 20260122091646_MqSMo NZ004H 2026-01-23T14:16:20.537Z 2026-01-29T14:59:00.111Z
9246032 9246032 20260122160430_uBPqJ NZ004H 2026-01-23T14:04:26.954Z 2026-01-29T14:50:38.136Z
9246006 9246006 20260122155849_ba4dt NZ004H 2026-01-23T14:04:19.427Z 2026-01-29T14:50:29.245Z
9246001 9246001 20260122155705_ZG3x9 NZ004H 2026-01-23T14:04:15.731Z 2026-01-29T14:50:29.145Z
9245983 9245983 20260122155444_Nn2c5 NZ004H 2026-01-23T14:04:12.436Z 2026-01-29T14:50:28.445Z
9245948 9245948 20260122154219_y5WgC NZ004H 2026-01-23T14:04:07.444Z 2026-01-29T14:50:26.464Z
9245937 9245937 20260122153714_HyFMH NZ004H 2026-01-23T14:04:05.468Z 2026-01-29T14:50:25.863Z
9245907 9245907 20260122152425_oAGn9 NZ004H 2026-01-23T14:04:00.104Z 2026-01-29T14:50:21.781Z
9245505 9245505 20260122124908_KR405 NZ004H 2026-01-23T14:02:14.554Z 2026-01-29T14:49:44.672Z
9245431 9245431 20260122122321_j55ct NZ004H 2026-01-23T14:01:55.749Z 2026-01-29T14:49:39.061Z
9245425 9245425 20260122122037_oqnuz NZ004H 2026-01-23T14:01:54.194Z 2026-01-29T14:49:37.952Z
9245337 9245337 20260122114843_ELk7Y NZ004H 2026-01-23T14:01:31.047Z 2026-01-29T14:49:24.454Z
9245327 9245327 20260122114806_IM1QI NZ004H 2026-01-23T14:01:30.173Z 2026-01-29T14:49:24.156Z
9245320 9245320 20260122114546_UYyWZ NZ004H 2026-01-23T14:01:29.288Z 2026-01-29T14:49:23.809Z
9245303 9245303 20260122114321_bLoMa NZ004H 2026-01-23T14:01:24.381Z 2026-01-29T14:49:22.699Z
9245287 9245287 20260122113656_i8gt3 NZ004H 2026-01-23T14:01:20.993Z 2026-01-29T14:49:21.210Z
9245231 9245231 20260122112311_K6Ihd NZ004H 2026-01-23T14:01:09.069Z 2026-01-29T14:49:16.785Z
9245202 9245202 20260122111326_9Ph8A NZ004H 2026-01-23T14:01:00.616Z 2026-01-29T14:49:14.341Z
9245172 9245172 20260122105258_5qnnd NZ004H 2026-01-23T14:00:51.833Z 2026-01-29T14:49:10.939Z
9245152 9245152 20260122103820_WZ40d NZ004H 2026-01-23T14:00:48.388Z 2026-01-29T14:49:05.243Z
9245137 9245137 20260122102916_2PQA0 NZ004H 2026-01-23T14:00:45.312Z 2026-01-29T14:49:03.883Z
9245100 9245100 20260122101215_ezgX2 NZ004H 2026-01-23T14:00:32.958Z 2026-01-29T14:49:01.261Z
9245078 9245078 20260122095714_HKJXB NZ004H 2026-01-23T14:00:25.955Z 2026-01-29T14:48:56.420Z
9245059 9245059 20260122094930_JA3bJ NZ004H 2026-01-23T14:00:20.891Z 2026-01-29T14:48:55.169Z
9226791 9226791 20260119130417_m79fR NZ004H 2026-01-20T14:05:02.028Z 2026-01-28T14:55:27.547Z
9226761 9226761 20260119130035_uFOic NZ004H 2026-01-20T14:04:54.356Z 2026-01-28T14:55:25.744Z
9226629 9226629 20260119123644_cTHx6 NZ004H 2026-01-20T14:04:17.520Z 2026-01-28T14:55:19.406Z
9226028 9226028 20260119105130_TiZh7 NZ004H 2026-01-20T14:00:32.000Z 2026-01-28T14:54:29.506Z
9215364 9215364 20260116095946_mUDPN NZ004H 2026-01-17T14:25:18.332Z 2026-01-24T15:14:43.007Z
9215118 9215118 20260116092001_J3Mcp NZ004H 2026-01-17T14:24:28.402Z 2026-01-24T15:14:30.970Z
9210509 9210509 20260116122631_uoCZr NZ004H 2026-01-17T14:01:19.215Z 2026-01-25T14:56:45.297Z
9197260 9197260 20260113103852_TL7tw NZ004H 2026-01-14T14:22:09.224Z 2026-01-21T15:06:15.939Z
9192892 9192892 20260112131302_25KVx NZ004H 2026-01-13T14:29:35.992Z 2026-01-20T15:26:38.544Z
9192819 9192819 20260112130437_FgH6o NZ004H 2026-01-13T14:29:21.735Z 2026-01-20T15:26:34.216Z
9191890 9191890 20260112114902_U7Mi4 NZ004H 2026-01-13T14:26:45.889Z 2026-01-20T15:25:50.276Z
9191856 9191856 20260112114708_gSaMn NZ004H 2026-01-13T14:26:41.778Z 2026-01-20T15:25:49.019Z
9186805 9186805 20260112154330_XcA1y NZ004H 2026-01-13T14:03:34.440Z 2026-01-21T15:03:00.475Z

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