participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,646 rows where station_code = "NZ0014" 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 |
---|---|---|---|---|---|
5459317 | 5459317 | 20241101104338_X5f2x | NZ0014 | 2024-11-03T14:11:42.043Z | 2024-11-03T14:19:33.319Z |
5458943 | 5458943 | 20241101094932_G9SWo | NZ0014 | 2024-11-03T14:10:51.638Z | 2024-11-03T14:19:33.236Z |
5458817 | 5458817 | 20241101092230_GxwoY | NZ0014 | 2024-11-03T14:10:39.924Z | 2024-11-03T14:19:33.205Z |
5458583 | 5458583 | 20241101084601_XWUWr | NZ0014 | 2024-11-03T14:10:02.074Z | 2024-11-03T14:19:33.154Z |
5458407 | 5458407 | 20241101082409_20a5P | NZ0014 | 2024-11-03T14:09:43.942Z | 2024-11-03T14:19:33.121Z |
5458370 | 5458370 | 20241101081811_DG1eq | NZ0014 | 2024-11-03T14:09:40.438Z | 2024-11-03T14:19:33.114Z |
5457979 | 5457979 | 20241102155218_kf3rP | NZ0014 | 2024-11-03T14:08:28.089Z | 2024-11-03T14:08:28.089Z |
5457729 | 5457729 | 20241102151615_83ADL | NZ0014 | 2024-11-03T14:07:55.042Z | 2024-11-03T14:07:55.042Z |
5457158 | 5457158 | 20241102134101_j5O3t | NZ0014 | 2024-11-03T14:06:40.466Z | 2024-11-03T14:06:40.466Z |
5457117 | 5457117 | 20241102133436_PARxI | NZ0014 | 2024-11-03T14:06:35.950Z | 2024-11-03T14:06:35.950Z |
5456592 | 5456592 | 20241102114837_jXa31 | NZ0014 | 2024-11-03T14:05:03.989Z | 2024-11-03T14:05:03.989Z |
5456547 | 5456547 | 20241102114517_wOy26 | NZ0014 | 2024-11-03T14:04:58.205Z | 2024-11-03T14:04:58.205Z |
5456429 | 5456429 | 20241102111955_DR9qm | NZ0014 | 2024-11-03T14:04:32.499Z | 2024-11-03T14:04:32.499Z |
5449249 | 5449249 | 20241031151022_fWG1N | NZ0014 | 2024-11-02T12:12:20.457Z | 2024-11-03T14:20:49.897Z |
5448872 | 5448872 | 20241031142706_lNOVn | NZ0014 | 2024-11-02T12:11:37.609Z | 2024-11-03T14:20:43.807Z |
5448843 | 5448843 | 20241031142300_qSjqH | NZ0014 | 2024-11-02T12:11:33.247Z | 2024-11-03T14:20:43.333Z |
5445868 | 5445868 | 20241031085637_tCoWF | NZ0014 | 2024-11-02T12:03:25.638Z | 2024-11-03T14:19:51.134Z |
5445820 | 5445820 | 20241031085254_I1xHI | NZ0014 | 2024-11-02T12:03:19.203Z | 2024-11-03T14:19:50.474Z |
5445689 | 5445689 | 20241031083616_UN52U | NZ0014 | 2024-11-02T12:02:49.984Z | 2024-11-03T14:19:48.314Z |
5445662 | 5445662 | 20241031083335_XGlFk | NZ0014 | 2024-11-02T12:02:46.601Z | 2024-11-03T14:19:48.060Z |
5437398 | 5437398 | 20241030150320_xf2tb | NZ0014 | 2024-11-01T12:09:31.872Z | 2024-11-03T14:22:39.428Z |
5437343 | 5437343 | 20241030145741_QxbEu | NZ0014 | 2024-11-01T12:09:26.306Z | 2024-11-03T14:22:39.222Z |
5437264 | 5437264 | 20241030144859_xHEpI | NZ0014 | 2024-11-01T12:09:18.725Z | 2024-11-03T14:22:38.953Z |
5437125 | 5437125 | 20241030143044_y6vAW | NZ0014 | 2024-11-01T12:09:01.990Z | 2024-11-03T14:22:38.666Z |
5436742 | 5436742 | 20241030134348_A7uLw | NZ0014 | 2024-11-01T12:08:10.278Z | 2024-11-03T14:22:37.623Z |
5436703 | 5436703 | 20241030134052_2V6Ht | NZ0014 | 2024-11-01T12:08:06.894Z | 2024-11-03T14:22:37.543Z |
5436655 | 5436655 | 20241030133252_JxqYX | NZ0014 | 2024-11-01T12:08:01.718Z | 2024-11-03T14:22:37.410Z |
5436461 | 5436461 | 20241030131041_PDa5N | NZ0014 | 2024-11-01T12:07:42.956Z | 2024-11-03T14:22:36.715Z |
5436059 | 5436059 | 20241030122518_GtYdl | NZ0014 | 2024-11-01T12:06:42.654Z | 2024-11-03T14:22:35.222Z |
5435941 | 5435941 | 20241030121304_S2dnv | NZ0014 | 2024-11-01T12:06:25.753Z | 2024-11-03T14:22:34.640Z |
5435756 | 5435756 | 20241030115433_Jq1cg | NZ0014 | 2024-11-01T12:05:51.610Z | 2024-11-03T14:22:34.029Z |
5435749 | 5435749 | 20241030115422_Vy56k | NZ0014 | 2024-11-01T12:05:51.227Z | 2024-11-03T14:22:34.024Z |
5435665 | 5435665 | 20241030114844_GqKkZ | NZ0014 | 2024-11-01T12:05:44.190Z | 2024-11-03T14:22:33.469Z |
5435564 | 5435564 | 20241030114229_JcOt3 | NZ0014 | 2024-11-01T12:05:35.585Z | 2024-11-03T14:22:33.217Z |
5435542 | 5435542 | 20241030114045_mwZMm | NZ0014 | 2024-11-01T12:05:28.529Z | 2024-11-03T14:22:33.137Z |
5426653 | 5426653 | 20241028133852_TzV7j | NZ0014 | 2024-10-31T12:12:19.436Z | 2024-11-03T14:24:44.348Z |
5425213 | 5425213 | 20241029161038_uOk2s | NZ0014 | 2024-10-31T12:07:16.967Z | 2024-11-03T14:23:41.409Z |
5425129 | 5425129 | 20241029155736_oHn3O | NZ0014 | 2024-10-31T12:06:54.937Z | 2024-11-03T14:23:40.929Z |
5424898 | 5424898 | 20241029153004_xUhEp | NZ0014 | 2024-10-31T12:06:24.792Z | 2024-11-03T14:23:39.673Z |
5424766 | 5424766 | 20241029150945_4raTa | NZ0014 | 2024-10-31T12:06:00.068Z | 2024-11-03T14:23:38.760Z |
5416515 | 5416515 | 20241027160338_uOp8s | NZ0014 | 2024-10-30T12:11:41.940Z | 2024-11-03T14:25:42.348Z |
5416445 | 5416445 | 20241027155329_6I93E | NZ0014 | 2024-10-30T12:11:36.088Z | 2024-11-03T14:25:42.220Z |
5416336 | 5416336 | 20241027154357_t4Hoy | NZ0014 | 2024-10-30T12:11:29.171Z | 2024-11-03T14:25:42.108Z |
5416201 | 5416201 | 20241027152744_h7EOZ | NZ0014 | 2024-10-30T12:11:19.076Z | 2024-11-03T14:25:41.654Z |
5416058 | 5416058 | 20241027150937_ChLxd | NZ0014 | 2024-10-30T12:10:51.705Z | 2024-11-03T14:25:41.455Z |
5415987 | 5415987 | 20241027145639_DSiWt | NZ0014 | 2024-10-30T12:10:43.865Z | 2024-11-03T14:25:41.330Z |
5415977 | 5415977 | 20241027145628_jnwQL | NZ0014 | 2024-10-30T12:10:42.348Z | 2024-11-03T14:25:41.324Z |
5415685 | 5415685 | 20241027142535_YaASQ | NZ0014 | 2024-10-30T12:10:21.984Z | 2024-11-03T14:25:40.163Z |
5415671 | 5415671 | 20241027142338_g5W35 | NZ0014 | 2024-10-30T12:10:19.475Z | 2024-11-03T14:25:40.090Z |
5415529 | 5415529 | 20241027140653_COmFk | NZ0014 | 2024-10-30T12:09:53.175Z | 2024-11-03T14:25:39.832Z |
5415257 | 5415257 | 20241027132759_QDq2l | NZ0014 | 2024-10-30T12:09:28.139Z | 2024-11-03T14:25:39.382Z |
5415208 | 5415208 | 20241027131943_RV1N3 | NZ0014 | 2024-10-30T12:09:14.771Z | 2024-11-03T14:25:39.331Z |
5415092 | 5415092 | 20241027130043_2alsG | NZ0014 | 2024-10-30T12:08:56.950Z | 2024-11-03T14:25:38.927Z |
5414980 | 5414980 | 20241027123829_43Y3g | NZ0014 | 2024-10-30T12:08:45.483Z | 2024-11-03T14:25:38.507Z |
5414875 | 5414875 | 20241027122249_A3QE5 | NZ0014 | 2024-10-30T12:08:28.343Z | 2024-11-03T14:25:38.133Z |
5414867 | 5414867 | 20241027122043_dW3Ls | NZ0014 | 2024-10-30T12:08:24.706Z | 2024-11-03T14:25:38.111Z |
5414170 | 5414170 | 20241027111220_NydDM | NZ0014 | 2024-10-30T12:06:46.177Z | 2024-11-03T14:25:35.737Z |
5413915 | 5413915 | 20241027104219_3ZBLF | NZ0014 | 2024-10-30T12:06:09.233Z | 2024-11-03T14:25:34.940Z |
5413899 | 5413899 | 20241027104105_zA12k | NZ0014 | 2024-10-30T12:06:06.666Z | 2024-11-03T14:25:34.872Z |
5413260 | 5413260 | 20241028092612_EYSRr | NZ0014 | 2024-10-30T12:02:27.235Z | 2024-11-03T14:24:33.759Z |
5411270 | 5411270 | 20241027082217_oVH0T | NZ0014 | 2024-10-29T12:18:38.692Z | 2024-11-03T14:25:29.733Z |
5401322 | 5401322 | 20241027074207_zzNlo | NZ0014 | 2024-10-29T12:01:13.281Z | 2024-11-03T14:25:28.556Z |
5392316 | 5392316 | 20241026155229_DVahb | NZ0014 | 2024-10-28T12:07:42.980Z | 2024-11-03T14:26:18.004Z |
5391779 | 5391779 | 20241026131509_bGIPj | NZ0014 | 2024-10-28T12:06:24.547Z | 2024-11-03T14:26:15.574Z |
5381241 | 5381241 | 20241025153420_7aZHi | NZ0014 | 2024-10-27T12:07:58.441Z | 2024-11-03T14:27:13.796Z |
5368042 | 5368042 | 20241024082010_MY4Q3 | NZ0014 | 2024-10-26T12:02:22.556Z | 2024-11-02T12:28:14.964Z |
5367957 | 5367957 | 20241024080752_9vD1V | NZ0014 | 2024-10-26T12:02:08.236Z | 2024-11-02T12:28:14.823Z |
5367943 | 5367943 | 20241024080636_vkX5W | NZ0014 | 2024-10-26T12:02:05.565Z | 2024-11-02T12:28:14.814Z |
5357815 | 5357815 | 20241023101756_hrI8Y | NZ0014 | 2024-10-25T12:04:36.149Z | 2024-11-01T12:26:41.389Z |
5357401 | 5357401 | 20241023092940_XWrTA | NZ0014 | 2024-10-25T12:03:28.597Z | 2024-11-01T12:26:40.166Z |
5357163 | 5357163 | 20241023085040_ypZHO | NZ0014 | 2024-10-25T12:02:49.486Z | 2024-11-01T12:26:38.891Z |
5347492 | 5347492 | 20241022152624_2n6vt | NZ0014 | 2024-10-24T12:08:16.878Z | 2024-10-31T12:29:50.608Z |
5347382 | 5347382 | 20241022150546_TRptg | NZ0014 | 2024-10-24T12:07:51.765Z | 2024-10-31T12:29:50.415Z |
5347284 | 5347284 | 20241022145216_eg020 | NZ0014 | 2024-10-24T12:07:24.620Z | 2024-10-31T12:29:50.232Z |
5346506 | 5346506 | 20241022120810_J3UAH | NZ0014 | 2024-10-24T12:04:55.779Z | 2024-10-31T12:29:47.109Z |
5336156 | 5336156 | 20241022074656_qQnf2 | NZ0014 | 2024-10-23T12:01:36.100Z | 2024-10-31T12:29:39.264Z |
5331919 | 5331919 | 20241021154233_3FLzb | NZ0014 | 2024-10-22T12:09:55.423Z | 2024-10-30T12:26:40.132Z |
5331674 | 5331674 | 20241021151103_ELuNV | NZ0014 | 2024-10-22T12:09:27.736Z | 2024-10-30T12:26:39.879Z |
5331445 | 5331445 | 20241021143542_zECiT | NZ0014 | 2024-10-22T12:09:02.925Z | 2024-10-30T12:26:39.500Z |
5331396 | 5331396 | 20241021142939_8JuBP | NZ0014 | 2024-10-22T12:08:59.857Z | 2024-10-30T12:26:39.371Z |
5330754 | 5330754 | 20241021124011_8O8M8 | NZ0014 | 2024-10-22T12:07:35.170Z | 2024-10-30T12:26:38.409Z |
5330659 | 5330659 | 20241021122640_nNLUx | NZ0014 | 2024-10-22T12:07:24.262Z | 2024-10-30T12:26:37.778Z |
5330453 | 5330453 | 20241021120244_UOwaj | NZ0014 | 2024-10-22T12:06:58.097Z | 2024-10-30T12:26:37.324Z |
5330397 | 5330397 | 20241021115733_2jCFK | NZ0014 | 2024-10-22T12:06:48.268Z | 2024-10-30T12:26:37.167Z |
5330256 | 5330256 | 20241021114255_ZCVjQ | NZ0014 | 2024-10-22T12:06:32.789Z | 2024-10-30T12:26:36.596Z |
5330240 | 5330240 | 20241021114100_LV8Bp | NZ0014 | 2024-10-22T12:06:30.657Z | 2024-10-30T12:26:36.558Z |
5330062 | 5330062 | 20241021112316_A2MFg | NZ0014 | 2024-10-22T12:05:55.590Z | 2024-10-30T12:26:36.082Z |
5329681 | 5329681 | 20241021104334_V4rhe | NZ0014 | 2024-10-22T12:04:54.002Z | 2024-10-30T12:26:35.099Z |
5329236 | 5329236 | 20241021095449_EHvql | NZ0014 | 2024-10-22T12:03:39.635Z | 2024-10-30T12:26:34.056Z |
5316081 | 5316081 | 20241015162649_H3CxE | NZ0014 | 2024-10-17T12:05:45.431Z | 2024-10-24T12:27:55.308Z |
5316004 | 5316004 | 20241015160914_y056E | NZ0014 | 2024-10-17T12:05:40.552Z | 2024-10-24T12:27:55.136Z |
5315688 | 5315688 | 20241015144401_nKv6K | NZ0014 | 2024-10-17T12:05:20.077Z | 2024-10-24T12:27:54.027Z |
5315671 | 5315671 | 20241015143845_PAN2L | NZ0014 | 2024-10-17T12:05:17.831Z | 2024-10-24T12:27:53.873Z |
5315638 | 5315638 | 20241015143057_ouIPt | NZ0014 | 2024-10-17T12:05:12.867Z | 2024-10-24T12:27:53.774Z |
5315611 | 5315611 | 20241015142355_NVteJ | NZ0014 | 2024-10-17T12:05:08.935Z | 2024-10-24T12:27:53.675Z |
5315607 | 5315607 | 20241015142348_el4TJ | NZ0014 | 2024-10-17T12:05:07.528Z | 2024-10-24T12:27:53.674Z |
5315565 | 5315565 | 20241015140706_FG60H | NZ0014 | 2024-10-17T12:05:02.518Z | 2024-10-24T12:27:53.335Z |
5315548 | 5315548 | 20241015135924_uQuHz | NZ0014 | 2024-10-17T12:04:59.863Z | 2024-10-24T12:27:53.318Z |
5315481 | 5315481 | 20241015132939_3Nw1l | NZ0014 | 2024-10-17T12:04:47.808Z | 2024-10-24T12:27:53.135Z |
5314792 | 5314792 | 20241016155115_HVqDa | NZ0014 | 2024-10-17T12:02:50.636Z | 2024-10-25T12:24:32.344Z |
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);