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,869 rows where station_code = "NZ005M" 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
9627490 9627490 20260408180239_a5ZcY NZ005M 2026-04-09T12:11:11.023Z 2026-04-10T12:14:22.552Z
9627370 9627370 20260408172202_FOVxe NZ005M 2026-04-09T12:10:46.022Z 2026-04-10T12:14:22.532Z
9627256 9627256 20260408165236_h25tO NZ005M 2026-04-09T12:10:28.725Z 2026-04-10T12:14:22.510Z
9627209 9627209 20260408164303_EqSyC NZ005M 2026-04-09T12:10:19.348Z 2026-04-10T12:14:22.502Z
9626444 9626444 20260408140407_i5daA NZ005M 2026-04-09T12:08:21.967Z 2026-04-10T12:14:22.354Z
9626382 9626382 20260408135117_dxeCo NZ005M 2026-04-09T12:08:14.130Z 2026-04-10T12:14:22.342Z
9626274 9626274 20260408133652_pIVSm NZ005M 2026-04-09T12:07:54.339Z 2026-04-10T12:14:22.327Z
9626248 9626248 20260408133101_IEur3 NZ005M 2026-04-09T12:07:49.606Z 2026-04-10T12:14:22.323Z
9626239 9626239 20260408133002_JeENp NZ005M 2026-04-09T12:07:48.745Z 2026-04-10T12:14:22.321Z
9626064 9626064 20260408130248_iMrJX NZ005M 2026-04-09T12:07:25.772Z 2026-04-10T12:14:22.289Z
9625691 9625691 20260408113557_qBhqC NZ005M 2026-04-09T12:06:17.595Z 2026-04-10T12:14:22.223Z
9625583 9625583 20260408112105_DozdI NZ005M 2026-04-09T12:06:01.418Z 2026-04-10T12:14:22.207Z
9625478 9625478 20260408105854_SA1Ib NZ005M 2026-04-09T12:05:38.459Z 2026-04-10T12:14:21.932Z
9625237 9625237 20260408100611_zdLOv NZ005M 2026-04-09T12:04:46.404Z 2026-04-10T12:14:21.885Z
9625112 9625112 20260408093920_5EJRJ NZ005M 2026-04-09T12:04:17.779Z 2026-04-10T12:14:21.857Z
9624533 9624533 20260408073244_K0Mj1 NZ005M 2026-04-09T12:01:53.149Z 2026-04-10T12:14:21.400Z
9612413 9612413 20260406110833_2Oayu NZ005M 2026-04-07T12:01:42.243Z 2026-04-10T12:22:07.579Z
9612366 9612366 20260406101540_oU3AS NZ005M 2026-04-07T12:01:35.822Z 2026-04-10T12:22:05.907Z
9612318 9612318 20260406094236_pC7Id NZ005M 2026-04-07T12:01:29.379Z 2026-04-10T12:22:04.689Z
9612268 9612268 20260406091912_2F3ch NZ005M 2026-04-07T12:01:17.620Z 2026-04-10T12:22:03.161Z
9604358 9604358 20260402172114_NoRbF NZ005M 2026-04-03T12:07:03.716Z 2026-04-10T12:34:49.000Z
9604245 9604245 20260402164419_yV8IE NZ005M 2026-04-03T12:06:29.739Z 2026-04-10T12:34:45.966Z
9604186 9604186 20260402163002_ZypbM NZ005M 2026-04-03T12:06:19.135Z 2026-04-10T12:34:44.855Z
9604173 9604173 20260402162455_rIFgP NZ005M 2026-04-03T12:06:16.773Z 2026-04-10T12:34:44.394Z
9604023 9604023 20260402150115_Y4G3G NZ005M 2026-04-03T12:05:35.338Z 2026-04-10T12:34:17.765Z
9603974 9603974 20260402143023_WBCF4 NZ005M 2026-04-03T12:05:23.656Z 2026-04-10T12:34:16.808Z
9599755 9599755 20260331163845_tSDL1 NZ005M 2026-04-01T12:04:43.160Z 2026-04-09T12:47:23.268Z
9599481 9599481 20260331145639_Bq6fq NZ005M 2026-04-01T12:03:45.708Z 2026-04-09T12:46:48.324Z
9599401 9599401 20260331142443_VrRcD NZ005M 2026-04-01T12:03:27.302Z 2026-04-09T12:46:47.046Z
9599332 9599332 20260331140218_22mLR NZ005M 2026-04-01T12:03:13.827Z 2026-04-09T12:46:46.120Z
9599183 9599183 20260331123009_3Q6va NZ005M 2026-04-01T12:02:39.035Z 2026-04-09T12:46:43.480Z
9597681 9597681 20260330165002_1g9vd NZ005M 2026-03-31T12:06:52.199Z 2026-04-08T12:44:15.122Z
9597405 9597405 20260330161451_v5bgw NZ005M 2026-03-31T12:06:20.351Z 2026-04-08T12:43:42.267Z
9597301 9597301 20260330155856_lAORM NZ005M 2026-03-31T12:06:06.070Z 2026-04-08T12:43:38.014Z
9597210 9597210 20260330153452_QxsAE NZ005M 2026-03-31T12:05:54.860Z 2026-04-08T12:43:35.639Z
9597060 9597060 20260330150855_AqyiW NZ005M 2026-03-31T12:05:35.115Z 2026-04-08T12:43:31.713Z
9597031 9597031 20260330150236_yXhWP NZ005M 2026-03-31T12:05:31.888Z 2026-04-08T12:43:30.966Z
9596688 9596688 20260330134137_0Qe2Q NZ005M 2026-03-31T12:04:44.156Z 2026-04-08T12:43:22.418Z
9596664 9596664 20260330133759_enM4j NZ005M 2026-03-31T12:04:40.281Z 2026-04-08T12:43:21.720Z
9596617 9596617 20260330132431_JN640 NZ005M 2026-03-31T12:04:36.314Z 2026-04-08T12:43:20.794Z
9596598 9596598 20260330131752_AZLyF NZ005M 2026-03-31T12:04:33.843Z 2026-04-08T12:43:20.107Z
9596563 9596563 20260330131353_CzEss NZ005M 2026-03-31T12:04:30.984Z 2026-04-08T12:43:19.639Z
9596552 9596552 20260330131254_PjVPD NZ005M 2026-03-31T12:04:30.014Z 2026-04-08T12:43:19.446Z
9596502 9596502 20260330125647_uMNQF NZ005M 2026-03-31T12:04:25.683Z 2026-04-08T12:43:18.382Z
9595699 9595699 20260330080756_V9PPd NZ005M 2026-03-31T12:02:14.831Z 2026-04-08T12:42:29.878Z
9593755 9593755 20260329145549_X7K1E NZ005M 2026-03-30T12:05:01.516Z 2026-04-07T12:27:34.891Z
9593716 9593716 20260329141907_2UhL2 NZ005M 2026-03-30T12:04:53.274Z 2026-04-07T12:27:33.581Z
9590716 9590716 20260328105310_KPPMh NZ005M 2026-03-29T12:03:10.531Z 2026-04-06T12:38:31.429Z
9583594 9583594 20260326162343_2vRcP NZ005M 2026-03-27T12:09:13.952Z 2026-04-04T12:41:26.804Z
9578984 9578984 20260325171049_Qs94b NZ005M 2026-03-26T12:09:03.929Z 2026-04-03T12:38:48.852Z
9578762 9578762 20260325142759_mCN4b NZ005M 2026-03-26T12:08:26.448Z 2026-04-03T12:38:31.618Z
9578639 9578639 20260325125338_soyth NZ005M 2026-03-26T12:08:08.478Z 2026-04-03T12:38:14.115Z
9578637 9578637 20260325125338_YSNc0 NZ005M 2026-03-26T12:08:08.112Z 2026-04-03T12:38:14.013Z
9574914 9574914 20260323173647_Q7Yw8 NZ005M 2026-03-25T12:19:51.944Z 2026-03-31T12:28:44.227Z
9574558 9574558 20260324174434_cQOrC NZ005M 2026-03-25T12:10:54.254Z 2026-04-02T12:37:02.503Z
9574370 9574370 20260324163808_fXkxJ NZ005M 2026-03-25T12:10:24.736Z 2026-04-02T12:36:49.141Z
9574333 9574333 20260324163133_tDR9k NZ005M 2026-03-25T12:10:21.340Z 2026-04-02T12:36:48.113Z
9574290 9574290 20260324162023_CAEke NZ005M 2026-03-25T12:10:12.960Z 2026-04-02T12:36:46.671Z
9574204 9574204 20260324155213_34vEK NZ005M 2026-03-25T12:09:58.536Z 2026-04-02T12:36:42.086Z
9574197 9574197 20260324154945_s03J7 NZ005M 2026-03-25T12:09:57.533Z 2026-04-02T12:36:41.825Z
9574041 9574041 20260324145739_K10i5 NZ005M 2026-03-25T12:09:29.099Z 2026-04-02T12:36:35.501Z
9574034 9574034 20260324145723_HQYZL NZ005M 2026-03-25T12:09:28.589Z 2026-04-02T12:36:35.403Z
9574017 9574017 20260324145118_4TW4F NZ005M 2026-03-25T12:09:27.190Z 2026-04-02T12:36:34.633Z
9573989 9573989 20260324144426_si9Ow NZ005M 2026-03-25T12:09:21.259Z 2026-04-02T12:36:33.725Z
9573976 9573976 20260324144249_Xrau3 NZ005M 2026-03-25T12:09:19.731Z 2026-04-02T12:36:33.441Z
9573940 9573940 20260324143043_v9jQH NZ005M 2026-03-25T12:09:14.477Z 2026-04-02T12:36:32.326Z
9573779 9573779 20260324134310_Ag2G1 NZ005M 2026-03-25T12:08:44.777Z 2026-04-02T12:36:26.608Z
9573765 9573765 20260324134128_9yXeX NZ005M 2026-03-25T12:08:43.451Z 2026-04-02T12:36:26.268Z
9573712 9573712 20260324133411_pqfuX NZ005M 2026-03-25T12:08:39.490Z 2026-04-02T12:36:24.996Z
9573673 9573673 20260324131835_pDZjr NZ005M 2026-03-25T12:08:35.475Z 2026-04-02T12:36:18.163Z
9573568 9573568 20260324124712_ie8ut NZ005M 2026-03-25T12:08:19.030Z 2026-04-02T12:36:14.726Z
9573548 9573548 20260324124205_cwPRi NZ005M 2026-03-25T12:08:16.591Z 2026-04-02T12:36:14.286Z
9573238 9573238 20260324114007_wg4FW NZ005M 2026-03-25T12:07:31.403Z 2026-04-02T12:36:00.792Z
9573043 9573043 20260324110946_GM3w3 NZ005M 2026-03-25T12:07:03.930Z 2026-04-02T12:35:53.756Z
9572735 9572735 20260324100454_VkAeP NZ005M 2026-03-25T12:06:10.185Z 2026-04-02T12:35:36.614Z
9569134 9569134 20260322133235_I9t3G NZ005M 2026-03-24T12:19:51.935Z 2026-03-30T12:29:34.413Z
9567993 9567993 20260323160426_RvsE9 NZ005M 2026-03-24T12:14:22.019Z 2026-03-31T12:28:21.336Z
9567318 9567318 20260323150547_nRc9G NZ005M 2026-03-24T12:13:22.566Z 2026-03-31T12:28:12.628Z
9566742 9566742 20260323140916_d3syN NZ005M 2026-03-24T12:12:22.743Z 2026-03-31T12:27:56.293Z
9566509 9566509 20260323134719_wPnQz NZ005M 2026-03-24T12:11:59.416Z 2026-03-31T12:27:52.989Z
9566496 9566496 20260323134612_5dh2L NZ005M 2026-03-24T12:11:58.119Z 2026-03-31T12:27:52.827Z
9566437 9566437 20260323133801_jl2n5 NZ005M 2026-03-24T12:11:51.600Z 2026-03-31T12:27:51.875Z
9566076 9566076 20260323130343_xFoev NZ005M 2026-03-24T12:11:18.890Z 2026-03-31T12:27:45.841Z
9566000 9566000 20260323125616_jDNOH NZ005M 2026-03-24T12:11:11.232Z 2026-03-31T12:27:44.569Z
9565010 9565010 20260323113715_RALmj NZ005M 2026-03-24T12:09:15.042Z 2026-03-31T12:27:21.032Z
9564956 9564956 20260323113238_IHmmp NZ005M 2026-03-24T12:09:07.146Z 2026-03-31T12:27:19.841Z
9564602 9564602 20260323105452_DB04I NZ005M 2026-03-24T12:08:26.869Z 2026-03-31T12:27:12.278Z
9564573 9564573 20260323105030_tt8ZB NZ005M 2026-03-24T12:08:23.891Z 2026-03-31T12:27:11.804Z
9563793 9563793 20260323090900_EYuHx NZ005M 2026-03-24T12:06:43.788Z 2026-03-31T12:26:56.721Z
9563727 9563727 20260323090401_Eu8h0 NZ005M 2026-03-24T12:06:36.675Z 2026-03-31T12:26:49.844Z
9563699 9563699 20260323090132_d3hZO NZ005M 2026-03-24T12:06:35.052Z 2026-03-31T12:26:49.542Z
9563455 9563455 20260323082307_NTst1 NZ005M 2026-03-24T12:06:02.764Z 2026-03-31T12:26:43.552Z
9563400 9563400 20260323081226_xPe58 NZ005M 2026-03-24T12:05:55.094Z 2026-03-31T12:26:42.388Z
9558675 9558675 20260322172221_naiPz NZ005M 2026-03-23T12:06:53.989Z 2026-03-30T12:30:19.999Z
9558502 9558502 20260322165239_h0Xi5 NZ005M 2026-03-23T12:06:46.946Z 2026-03-30T12:30:15.564Z
9558034 9558034 20260322153356_pMHTe NZ005M 2026-03-23T12:06:20.391Z 2026-03-30T12:29:54.835Z
9558026 9558026 20260322153354_i2WGv NZ005M 2026-03-23T12:06:20.190Z 2026-03-30T12:29:54.660Z
9557893 9557893 20260322151140_GmLdK NZ005M 2026-03-23T12:06:14.476Z 2026-03-30T12:29:50.916Z
9557795 9557795 20260322145618_fo19Y NZ005M 2026-03-23T12:06:10.340Z 2026-03-30T12:29:47.828Z
9557590 9557590 20260322142817_8a4VO NZ005M 2026-03-23T12:05:57.326Z 2026-03-30T12:29:42.297Z

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