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

979 rows where station_code = "NZ001B" 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
5979080 5979080 20250121155509_5KwKK NZ001B 2025-01-23T14:19:17.061Z 2025-01-30T14:33:37.164Z
5978794 5978794 20250121145326_VRHhf NZ001B 2025-01-23T14:19:03.574Z 2025-01-30T14:33:34.832Z
5978496 5978496 20250121134945_OodLy NZ001B 2025-01-23T14:18:24.842Z 2025-01-30T14:33:33.276Z
5978126 5978126 20250121125311_Yrip8 NZ001B 2025-01-23T14:17:49.418Z 2025-01-30T14:33:30.536Z
5978113 5978113 20250121125135_EB0ca NZ001B 2025-01-23T14:17:48.706Z 2025-01-30T14:33:30.490Z
5977696 5977696 20250121115030_hrsoB NZ001B 2025-01-23T14:17:00.037Z 2025-01-30T14:33:27.302Z
5977509 5977509 20250121112557_19EV8 NZ001B 2025-01-23T14:16:47.544Z 2025-01-30T14:33:24.699Z
5977296 5977296 20250121105348_efd0T NZ001B 2025-01-23T14:16:15.515Z 2025-01-30T14:33:22.347Z
5976948 5976948 20250121095551_8dcD0 NZ001B 2025-01-23T14:15:40.969Z 2025-01-30T14:33:16.964Z
5976892 5976892 20250121094113_TYTTd NZ001B 2025-01-23T14:15:33.301Z 2025-01-30T14:33:14.469Z
5975740 5975740 20250122161451_BbpxS NZ001B 2025-01-23T14:12:29.468Z 2025-01-31T14:35:24.556Z
5975624 5975624 20250122155237_22O8O NZ001B 2025-01-23T14:12:07.735Z 2025-01-31T14:35:23.688Z
5975488 5975488 20250122153203_V8d18 NZ001B 2025-01-23T14:11:56.419Z 2025-01-31T14:35:22.237Z
5975367 5975367 20250122151520_JtM1a NZ001B 2025-01-23T14:11:47.260Z 2025-01-31T14:35:21.097Z
5975333 5975333 20250122150804_zID8s NZ001B 2025-01-23T14:11:44.384Z 2025-01-31T14:35:20.681Z
5975292 5975292 20250122150454_5GCDq NZ001B 2025-01-23T14:11:40.404Z 2025-01-31T14:35:20.456Z
5972896 5972896 20250122092715_WXNF6 NZ001B 2025-01-23T14:05:02.467Z 2025-01-31T14:34:42.823Z
5963285 5963285 20250120160142_0UUw2 NZ001B 2025-01-22T14:09:57.011Z 2025-01-29T14:36:08.436Z
5962840 5962840 20250120141649_K3sqm NZ001B 2025-01-22T14:08:47.904Z 2025-01-29T14:36:05.752Z
5958434 5958434 20250119125558_rQoNm NZ001B 2025-01-20T14:05:02.248Z 2025-01-28T14:35:37.694Z
5958118 5958118 20250119114641_kjIgH NZ001B 2025-01-20T14:03:56.511Z 2025-01-28T14:35:31.874Z
5958107 5958107 20250119114213_bOP9l NZ001B 2025-01-20T14:03:54.954Z 2025-01-28T14:35:31.603Z
5958104 5958104 20250119114212_5lsvR NZ001B 2025-01-20T14:03:54.666Z 2025-01-28T14:35:31.602Z
5957665 5957665 20250119093433_FPz4b NZ001B 2025-01-20T14:02:14.332Z 2025-01-28T14:35:23.341Z
5955826 5955826 20250118112754_OTp34 NZ001B 2025-01-19T14:03:11.469Z 2025-01-27T14:44:24.175Z
5955400 5955400 20250118092623_oHruq NZ001B 2025-01-19T14:01:41.313Z 2025-01-27T14:43:56.150Z
5946704 5946704 20250112114753_vziS2 NZ001B 2025-01-13T14:02:23.881Z 2025-01-21T14:18:27.900Z
5946034 5946034 20250111132109_P6HPM NZ001B 2025-01-12T14:04:52.352Z 2025-01-20T14:20:52.472Z
5945668 5945668 20250111122633_8JbPy NZ001B 2025-01-12T14:03:23.829Z 2025-01-20T14:20:44.224Z
5945587 5945587 20250111120614_QNe04 NZ001B 2025-01-12T14:03:03.557Z 2025-01-20T14:20:42.363Z
5945535 5945535 20250111115852_0jjVv NZ001B 2025-01-12T14:02:52.414Z 2025-01-20T14:20:41.300Z
5941756 5941756 20250108153004_XDbqz NZ001B 2025-01-10T14:13:34.574Z 2025-01-17T14:17:23.102Z
5941279 5941279 20250108143233_EklT2 NZ001B 2025-01-10T14:12:28.111Z 2025-01-17T14:17:06.717Z
5941081 5941081 20250108140740_Ip7Wy NZ001B 2025-01-10T14:12:02.909Z 2025-01-17T14:17:01.810Z
5941050 5941050 20250108140305_Jo5OJ NZ001B 2025-01-10T14:11:57.682Z 2025-01-17T14:17:01.014Z
5940253 5940253 20250108122210_3w0Ha NZ001B 2025-01-10T14:10:01.012Z 2025-01-17T14:16:22.568Z
5940200 5940200 20250108121427_TFPPM NZ001B 2025-01-10T14:09:53.839Z 2025-01-17T14:16:20.952Z
5939239 5939239 20250109153228_RkvYC NZ001B 2025-01-10T14:06:15.276Z 2025-01-18T14:21:07.914Z
5938181 5938181 20250109112809_obTgv NZ001B 2025-01-10T14:02:16.809Z 2025-01-18T14:20:14.284Z
5938163 5938163 20250109112434_uDX4P NZ001B 2025-01-10T14:02:13.028Z 2025-01-18T14:20:13.572Z
5928313 5928313 20250106123524_iXdyt NZ001B 2025-01-08T14:05:52.169Z 2025-01-15T14:25:35.113Z
5928213 5928213 20250106122506_q0KuJ NZ001B 2025-01-08T14:05:31.523Z 2025-01-15T14:25:29.408Z
5928018 5928018 20250106115734_1nIja NZ001B 2025-01-08T14:05:01.696Z 2025-01-15T14:25:24.803Z
5927936 5927936 20250106114258_xGjMI NZ001B 2025-01-08T14:04:43.464Z 2025-01-15T14:25:20.311Z
5926429 5926429 20250105143148_nsgr2 NZ001B 2025-01-07T14:09:18.092Z 2025-01-14T14:26:53.575Z
5913146 5913146 20250103154528_Hfl9z NZ001B 2025-01-06T14:09:31.935Z 2025-01-12T14:24:30.198Z
5913059 5913059 20250103152759_W128r NZ001B 2025-01-06T14:09:20.496Z 2025-01-12T14:24:26.058Z
5877908 5877908 20241231144513_daaFu NZ001B 2025-01-02T14:05:18.459Z 2025-01-09T14:36:37.465Z
5877787 5877787 20241231141951_WSjIl NZ001B 2025-01-02T14:04:44.860Z 2025-01-09T14:36:36.429Z
5874473 5874473 20241228142137_FFjbb NZ001B 2024-12-30T14:01:24.460Z 2025-01-06T14:35:55.630Z
5873002 5873002 20241228104046_fIYeH NZ001B 2024-12-29T14:21:53.120Z 2025-01-05T14:37:48.034Z
5865154 5865154 20241227125055_wVS0t NZ001B 2024-12-28T14:21:15.015Z 2025-01-04T14:43:28.297Z
5864858 5864858 20241227121043_wNGrv NZ001B 2024-12-28T14:20:37.647Z 2025-01-04T14:43:17.667Z
5858539 5858539 20241226151309_OxePd NZ001B 2024-12-27T14:16:02.644Z 2025-01-03T14:33:32.124Z
5835757 5835757 20241221135017_oTwyz NZ001B 2024-12-23T14:34:24.508Z 2024-12-23T14:34:24.508Z
5814730 5814730 20241218124202_icCY2 NZ001B 2024-12-19T14:10:29.361Z 2024-12-26T14:33:43.994Z
5814672 5814672 20241218123715_IlfIk NZ001B 2024-12-19T14:10:24.444Z 2024-12-26T14:33:41.420Z
5814571 5814571 20241218122404_Sd3qG NZ001B 2024-12-19T14:10:14.917Z 2024-12-26T14:33:38.497Z
5814445 5814445 20241218120923_oayl3 NZ001B 2024-12-19T14:09:52.124Z 2024-12-26T14:33:34.550Z
5814234 5814234 20241218114815_q7ZwA NZ001B 2024-12-19T14:09:22.162Z 2024-12-19T14:09:22.162Z
5813910 5813910 20241218111229_2JMBT NZ001B 2024-12-19T14:08:26.530Z 2024-12-26T14:33:17.367Z
5813692 5813692 20241218104402_op62l NZ001B 2024-12-19T14:07:48.755Z 2024-12-26T14:33:06.693Z
5813620 5813620 20241218103239_rvm90 NZ001B 2024-12-19T14:07:39.454Z 2024-12-26T14:33:04.416Z
5813581 5813581 20241218102709_XN66A NZ001B 2024-12-19T14:07:34.214Z 2024-12-26T14:33:02.991Z
5813441 5813441 20241218100652_3hhlB NZ001B 2024-12-19T14:07:12.497Z 2024-12-26T14:32:58.752Z
5810561 5810561 20241217121100_sahHl NZ001B 2024-12-18T14:14:05.619Z 2024-12-25T14:35:00.981Z
5810413 5810413 20241217113125_8xULq NZ001B 2024-12-18T14:13:41.700Z 2024-12-25T14:34:56.721Z
5810290 5810290 20241217105956_3dlq8 NZ001B 2024-12-18T14:13:17.486Z 2024-12-25T14:34:53.363Z
5810253 5810253 20241217105152_jUCcV NZ001B 2024-12-18T14:13:10.579Z 2024-12-25T14:34:52.799Z
5810162 5810162 20241217102508_Kh3aX NZ001B 2024-12-18T14:12:49.504Z 2024-12-25T14:34:50.939Z
5810080 5810080 20241217100321_oqExU NZ001B 2024-12-18T14:12:27.101Z 2024-12-25T14:34:49.324Z
5805262 5805262 20241216120346_dlyp6 NZ001B 2024-12-17T14:04:42.142Z 2024-12-24T14:36:14.766Z
5804977 5804977 20241216100206_Jux2H NZ001B 2024-12-17T14:03:42.838Z 2024-12-24T14:36:05.604Z
5804964 5804964 20241216095728_oxASC NZ001B 2024-12-17T14:03:40.015Z 2024-12-24T14:36:04.933Z
5241529 5241529 20241005110328_RXC8o NZ001B 2024-10-07T12:10:43.182Z 2024-10-14T12:24:26.790Z
5232507 5232507 20241004170306_utmtz NZ001B 2024-10-06T12:11:58.783Z 2024-10-13T12:26:19.249Z
5231629 5231629 20241004150240_gVY1t NZ001B 2024-10-06T12:10:34.372Z 2024-10-13T12:26:18.041Z
5231077 5231077 20241004132525_SdDT6 NZ001B 2024-10-06T12:09:45.403Z 2024-10-13T12:26:17.261Z
5230985 5230985 20241004131331_A2qLa NZ001B 2024-10-06T12:09:39.606Z 2024-10-13T12:26:17.163Z
5197712 5197712 20240929155508_uhiQc NZ001B 2024-10-01T12:13:44.959Z 2024-10-07T12:21:29.717Z
5196325 5196325 20240930102724_3A3n3 NZ001B 2024-10-01T12:07:09.187Z 2024-10-09T12:29:05.465Z
5196272 5196272 20240930101825_Iy7TX NZ001B 2024-10-01T12:07:01.406Z 2024-10-09T12:29:05.268Z
5195587 5195587 20240930075323_40LPI NZ001B 2024-10-01T12:05:06.049Z 2024-10-09T12:29:03.411Z
5194085 5194085 20240929145802_G3d2B NZ001B 2024-09-30T12:19:33.458Z 2024-10-07T12:21:28.782Z
5168002 5168002 20240926171913_YQBST NZ001B 2024-09-27T12:06:23.546Z 2024-10-04T12:25:31.805Z
5167897 5167897 20240926161400_jJHfi NZ001B 2024-09-27T12:06:05.335Z 2024-10-04T12:25:30.827Z
5167725 5167725 20240926144920_sXq3S NZ001B 2024-09-27T12:05:36.823Z 2024-10-04T12:25:29.468Z
5164209 5164209 20240924164911_C4t36 NZ001B 2024-09-26T12:12:27.551Z 2024-10-02T12:19:01.375Z
5163863 5163863 20240924155255_wMT3z NZ001B 2024-09-26T12:12:09.930Z 2024-10-02T12:19:00.814Z
5163830 5163830 20240924154824_18y5W NZ001B 2024-09-26T12:12:08.746Z 2024-10-02T12:19:00.698Z
5130954 5130954 20240917165955_nOIhQ NZ001B 2024-09-19T12:14:01.217Z 2024-09-25T12:22:52.212Z
5059041 5059041 20240910170856_XVcAm NZ001B 2024-09-14T12:05:08.400Z 2024-09-19T12:21:30.322Z
5057716 5057716 20240910150631_Tr8zf NZ001B 2024-09-14T12:01:47.781Z 2024-09-19T12:21:28.636Z
5057212 5057212 20240910135940_QhViX NZ001B 2024-09-14T12:00:32.686Z 2024-09-19T12:21:27.293Z
5057122 5057122 20240910134721_LtI6f NZ001B 2024-09-14T12:00:18.396Z 2024-09-19T12:21:27.076Z
5051295 5051295 20240907171304_qO2ti NZ001B 2024-09-13T12:14:09.368Z 2024-09-16T12:21:00.051Z
5018252 5018252 20240904173147_SspZQ NZ001B 2024-09-10T12:10:16.997Z 2024-09-13T12:19:47.466Z
5018030 5018030 20240904170631_V3cyJ NZ001B 2024-09-10T12:09:54.643Z 2024-09-13T12:19:47.165Z
5015518 5015518 20240904114758_hra2D NZ001B 2024-09-10T12:06:17.356Z 2024-09-13T12:19:44.168Z
4987590 4987590 20240901180323_l2KOB NZ001B 2024-09-07T12:05:58.399Z 2024-09-10T12:19:11.013Z

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