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,859 rows where station_code = "NZ0063" 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
9273593 9273593 20260126153638_fJ97z NZ0063 2026-01-29T14:33:30.980Z 2026-01-29T14:33:30.980Z
9273587 9273587 20260126112938_9KYD5 NZ0063 2026-01-29T14:32:20.348Z 2026-01-29T14:32:20.348Z
9273582 9273582 20260126104656_ur6E9 NZ0063 2026-01-29T14:32:07.860Z 2026-01-29T14:32:07.860Z
9273580 9273580 20260126103000_fYGLN NZ0063 2026-01-29T14:32:05.192Z 2026-01-29T14:32:05.192Z
9273578 9273578 20260126102127_0Dnj5 NZ0063 2026-01-29T14:32:02.900Z 2026-01-29T14:32:02.900Z
9273575 9273575 20260126101822_tAxwp NZ0063 2026-01-29T14:32:02.266Z 2026-01-29T14:32:02.266Z
9265387 9265387 20260127151030_lytAS NZ0063 2026-01-28T14:10:00.969Z 2026-01-29T14:30:24.538Z
9265348 9265348 20260127150345_KMb2l NZ0063 2026-01-28T14:09:53.429Z 2026-01-29T14:30:24.531Z
9265341 9265341 20260127150318_l33u3 NZ0063 2026-01-28T14:09:52.351Z 2026-01-29T14:30:24.530Z
9265334 9265334 20260127150222_iuENo NZ0063 2026-01-28T14:09:50.998Z 2026-01-29T14:30:24.528Z
9265117 9265117 20260127142130_aG9VC NZ0063 2026-01-28T14:09:08.281Z 2026-01-29T14:30:24.451Z
9265109 9265109 20260127142024_B73CV NZ0063 2026-01-28T14:09:03.959Z 2026-01-29T14:30:24.450Z
9265103 9265103 20260127141640_hnW3T NZ0063 2026-01-28T14:09:02.828Z 2026-01-29T14:30:24.448Z
9265079 9265079 20260127141356_1aTTA NZ0063 2026-01-28T14:08:57.097Z 2026-01-29T14:30:24.432Z
9265054 9265054 20260127140647_oxKu2 NZ0063 2026-01-28T14:08:51.123Z 2026-01-29T14:30:24.427Z
9265039 9265039 20260127140215_xGW5r NZ0063 2026-01-28T14:08:46.610Z 2026-01-29T14:30:24.422Z
9264924 9264924 20260127133801_zEV5n NZ0063 2026-01-28T14:08:17.297Z 2026-01-29T14:30:24.394Z
9264916 9264916 20260127133252_jSvsx NZ0063 2026-01-28T14:08:15.309Z 2026-01-29T14:30:24.391Z
9264908 9264908 20260127133220_2X4Ux NZ0063 2026-01-28T14:08:13.891Z 2026-01-29T14:30:24.384Z
9264893 9264893 20260127132957_2TdrS NZ0063 2026-01-28T14:08:08.613Z 2026-01-29T14:30:24.322Z
9264657 9264657 20260127125215_nrI0r NZ0063 2026-01-28T14:07:03.485Z 2026-01-29T14:30:24.238Z
9264623 9264623 20260127125058_8TElX NZ0063 2026-01-28T14:06:56.030Z 2026-01-29T14:30:24.231Z
9264620 9264620 20260127125055_r0Aj6 NZ0063 2026-01-28T14:06:55.515Z 2026-01-29T14:30:24.230Z
9264606 9264606 20260127125009_g6m3i NZ0063 2026-01-28T14:06:50.791Z 2026-01-29T14:30:24.228Z
9264507 9264507 20260127123954_225tN NZ0063 2026-01-28T14:06:26.759Z 2026-01-29T14:30:24.190Z
9264408 9264408 20260127121509_CovEr NZ0063 2026-01-28T14:05:56.730Z 2026-01-29T14:30:21.197Z
9264353 9264353 20260127120513_455vJ NZ0063 2026-01-28T14:05:38.432Z 2026-01-29T14:30:20.875Z
9264347 9264347 20260127120352_RtIUy NZ0063 2026-01-28T14:05:36.075Z 2026-01-29T14:30:20.859Z
9264328 9264328 20260127120121_PwmyF NZ0063 2026-01-28T14:05:31.624Z 2026-01-29T14:30:20.855Z
9264304 9264304 20260127115849_UOFqT NZ0063 2026-01-28T14:05:23.525Z 2026-01-29T14:30:20.850Z
9264294 9264294 20260127115738_ITAKh NZ0063 2026-01-28T14:05:20.433Z 2026-01-29T14:30:20.845Z
9264266 9264266 20260127115307_4krVd NZ0063 2026-01-28T14:05:14.014Z 2026-01-29T14:30:20.572Z
9264224 9264224 20260127114141_qHE2p NZ0063 2026-01-28T14:05:00.800Z 2026-01-29T14:30:20.553Z
9264176 9264176 20260127113246_uQv8T NZ0063 2026-01-28T14:04:48.798Z 2026-01-29T14:30:20.513Z
9264119 9264119 20260127111658_UOTzN NZ0063 2026-01-28T14:04:29.615Z 2026-01-29T14:30:20.055Z
9264057 9264057 20260127110619_NerYf NZ0063 2026-01-28T14:04:09.136Z 2026-01-29T14:30:20.031Z
9264001 9264001 20260127105024_YLx1O NZ0063 2026-01-28T14:03:51.934Z 2026-01-29T14:30:19.993Z
9263967 9263967 20260127104802_eT4n6 NZ0063 2026-01-28T14:03:42.070Z 2026-01-29T14:30:19.977Z
9263928 9263928 20260127104348_gXe72 NZ0063 2026-01-28T14:03:33.434Z 2026-01-29T14:30:19.971Z
9263902 9263902 20260127103840_9dZrt NZ0063 2026-01-28T14:03:27.944Z 2026-01-29T14:30:19.958Z
9263853 9263853 20260127102109_PbRXo NZ0063 2026-01-28T14:03:08.751Z 2026-01-29T14:30:18.963Z
9263843 9263843 20260127102037_vTjcB NZ0063 2026-01-28T14:03:07.212Z 2026-01-29T14:30:18.961Z
9263774 9263774 20260127100953_LvDzC NZ0063 2026-01-28T14:02:42.290Z 2026-01-29T14:30:18.932Z
9263743 9263743 20260127100239_rwJOm NZ0063 2026-01-28T14:02:33.422Z 2026-01-29T14:30:18.923Z
9263574 9263574 20260127091718_3ZZsP NZ0063 2026-01-28T14:01:32.124Z 2026-01-29T14:30:16.574Z
9262096 9262096 20260126160311_cXrgm NZ0063 2026-01-27T14:07:32.279Z 2026-01-29T14:33:39.983Z
9262041 9262041 20260126152826_Ym682 NZ0063 2026-01-27T14:07:14.165Z 2026-01-29T14:33:29.490Z
9262035 9262035 20260126152641_Dyug3 NZ0063 2026-01-27T14:07:12.660Z 2026-01-27T14:07:12.660Z
9262033 9262033 20260126152640_z6z24 NZ0063 2026-01-27T14:07:07.861Z 2026-01-29T14:33:29.220Z
9262031 9262031 20260126152622_MxC7R NZ0063 2026-01-27T14:07:07.245Z 2026-01-29T14:33:29.046Z
9262022 9262022 20260126151920_oAQ2p NZ0063 2026-01-27T14:07:05.097Z 2026-01-29T14:33:27.972Z
9262013 9262013 20260126151508_f0tzE NZ0063 2026-01-27T14:07:01.736Z 2026-01-29T14:33:25.008Z
9262005 9262005 20260126151147_UaZFR NZ0063 2026-01-27T14:06:58.616Z 2026-01-29T14:33:24.367Z
9262000 9262000 20260126150847_vIo2X NZ0063 2026-01-27T14:06:57.268Z 2026-01-29T14:33:23.447Z
9261994 9261994 20260126150837_WpLUa NZ0063 2026-01-27T14:06:55.874Z 2026-01-29T14:33:23.091Z
9261970 9261970 20260126150111_r9yYW NZ0063 2026-01-27T14:06:49.564Z 2026-01-29T14:33:21.359Z
9261951 9261951 20260126145356_8vYXS NZ0063 2026-01-27T14:06:43.892Z 2026-01-29T14:33:19.650Z
9261944 9261944 20260126145051_FOYDp NZ0063 2026-01-27T14:06:41.861Z 2026-01-29T14:33:18.825Z
9261942 9261942 20260126144829_A3qCC NZ0063 2026-01-27T14:06:41.153Z 2026-01-29T14:33:18.691Z
9261938 9261938 20260126144706_5uAB9 NZ0063 2026-01-27T14:06:34.861Z 2026-01-29T14:33:18.176Z
9261936 9261936 20260126144641_8Lkds NZ0063 2026-01-27T14:06:33.336Z 2026-01-29T14:33:17.935Z
9261917 9261917 20260126143929_IgGoN NZ0063 2026-01-27T14:06:24.140Z 2026-01-29T14:33:16.167Z
9261907 9261907 20260126143336_hyPx5 NZ0063 2026-01-27T14:06:21.217Z 2026-01-29T14:33:15.457Z
9261876 9261876 20260126141549_kFgvk NZ0063 2026-01-27T14:06:12.513Z 2026-01-29T14:33:12.943Z
9261862 9261862 20260126135954_hMe3o NZ0063 2026-01-27T14:06:09.033Z 2026-01-29T14:33:11.515Z
9261860 9261860 20260126135754_tUpaD NZ0063 2026-01-27T14:06:08.402Z 2026-01-29T14:33:11.305Z
9261843 9261843 20260126135243_nG8m2 NZ0063 2026-01-27T14:05:58.771Z 2026-01-29T14:33:09.870Z
9261816 9261816 20260126133439_M1hS3 NZ0063 2026-01-27T14:05:47.407Z 2026-01-29T14:33:04.923Z
9261814 9261814 20260126133402_YXxwl NZ0063 2026-01-27T14:05:46.673Z 2026-01-29T14:33:04.668Z
9261806 9261806 20260126133016_jV3By NZ0063 2026-01-27T14:05:44.840Z 2026-01-29T14:33:04.053Z
9261783 9261783 20260126131905_6txRg NZ0063 2026-01-27T14:05:38.224Z 2026-01-29T14:32:57.798Z
9261772 9261772 20260126131359_V5muQ NZ0063 2026-01-27T14:05:31.022Z 2026-01-29T14:32:56.798Z
9261693 9261693 20260126125117_nnSPH NZ0063 2026-01-27T14:05:09.050Z 2026-01-29T14:32:48.970Z
9261580 9261580 20260126121958_0Bkuz NZ0063 2026-01-27T14:04:26.498Z 2026-01-29T14:32:41.030Z
9261544 9261544 20260126121257_iOUn3 NZ0063 2026-01-27T14:04:16.928Z 2026-01-29T14:32:38.830Z
9261503 9261503 20260126120032_iwjOj NZ0063 2026-01-27T14:04:06.516Z 2026-01-29T14:32:36.438Z
9261439 9261439 20260126113804_1e22H NZ0063 2026-01-27T14:03:43.405Z 2026-01-29T14:32:24.680Z
9261416 9261416 20260126112948_aNrDR NZ0063 2026-01-27T14:03:39.401Z 2026-01-29T14:32:20.898Z
9261374 9261374 20260126111757_nRch3 NZ0063 2026-01-27T14:03:25.992Z 2026-01-29T14:32:14.280Z
9261329 9261329 20260126110936_Zhbu9 NZ0063 2026-01-27T14:03:14.041Z 2026-01-29T14:32:12.335Z
9261284 9261284 20260126110029_33te1 NZ0063 2026-01-27T14:03:00.652Z 2026-01-29T14:32:09.919Z
9245719 9245719 20260122140107_X3La2 NZ0063 2026-01-23T14:03:06.662Z 2026-01-29T14:49:59.717Z
9245654 9245654 20260122133359_hgP2t NZ0063 2026-01-23T14:02:53.018Z 2026-01-29T14:49:53.289Z
9238733 9238733 20260120094033_if81I NZ0063 2026-01-21T14:30:28.831Z 2026-01-28T15:02:48.426Z
9233495 9233495 20260120160225_Rh2oe NZ0063 2026-01-21T14:05:58.222Z 2026-01-29T15:01:23.793Z
9233491 9233491 20260120160042_28aBC NZ0063 2026-01-21T14:05:57.659Z 2026-01-29T15:01:23.666Z
9233472 9233472 20260120155111_wmKq3 NZ0063 2026-01-21T14:05:52.609Z 2026-01-29T15:01:21.773Z
9233456 9233456 20260120154146_2orh3 NZ0063 2026-01-21T14:05:50.019Z 2026-01-29T15:01:20.310Z
9233454 9233454 20260120153453_wj4yt NZ0063 2026-01-21T14:05:49.497Z 2026-01-29T15:01:19.688Z
9233446 9233446 20260120152853_YfO6F NZ0063 2026-01-21T14:05:48.596Z 2026-01-29T15:01:19.266Z
9233383 9233383 20260120150416_QEDO1 NZ0063 2026-01-21T14:05:33.538Z 2026-01-29T15:01:03.899Z
9233377 9233377 20260120150405_pKCdC NZ0063 2026-01-21T14:05:33.104Z 2026-01-29T15:01:03.734Z
9233372 9233372 20260120150218_cAMYB NZ0063 2026-01-21T14:05:32.642Z 2026-01-29T15:01:03.586Z
9233366 9233366 20260120145748_PJynG NZ0063 2026-01-21T14:05:27.955Z 2026-01-29T15:01:02.689Z
9233343 9233343 20260120144941_WwEQm NZ0063 2026-01-21T14:05:25.331Z 2026-01-29T15:01:01.551Z
9233326 9233326 20260120144027_C3OIo NZ0063 2026-01-21T14:05:22.007Z 2026-01-29T15:01:00.554Z
9233322 9233322 20260120144017_8TQI7 NZ0063 2026-01-21T14:05:21.322Z 2026-01-29T15:01:00.336Z
9233310 9233310 20260120142917_S4q3f NZ0063 2026-01-21T14:05:18.496Z 2026-01-29T15:00:56.173Z
9233288 9233288 20260120142300_3CAyH NZ0063 2026-01-21T14:05:14.729Z 2026-01-29T15:00:54.860Z
9233280 9233280 20260120142053_WlL2H NZ0063 2026-01-21T14:05:13.171Z 2026-01-29T15:00:53.875Z

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