participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
8,564 rows where station_code = "NZ0007" sorted by created_at descending
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 |
---|---|---|---|---|---|
5603467 | 5603467 | 20241125154241_E3oro | NZ0007 | 2024-11-26T14:11:09.737Z | 2024-11-26T14:11:09.737Z |
5603440 | 5603440 | 20241125153141_UkigX | NZ0007 | 2024-11-26T14:11:07.282Z | 2024-11-26T14:11:07.282Z |
5603365 | 5603365 | 20241125151158_gz82K | NZ0007 | 2024-11-26T14:10:59.995Z | 2024-11-26T14:10:59.995Z |
5603297 | 5603297 | 20241125145715_tsntN | NZ0007 | 2024-11-26T14:10:53.131Z | 2024-11-26T14:10:53.131Z |
5603156 | 5603156 | 20241125142712_5fMkI | NZ0007 | 2024-11-26T14:10:24.760Z | 2024-11-26T14:10:24.760Z |
5603034 | 5603034 | 20241125135301_oiOVl | NZ0007 | 2024-11-26T14:10:09.364Z | 2024-11-26T14:10:09.364Z |
5602960 | 5602960 | 20241125134052_IzIKN | NZ0007 | 2024-11-26T14:10:00.281Z | 2024-11-26T14:10:00.281Z |
5602728 | 5602728 | 20241125124800_iHirT | NZ0007 | 2024-11-26T14:09:27.252Z | 2024-11-26T14:09:27.252Z |
5602688 | 5602688 | 20241125124051_8zSVl | NZ0007 | 2024-11-26T14:09:21.708Z | 2024-11-26T14:09:21.708Z |
5602680 | 5602680 | 20241125123845_OpIU3 | NZ0007 | 2024-11-26T14:09:20.715Z | 2024-11-26T14:09:20.715Z |
5602552 | 5602552 | 20241125121519_fc6jU | NZ0007 | 2024-11-26T14:08:47.166Z | 2024-11-26T14:08:47.166Z |
5602536 | 5602536 | 20241125121249_aO3oa | NZ0007 | 2024-11-26T14:08:45.527Z | 2024-11-26T14:08:45.527Z |
5602457 | 5602457 | 20241125115715_8r8SI | NZ0007 | 2024-11-26T14:08:37.726Z | 2024-11-26T14:08:37.726Z |
5602393 | 5602393 | 20241125114748_BBD5o | NZ0007 | 2024-11-26T14:08:31.195Z | 2024-11-26T14:08:31.195Z |
5602175 | 5602175 | 20241125110853_qfOQ9 | NZ0007 | 2024-11-26T14:07:47.877Z | 2024-11-26T14:07:47.877Z |
5602023 | 5602023 | 20241125104509_NjOBI | NZ0007 | 2024-11-26T14:07:30.449Z | 2024-11-26T14:07:30.449Z |
5601966 | 5601966 | 20241125104056_diLK1 | NZ0007 | 2024-11-26T14:07:15.715Z | 2024-11-26T14:07:15.715Z |
5601870 | 5601870 | 20241125102035_fs45u | NZ0007 | 2024-11-26T14:07:01.415Z | 2024-11-26T14:07:01.415Z |
5601859 | 5601859 | 20241125101844_L6LF3 | NZ0007 | 2024-11-26T14:06:59.453Z | 2024-11-26T14:06:59.453Z |
5601792 | 5601792 | 20241125100932_Fy2j6 | NZ0007 | 2024-11-26T14:06:51.597Z | 2024-11-26T14:06:51.597Z |
5601583 | 5601583 | 20241125092453_xc0ki | NZ0007 | 2024-11-26T14:06:09.436Z | 2024-11-26T14:06:09.436Z |
5597146 | 5597146 | 20241124150705_223ze | NZ0007 | 2024-11-25T14:11:11.593Z | 2024-11-26T14:18:44.552Z |
5597070 | 5597070 | 20241124145934_NnTO5 | NZ0007 | 2024-11-25T14:11:03.256Z | 2024-11-26T14:18:44.542Z |
5597050 | 5597050 | 20241124145729_umVRz | NZ0007 | 2024-11-25T14:11:00.534Z | 2024-11-26T14:18:44.539Z |
5597009 | 5597009 | 20241124145419_eIdlz | NZ0007 | 2024-11-25T14:10:57.663Z | 2024-11-26T14:18:44.533Z |
5596998 | 5596998 | 20241124145313_N4E3T | NZ0007 | 2024-11-25T14:10:56.769Z | 2024-11-26T14:18:44.531Z |
5596844 | 5596844 | 20241124143426_uX2cF | NZ0007 | 2024-11-25T14:10:39.778Z | 2024-11-26T14:18:44.489Z |
5596766 | 5596766 | 20241124142359_eiT0r | NZ0007 | 2024-11-25T14:10:33.417Z | 2024-11-26T14:18:44.477Z |
5596734 | 5596734 | 20241124141920_uZCnn | NZ0007 | 2024-11-25T14:10:31.201Z | 2024-11-26T14:18:44.472Z |
5596632 | 5596632 | 20241124141038_FzigB | NZ0007 | 2024-11-25T14:10:24.415Z | 2024-11-26T14:18:44.458Z |
5596567 | 5596567 | 20241124140431_I479N | NZ0007 | 2024-11-25T14:10:20.054Z | 2024-11-26T14:18:44.447Z |
5596328 | 5596328 | 20241124133729_bXcgX | NZ0007 | 2024-11-25T14:09:49.490Z | 2024-11-26T14:18:44.412Z |
5596231 | 5596231 | 20241124132901_WlATP | NZ0007 | 2024-11-25T14:09:41.442Z | 2024-11-26T14:18:44.398Z |
5596185 | 5596185 | 20241124132517_uQjJb | NZ0007 | 2024-11-25T14:09:37.558Z | 2024-11-26T14:18:44.391Z |
5596159 | 5596159 | 20241124132205_DO0Ra | NZ0007 | 2024-11-25T14:09:35.285Z | 2024-11-26T14:18:44.386Z |
5595919 | 5595919 | 20241124125848_tjeM2 | NZ0007 | 2024-11-25T14:09:09.766Z | 2024-11-26T14:18:44.348Z |
5595779 | 5595779 | 20241124124858_va42Y | NZ0007 | 2024-11-25T14:08:53.200Z | 2024-11-26T14:18:44.325Z |
5595243 | 5595243 | 20241124115822_tHSlt | NZ0007 | 2024-11-25T14:07:48.273Z | 2024-11-26T14:18:44.231Z |
5595240 | 5595240 | 20241124115821_PK3Ld | NZ0007 | 2024-11-25T14:07:48.032Z | 2024-11-26T14:18:44.231Z |
5595172 | 5595172 | 20241124115027_BgGf3 | NZ0007 | 2024-11-25T14:07:42.498Z | 2024-11-26T14:18:44.220Z |
5595102 | 5595102 | 20241124114155_ewjgC | NZ0007 | 2024-11-25T14:07:23.502Z | 2024-11-26T14:18:44.207Z |
5595058 | 5595058 | 20241124113735_KLOe1 | NZ0007 | 2024-11-25T14:07:13.908Z | 2024-11-26T14:18:44.199Z |
5594850 | 5594850 | 20241124111133_TnEXF | NZ0007 | 2024-11-25T14:06:43.290Z | 2024-11-26T14:18:44.158Z |
5594773 | 5594773 | 20241124110525_8xZjo | NZ0007 | 2024-11-25T14:06:31.324Z | 2024-11-26T14:18:44.146Z |
5594730 | 5594730 | 20241124110051_OiczC | NZ0007 | 2024-11-25T14:06:24.636Z | 2024-11-26T14:18:44.137Z |
5594685 | 5594685 | 20241124105847_xZ14V | NZ0007 | 2024-11-25T14:06:21.360Z | 2024-11-26T14:18:44.131Z |
5594496 | 5594496 | 20241124103712_kGEpA | NZ0007 | 2024-11-25T14:05:55.391Z | 2024-11-26T14:18:44.097Z |
5594473 | 5594473 | 20241124103323_g3hfK | NZ0007 | 2024-11-25T14:05:49.602Z | 2024-11-26T14:18:44.092Z |
5594398 | 5594398 | 20241124102441_z1MLd | NZ0007 | 2024-11-25T14:05:36.156Z | 2024-11-26T14:18:44.075Z |
5594394 | 5594394 | 20241124102427_NbO5d | NZ0007 | 2024-11-25T14:05:35.249Z | 2024-11-26T14:18:44.074Z |
5594297 | 5594297 | 20241124101331_t3SBG | NZ0007 | 2024-11-25T14:05:24.865Z | 2024-11-26T14:18:44.057Z |
5594287 | 5594287 | 20241124101152_uzj7r | NZ0007 | 2024-11-25T14:05:23.514Z | 2024-11-26T14:18:44.055Z |
5594273 | 5594273 | 20241124100920_firzI | NZ0007 | 2024-11-25T14:05:22.094Z | 2024-11-26T14:18:44.053Z |
5594267 | 5594267 | 20241124100916_wm6nm | NZ0007 | 2024-11-25T14:05:21.731Z | 2024-11-26T14:18:44.052Z |
5594261 | 5594261 | 20241124100817_0G339 | NZ0007 | 2024-11-25T14:05:21.055Z | 2024-11-26T14:18:44.051Z |
5594224 | 5594224 | 20241124100109_6na2E | NZ0007 | 2024-11-25T14:05:08.706Z | 2024-11-26T14:18:44.044Z |
5594084 | 5594084 | 20241124093848_y8k2o | NZ0007 | 2024-11-25T14:04:37.863Z | 2024-11-26T14:18:44.015Z |
5593985 | 5593985 | 20241124092517_o2Rno | NZ0007 | 2024-11-25T14:04:26.453Z | 2024-11-26T14:18:43.994Z |
5583693 | 5583693 | 20241118091049_xBv9S | NZ0007 | 2024-11-23T14:24:52.607Z | 2024-11-26T14:28:00.469Z |
5583691 | 5583691 | 20241118091049_9uVij | NZ0007 | 2024-11-23T14:24:52.566Z | 2024-11-26T14:28:00.464Z |
5577262 | 5577262 | 20241121134028_yy7w6 | NZ0007 | 2024-11-23T14:14:29.367Z | 2024-11-26T14:24:30.944Z |
5577118 | 5577118 | 20241121095232_hesIl | NZ0007 | 2024-11-23T14:12:53.392Z | 2024-11-26T14:24:14.473Z |
5569301 | 5569301 | 20241121150715_kBKM4 | NZ0007 | 2024-11-22T14:10:44.552Z | 2024-11-26T14:24:33.553Z |
5569285 | 5569285 | 20241121150455_IOrnR | NZ0007 | 2024-11-22T14:10:43.698Z | 2024-11-26T14:24:33.525Z |
5569217 | 5569217 | 20241121145332_kJ3yv | NZ0007 | 2024-11-22T14:10:40.210Z | 2024-11-26T14:24:33.406Z |
5569085 | 5569085 | 20241121142932_2UdoP | NZ0007 | 2024-11-22T14:10:18.957Z | 2024-11-26T14:24:32.612Z |
5569008 | 5569008 | 20241121141743_sHTZ2 | NZ0007 | 2024-11-22T14:10:10.816Z | 2024-11-26T14:24:31.932Z |
5568834 | 5568834 | 20241121134505_QhTh5 | NZ0007 | 2024-11-22T14:09:56.116Z | 2024-11-26T14:24:31.096Z |
5568800 | 5568800 | 20241121134055_gqwej | NZ0007 | 2024-11-22T14:09:45.857Z | 2024-11-26T14:24:30.946Z |
5568689 | 5568689 | 20241121132115_ZT50t | NZ0007 | 2024-11-22T14:09:33.559Z | 2024-11-26T14:24:30.688Z |
5568662 | 5568662 | 20241121131833_o2SjW | NZ0007 | 2024-11-22T14:09:31.759Z | 2024-11-26T14:24:30.573Z |
5568608 | 5568608 | 20241121131058_LISyF | NZ0007 | 2024-11-22T14:09:25.625Z | 2024-11-26T14:24:29.998Z |
5568593 | 5568593 | 20241121131018_kEEW1 | NZ0007 | 2024-11-22T14:09:24.457Z | 2024-11-26T14:24:29.732Z |
5568575 | 5568575 | 20241121130609_3pRbs | NZ0007 | 2024-11-22T14:09:22.661Z | 2024-11-26T14:24:29.641Z |
5568373 | 5568373 | 20241121123418_INIfV | NZ0007 | 2024-11-22T14:08:49.648Z | 2024-11-26T14:24:27.571Z |
5568248 | 5568248 | 20241121121456_KURwV | NZ0007 | 2024-11-22T14:08:35.383Z | 2024-11-26T14:24:26.343Z |
5568225 | 5568225 | 20241121120923_nZyUe | NZ0007 | 2024-11-22T14:08:31.848Z | 2024-11-26T14:24:25.904Z |
5568113 | 5568113 | 20241121115151_YR5qO | NZ0007 | 2024-11-22T14:08:07.784Z | 2024-11-26T14:24:24.808Z |
5568070 | 5568070 | 20241121114608_voFoA | NZ0007 | 2024-11-22T14:08:03.400Z | 2024-11-26T14:24:24.355Z |
5567729 | 5567729 | 20241121105754_V8NGz | NZ0007 | 2024-11-22T14:07:09.551Z | 2024-11-26T14:24:21.109Z |
5560760 | 5560760 | 20241120141641_wKFsE | NZ0007 | 2024-11-21T14:09:42.947Z | 2024-11-26T14:26:07.700Z |
5560186 | 5560186 | 20241120121533_eQBCb | NZ0007 | 2024-11-21T14:08:13.213Z | 2024-11-26T14:26:03.846Z |
5560184 | 5560184 | 20241120121524_CN29V | NZ0007 | 2024-11-21T14:08:12.840Z | 2024-11-26T14:26:03.846Z |
5560103 | 5560103 | 20241120115926_phbjl | NZ0007 | 2024-11-21T14:08:03.256Z | 2024-11-26T14:26:03.191Z |
5560045 | 5560045 | 20241120115143_whclI | NZ0007 | 2024-11-21T14:07:56.175Z | 2024-11-26T14:26:02.894Z |
5559842 | 5559842 | 20241120112341_3eVE9 | NZ0007 | 2024-11-21T14:07:19.147Z | 2024-11-26T14:26:01.580Z |
5559764 | 5559764 | 20241120111415_oYeeb | NZ0007 | 2024-11-21T14:07:08.504Z | 2024-11-26T14:26:00.205Z |
5559504 | 5559504 | 20241120103502_wolHt | NZ0007 | 2024-11-21T14:06:28.686Z | 2024-11-26T14:25:57.312Z |
5559449 | 5559449 | 20241120102525_gxgIa | NZ0007 | 2024-11-21T14:06:21.882Z | 2024-11-26T14:25:57.081Z |
5559433 | 5559433 | 20241120102225_NmqYC | NZ0007 | 2024-11-21T14:06:19.344Z | 2024-11-26T14:25:57.014Z |
5559405 | 5559405 | 20241120101950_ixsU9 | NZ0007 | 2024-11-21T14:06:15.541Z | 2024-11-26T14:25:56.936Z |
5551587 | 5551587 | 20241118142151_S5SRt | NZ0007 | 2024-11-19T14:05:01.788Z | 2024-11-26T14:28:08.283Z |
5550650 | 5550650 | 20241118110322_I0l5K | NZ0007 | 2024-11-19T14:02:52.373Z | 2024-11-26T14:28:03.241Z |
5550482 | 5550482 | 20241118102845_jj4BR | NZ0007 | 2024-11-19T14:02:25.432Z | 2024-11-26T14:28:01.716Z |
5550479 | 5550479 | 20241118102431_Qvl6J | NZ0007 | 2024-11-19T14:02:24.520Z | 2024-11-26T14:28:01.705Z |
5550374 | 5550374 | 20241118101031_LDejS | NZ0007 | 2024-11-19T14:02:15.313Z | 2024-11-26T14:28:01.463Z |
5550264 | 5550264 | 20241118095738_vSwDP | NZ0007 | 2024-11-19T14:02:00.616Z | 2024-11-26T14:28:01.239Z |
5550108 | 5550108 | 20241118093102_kyLN5 | NZ0007 | 2024-11-19T14:01:35.280Z | 2024-11-26T14:28:00.860Z |
5550079 | 5550079 | 20241118092850_yH3bY | NZ0007 | 2024-11-19T14:01:33.081Z | 2024-11-26T14:28:00.815Z |
5549984 | 5549984 | 20241118090143_YkB3Y | NZ0007 | 2024-11-19T14:01:24.139Z | 2024-11-26T14:27:59.659Z |
Advanced export
JSON shape: default, array, newline-delimited
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);