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

2,933 rows where station_code = "NZ0013" 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
8659805 8659805 20251130111708_TbkwI NZ0013 2025-12-02T14:05:21.792Z 2025-12-05T14:30:31.872Z
8627440 8627440 20251128105929_E7rh4 NZ0013 2025-11-29T14:03:33.104Z 2025-12-05T14:46:59.470Z
8627259 8627259 20251128104056_zYSa2 NZ0013 2025-11-29T14:03:08.839Z 2025-12-05T14:46:56.424Z
8627221 8627221 20251128103942_9xmCU NZ0013 2025-11-29T14:03:06.273Z 2025-12-05T14:46:56.047Z
8627028 8627028 20251128101425_y0rLk NZ0013 2025-11-29T14:02:21.362Z 2025-12-05T14:46:34.878Z
8620272 8620272 20251126120748_mxgvG NZ0013 2025-11-28T14:12:11.635Z 2025-12-05T15:01:40.400Z
8620252 8620252 20251126120517_6CX2T NZ0013 2025-11-28T14:12:07.040Z 2025-12-05T15:01:34.405Z
8620117 8620117 20251126114913_79H3o NZ0013 2025-11-28T14:11:40.871Z 2025-12-05T15:01:28.922Z
8619318 8619318 20251126094851_fmC33 NZ0013 2025-11-28T14:08:20.777Z 2025-12-05T15:00:56.082Z
8593889 8593889 20251125135812_cWVTg NZ0013 2025-11-26T14:03:46.875Z 2025-12-04T15:05:27.783Z
8581207 8581207 20251122100308_2xCYr NZ0013 2025-11-24T14:29:39.379Z 2025-11-30T15:07:25.919Z
8575761 8575761 20251122133043_jKQLJ NZ0013 2025-11-24T14:04:02.805Z 2025-12-01T15:18:30.532Z
8575574 8575574 20251122125745_Uw1j2 NZ0013 2025-11-24T14:03:34.729Z 2025-12-01T15:18:27.539Z
8562298 8562298 20251121140254_1j2q8 NZ0013 2025-11-23T14:05:18.461Z 2025-11-30T15:03:26.893Z
8562227 8562227 20251121135012_bt3GC NZ0013 2025-11-23T14:05:05.557Z 2025-11-30T15:03:25.048Z
8544630 8544630 20251120152513_3XsTa NZ0013 2025-11-22T14:08:31.612Z 2025-11-29T14:53:49.176Z
8543781 8543781 20251120142555_WSiW6 NZ0013 2025-11-22T14:06:09.396Z 2025-11-29T14:53:29.479Z
8543654 8543654 20251120141118_1m3NW NZ0013 2025-11-22T14:05:46.902Z 2025-11-29T14:53:27.953Z
8542705 8542705 20251120124252_Ukq4i NZ0013 2025-11-22T14:02:56.191Z 2025-11-29T14:53:14.594Z
8542659 8542659 20251120123722_e3NMZ NZ0013 2025-11-22T14:02:47.592Z 2025-11-29T14:53:14.250Z
8542424 8542424 20251120121319_7sNuH NZ0013 2025-11-22T14:02:08.391Z 2025-11-29T14:53:11.702Z
8488907 8488907 20251116150904_cQlDg NZ0013 2025-11-18T14:07:59.226Z 2025-11-25T15:06:59.441Z
8488810 8488810 20251116150157_vZgvT NZ0013 2025-11-18T14:07:38.458Z 2025-11-25T15:06:57.290Z
8488752 8488752 20251116145758_9fbwP NZ0013 2025-11-18T14:07:26.988Z 2025-11-25T15:06:53.384Z
8488314 8488314 20251116141559_USGjJ NZ0013 2025-11-18T14:06:07.119Z 2025-11-25T15:06:45.978Z
8487758 8487758 20251116132721_2mIYW NZ0013 2025-11-18T14:04:16.457Z 2025-11-25T15:06:25.707Z
8487740 8487740 20251116132654_Ow2nU NZ0013 2025-11-18T14:04:14.099Z 2025-11-25T15:06:25.578Z
8487491 8487491 20251116125634_2isBZ NZ0013 2025-11-18T14:03:29.975Z 2025-11-25T15:06:15.288Z
8487180 8487180 20251116122844_01mUA NZ0013 2025-11-18T14:02:23.187Z 2025-11-25T15:06:08.092Z
8486252 8486252 20251115112336_3PjrR NZ0013 2025-11-17T14:34:15.536Z 2025-11-23T15:20:27.835Z
8485167 8485167 20251115102834_QJoGF NZ0013 2025-11-17T14:33:32.648Z 2025-11-23T15:19:56.784Z
8484550 8484550 20251115095033_gUr5Y NZ0013 2025-11-17T14:32:51.039Z 2025-11-23T15:19:39.645Z
8476934 8476934 20251115150822_i5h9k NZ0013 2025-11-17T14:10:04.045Z 2025-11-24T15:03:19.553Z
8476750 8476750 20251115145856_Y360b NZ0013 2025-11-17T14:09:35.899Z 2025-11-24T15:03:13.443Z
8476466 8476466 20251115144644_QN8be NZ0013 2025-11-17T14:08:50.589Z 2025-11-24T15:03:11.469Z
8476407 8476407 20251115144549_R0tfF NZ0013 2025-11-17T14:08:47.615Z 2025-11-24T15:03:11.047Z
8475825 8475825 20251115141553_9wLRC NZ0013 2025-11-17T14:07:28.825Z 2025-11-24T15:03:05.145Z
8475739 8475739 20251115141136_7iHVv NZ0013 2025-11-17T14:07:17.051Z 2025-11-24T15:03:04.363Z
8475672 8475672 20251115140740_daGzm NZ0013 2025-11-17T14:07:11.768Z 2025-11-24T15:03:04.014Z
8473162 8473162 20251115115946_y72Vx NZ0013 2025-11-17T14:01:19.206Z 2025-11-24T15:02:31.268Z
8472978 8472978 20251115115151_7x9xf NZ0013 2025-11-17T14:00:47.968Z 2025-11-24T15:02:26.208Z
8443156 8443156 20251111112745_sso8L NZ0013 2025-11-13T14:50:37.916Z 2025-11-19T15:19:05.093Z
8443149 8443149 20251111112735_ftZGa NZ0013 2025-11-13T14:50:37.492Z 2025-11-19T15:19:05.018Z
8431436 8431436 20251111140739_sh21O NZ0013 2025-11-13T14:04:40.223Z 2025-11-20T15:19:56.810Z
8408476 8408476 20251109120412_Zcu0g NZ0013 2025-11-10T14:24:19.820Z 2025-11-17T14:59:28.880Z
8408333 8408333 20251109113352_FTm4w NZ0013 2025-11-10T14:23:27.108Z 2025-11-17T14:59:27.510Z
8400153 8400153 20251108104514_jqhQ0 NZ0013 2025-11-09T14:20:08.744Z 2025-11-16T15:05:57.541Z
8399524 8399524 20251108085929_nhfuk NZ0013 2025-11-09T14:18:20.484Z 2025-11-16T15:05:44.852Z
8394174 8394174 20251107110710_mLDlB NZ0013 2025-11-08T14:22:53.006Z 2025-11-15T15:01:04.262Z
8393866 8393866 20251107101609_2smWQ NZ0013 2025-11-08T14:22:04.152Z 2025-11-15T15:00:59.319Z
8384473 8384473 20251106145746_MoGln NZ0013 2025-11-07T14:01:07.916Z 2025-11-15T14:59:08.240Z
8384397 8384397 20251106143405_9XJcR NZ0013 2025-11-07T14:00:55.354Z 2025-11-15T14:59:02.963Z
8383504 8383504 20251104105808_pPKfb NZ0013 2025-11-06T14:27:51.143Z 2025-11-12T15:12:03.515Z
8382936 8382936 20251105123959_wzMuY NZ0013 2025-11-06T14:19:01.306Z 2025-11-13T15:16:23.307Z
8377496 8377496 20251105140047_nGsTT NZ0013 2025-11-06T14:00:50.300Z 2025-11-14T15:07:27.227Z
8376129 8376129 20251103100128_WQhxq NZ0013 2025-11-05T14:35:58.851Z 2025-11-11T15:08:25.254Z
8367956 8367956 20251103132814_y3rC6 NZ0013 2025-11-05T14:00:52.487Z 2025-11-12T15:08:29.221Z
8367867 8367867 20251103131325_4QbFD NZ0013 2025-11-05T14:00:32.350Z 2025-11-12T15:08:27.931Z
8367779 8367779 20251103125656_GuHqh NZ0013 2025-11-05T14:00:20.997Z 2025-11-12T15:08:27.083Z
8355082 8355082 20251101112157_3bo1s NZ0013 2025-11-03T14:36:48.342Z 2025-11-09T15:06:40.285Z
8327050 8327050 20251030103746_CxUJw NZ0013 2025-11-01T12:36:37.970Z 2025-11-07T15:18:44.858Z
8315949 8315949 20251030153442_B8mUL NZ0013 2025-11-01T12:03:46.516Z 2025-11-08T15:10:04.190Z
8315946 8315946 20251030153358_VeBJN NZ0013 2025-11-01T12:03:46.002Z 2025-11-08T15:10:04.155Z
8315513 8315513 20251030144350_8EHdz NZ0013 2025-11-01T12:02:31.628Z 2025-11-08T15:09:49.495Z
8315117 8315117 20251030133807_EmZi2 NZ0013 2025-11-01T12:00:58.882Z 2025-11-08T15:09:11.396Z
8314826 8314826 20251028121656_3TZ69 NZ0013 2025-10-31T12:50:13.617Z 2025-11-05T15:25:27.261Z
8307328 8307328 20251029093527_mawx3 NZ0013 2025-10-31T12:27:15.427Z 2025-11-06T15:15:33.410Z
8307017 8307017 20251029090207_6BBVE NZ0013 2025-10-31T12:26:50.101Z 2025-11-06T15:15:21.566Z
8302353 8302353 20251029150633_foeM8 NZ0013 2025-10-31T12:03:41.315Z 2025-11-07T15:09:15.538Z
8301914 8301914 20251029143243_LA8Sh NZ0013 2025-10-31T12:02:29.212Z 2025-11-07T15:09:09.894Z
8301726 8301726 20251029141543_2eYae NZ0013 2025-10-31T12:01:59.269Z 2025-11-07T15:08:57.906Z
8294874 8294874 20251028110433_EmIv8 NZ0013 2025-10-30T12:41:23.145Z 2025-11-05T15:24:49.623Z
8294801 8294801 20251028105834_3E1Ok NZ0013 2025-10-30T12:41:17.291Z 2025-11-05T15:24:49.041Z
8294330 8294330 20251028102847_BSOqN NZ0013 2025-10-30T12:40:59.001Z 2025-11-05T15:24:23.367Z
8292630 8292630 20251028084035_KZpSB NZ0013 2025-10-30T12:38:21.122Z 2025-11-05T15:23:33.188Z
8265561 8265561 20251026081627_Uv9Ub NZ0013 2025-10-28T12:38:36.234Z 2025-11-03T15:17:04.772Z
8248614 8248614 20251026145343_bUUJj NZ0013 2025-10-28T12:02:27.464Z 2025-11-04T15:39:15.631Z
8230137 8230137 20251025145125_EQNeG NZ0013 2025-10-27T12:03:43.552Z 2025-11-03T15:15:16.352Z
8229994 8229994 20251025143207_XPHSL NZ0013 2025-10-27T12:03:06.364Z 2025-11-03T15:15:12.251Z
8227876 8227876 20251024111450_rRfiJ NZ0013 2025-10-26T12:46:40.891Z 2025-11-01T13:11:30.987Z
8227289 8227289 20251024102935_M8L2o NZ0013 2025-10-26T12:45:36.718Z 2025-11-01T13:11:29.069Z
8207417 8207417 20251024155417_p6PWR NZ0013 2025-10-26T12:08:25.441Z 2025-11-02T15:05:00.688Z
8207361 8207361 20251024155100_EzWXF NZ0013 2025-10-26T12:08:08.972Z 2025-11-02T15:05:00.541Z
8206727 8206727 20251024150101_IBYoF NZ0013 2025-10-26T12:05:47.569Z 2025-11-02T15:04:56.058Z
8206672 8206672 20251024145717_qh6Ih NZ0013 2025-10-26T12:05:36.841Z 2025-11-02T15:04:55.946Z
8206661 8206661 20251024145621_V5J2Z NZ0013 2025-10-26T12:05:33.855Z 2025-11-02T15:04:55.932Z
8205743 8205743 20251024132447_zETno NZ0013 2025-10-26T12:01:51.255Z 2025-11-02T15:04:50.580Z
8186882 8186882 20251021113616_tWN8H NZ0013 2025-10-23T12:38:40.408Z 2025-10-29T13:08:19.339Z
8186752 8186752 20251021112451_SkC7L NZ0013 2025-10-23T12:38:30.232Z 2025-10-29T13:08:17.250Z
8186596 8186596 20251021111235_x53mv NZ0013 2025-10-23T12:38:08.625Z 2025-10-29T13:08:16.351Z
8186550 8186550 20251021110943_UJeuy NZ0013 2025-10-23T12:38:01.552Z 2025-10-29T13:08:16.167Z
8184116 8184116 20251021082153_C1d3S NZ0013 2025-10-23T12:33:49.364Z 2025-10-29T13:07:55.412Z
8177011 8177011 20251021161200_AHicT NZ0013 2025-10-23T12:08:31.085Z 2025-10-30T13:12:41.104Z
8176971 8176971 20251021160551_am0oR NZ0013 2025-10-23T12:08:25.806Z 2025-10-30T13:12:40.764Z
8176616 8176616 20251021153738_TMQea NZ0013 2025-10-23T12:07:12.913Z 2025-10-30T13:12:38.200Z
8176477 8176477 20251021152822_8mPKO NZ0013 2025-10-23T12:06:41.903Z 2025-10-30T13:12:37.753Z
8176223 8176223 20251021150412_6Gd9d NZ0013 2025-10-23T12:05:55.378Z 2025-10-30T13:12:37.032Z
8175701 8175701 20251021142437_M3O8R NZ0013 2025-10-23T12:04:25.575Z 2025-10-30T13:12:35.453Z
8175131 8175131 20251021132839_oqa82 NZ0013 2025-10-23T12:02:36.812Z 2025-10-30T13:12:33.913Z
8174761 8174761 20251021124937_SJV33 NZ0013 2025-10-23T12:01:24.415Z 2025-10-30T13:12:32.595Z

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