participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
5,889 rows where station_code = "NZ0042" 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 |
---|---|---|---|---|---|
5461004 | 5461004 | 20241101153200_ldeOU | NZ0042 | 2024-11-03T14:14:38.420Z | 2024-11-03T14:19:33.652Z |
5460880 | 5460880 | 20241101151718_skoh0 | NZ0042 | 2024-11-03T14:14:32.701Z | 2024-11-03T14:19:33.630Z |
5460754 | 5460754 | 20241101145949_eedgx | NZ0042 | 2024-11-03T14:14:21.050Z | 2024-11-03T14:19:33.608Z |
5460650 | 5460650 | 20241101144322_dxeBy | NZ0042 | 2024-11-03T14:14:07.750Z | 2024-11-03T14:19:33.590Z |
5460607 | 5460607 | 20241101143756_IpW1H | NZ0042 | 2024-11-03T14:14:03.026Z | 2024-11-03T14:19:33.583Z |
5460582 | 5460582 | 20241101143257_Th3qn | NZ0042 | 2024-11-03T14:14:00.141Z | 2024-11-03T14:19:33.579Z |
5460440 | 5460440 | 20241101141019_jIzAP | NZ0042 | 2024-11-03T14:13:44.605Z | 2024-11-03T14:19:33.547Z |
5460191 | 5460191 | 20241101130332_DWV1P | NZ0042 | 2024-11-03T14:13:27.237Z | 2024-11-03T14:19:33.494Z |
5460142 | 5460142 | 20241101125357_tqsvq | NZ0042 | 2024-11-03T14:13:24.196Z | 2024-11-03T14:19:33.485Z |
5460074 | 5460074 | 20241101123818_vNGlG | NZ0042 | 2024-11-03T14:13:19.230Z | 2024-11-03T14:19:33.472Z |
5459991 | 5459991 | 20241101122744_oOmN3 | NZ0042 | 2024-11-03T14:13:03.524Z | 2024-11-03T14:19:33.459Z |
5459951 | 5459951 | 20241101122224_k2Eoz | NZ0042 | 2024-11-03T14:12:56.793Z | 2024-11-03T14:19:33.452Z |
5459889 | 5459889 | 20241101121102_QZ9ip | NZ0042 | 2024-11-03T14:12:45.890Z | 2024-11-03T14:19:33.437Z |
5459858 | 5459858 | 20241101120427_rzZpy | NZ0042 | 2024-11-03T14:12:40.413Z | 2024-11-03T14:19:33.430Z |
5459722 | 5459722 | 20241101114304_LiWne | NZ0042 | 2024-11-03T14:12:30.656Z | 2024-11-03T14:19:33.405Z |
5459668 | 5459668 | 20241101113210_HeVAw | NZ0042 | 2024-11-03T14:12:26.302Z | 2024-11-03T14:19:33.393Z |
5459498 | 5459498 | 20241101110802_kiD9U | NZ0042 | 2024-11-03T14:12:02.118Z | 2024-11-03T14:19:33.355Z |
5459355 | 5459355 | 20241101104721_fAHbB | NZ0042 | 2024-11-03T14:11:44.053Z | 2024-11-03T14:19:33.325Z |
5459320 | 5459320 | 20241101104338_X5f2x | NZ0042 | 2024-11-03T14:11:42.043Z | 2024-11-03T14:19:33.319Z |
5459178 | 5459178 | 20241101102050_DstMT | NZ0042 | 2024-11-03T14:11:27.461Z | 2024-11-03T14:19:33.287Z |
5459084 | 5459084 | 20241101100542_I22Pb | NZ0042 | 2024-11-03T14:11:17.369Z | 2024-11-03T14:19:33.264Z |
5458994 | 5458994 | 20241101095642_gOZH6 | NZ0042 | 2024-11-03T14:10:56.587Z | 2024-11-03T14:19:33.246Z |
5458909 | 5458909 | 20241101094106_U8Bve | NZ0042 | 2024-11-03T14:10:48.172Z | 2024-11-03T14:19:33.227Z |
5458839 | 5458839 | 20241101092517_yum5l | NZ0042 | 2024-11-03T14:10:41.529Z | 2024-11-03T14:19:33.210Z |
5458809 | 5458809 | 20241101092003_selWJ | NZ0042 | 2024-11-03T14:10:39.031Z | 2024-11-03T14:19:33.202Z |
5458586 | 5458586 | 20241101084601_XWUWr | NZ0042 | 2024-11-03T14:10:02.074Z | 2024-11-03T14:19:33.154Z |
5458373 | 5458373 | 20241101081811_DG1eq | NZ0042 | 2024-11-03T14:09:40.438Z | 2024-11-03T14:19:33.114Z |
5458324 | 5458324 | 20241101080529_Vbb78 | NZ0042 | 2024-11-03T14:09:35.286Z | 2024-11-03T14:19:33.103Z |
5457925 | 5457925 | 20241102154030_IvAFe | NZ0042 | 2024-11-03T14:08:21.360Z | 2024-11-03T14:08:21.360Z |
5457882 | 5457882 | 20241102153442_xGNtP | NZ0042 | 2024-11-03T14:08:18.276Z | 2024-11-03T14:08:18.276Z |
5457821 | 5457821 | 20241102152624_K3txN | NZ0042 | 2024-11-03T14:08:14.336Z | 2024-11-03T14:08:14.336Z |
5457744 | 5457744 | 20241102151908_IqvH3 | NZ0042 | 2024-11-03T14:07:56.777Z | 2024-11-03T14:07:56.777Z |
5457732 | 5457732 | 20241102151615_83ADL | NZ0042 | 2024-11-03T14:07:55.043Z | 2024-11-03T14:07:55.043Z |
5457683 | 5457683 | 20241102151008_ujyNV | NZ0042 | 2024-11-03T14:07:51.160Z | 2024-11-03T14:07:51.160Z |
5457528 | 5457528 | 20241102144003_pUmoV | NZ0042 | 2024-11-03T14:07:36.131Z | 2024-11-03T14:07:36.131Z |
5457490 | 5457490 | 20241102143715_Q5KU3 | NZ0042 | 2024-11-03T14:07:33.196Z | 2024-11-03T14:07:33.196Z |
5457441 | 5457441 | 20241102143051_F2hYE | NZ0042 | 2024-11-03T14:07:19.609Z | 2024-11-03T14:07:19.609Z |
5457272 | 5457272 | 20241102140228_oY9a2 | NZ0042 | 2024-11-03T14:07:01.591Z | 2024-11-03T14:07:01.591Z |
5456422 | 5456422 | 20241102111815_Qp80J | NZ0042 | 2024-11-03T14:04:31.187Z | 2024-11-03T14:04:31.187Z |
5448401 | 5448401 | 20241031132455_22VLI | NZ0042 | 2024-11-02T12:10:41.220Z | 2024-11-03T14:20:36.692Z |
5448361 | 5448361 | 20241031132004_L8poH | NZ0042 | 2024-11-02T12:10:36.796Z | 2024-11-03T14:20:36.320Z |
5448139 | 5448139 | 20241031124759_jAAgx | NZ0042 | 2024-11-02T12:10:04.449Z | 2024-11-03T14:20:33.381Z |
5448060 | 5448060 | 20241031123702_RkBRt | NZ0042 | 2024-11-02T12:09:51.614Z | 2024-11-03T14:20:32.202Z |
5448007 | 5448007 | 20241031123206_f38Zb | NZ0042 | 2024-11-02T12:09:44.742Z | 2024-11-03T14:20:31.460Z |
5447815 | 5447815 | 20241031121344_3g0Uu | NZ0042 | 2024-11-02T12:09:12.173Z | 2024-11-03T14:20:28.638Z |
5447758 | 5447758 | 20241031120851_3V7pz | NZ0042 | 2024-11-02T12:09:02.791Z | 2024-11-03T14:20:27.910Z |
5446340 | 5446340 | 20241031094939_yfuUm | NZ0042 | 2024-11-02T12:04:58.661Z | 2024-11-03T14:20:00.702Z |
5445825 | 5445825 | 20241031085254_I1xHI | NZ0042 | 2024-11-02T12:03:19.203Z | 2024-11-03T14:19:50.474Z |
5445693 | 5445693 | 20241031083616_UN52U | NZ0042 | 2024-11-02T12:02:50.005Z | 2024-11-03T14:19:48.314Z |
5437600 | 5437600 | 20241030152623_m1pMS | NZ0042 | 2024-11-01T12:10:04.592Z | 2024-11-03T14:22:40.101Z |
5437524 | 5437524 | 20241030151738_kGGd3 | NZ0042 | 2024-11-01T12:09:56.902Z | 2024-11-03T14:22:39.826Z |
5437419 | 5437419 | 20241030150528_1a17e | NZ0042 | 2024-11-01T12:09:33.903Z | 2024-11-03T14:22:39.508Z |
5437269 | 5437269 | 20241030144859_xHEpI | NZ0042 | 2024-11-01T12:09:18.725Z | 2024-11-03T14:22:38.954Z |
5437239 | 5437239 | 20241030144654_TcQsf | NZ0042 | 2024-11-01T12:09:16.810Z | 2024-11-03T14:22:38.936Z |
5437059 | 5437059 | 20241030142427_3lYlj | NZ0042 | 2024-11-01T12:08:48.997Z | 2024-11-03T14:22:38.478Z |
5436998 | 5436998 | 20241030141618_y2JYi | NZ0042 | 2024-11-01T12:08:41.155Z | 2024-11-03T14:22:38.245Z |
5436928 | 5436928 | 20241030140619_GCGgs | NZ0042 | 2024-11-01T12:08:36.015Z | 2024-11-03T14:22:38.100Z |
5436867 | 5436867 | 20241030135911_3s17B | NZ0042 | 2024-11-01T12:08:30.084Z | 2024-11-03T14:22:37.937Z |
5436706 | 5436706 | 20241030134052_2V6Ht | NZ0042 | 2024-11-01T12:08:06.894Z | 2024-11-03T14:22:37.543Z |
5436547 | 5436547 | 20241030131921_6o7r1 | NZ0042 | 2024-11-01T12:07:51.218Z | 2024-11-03T14:22:37.034Z |
5436194 | 5436194 | 20241030123737_FQv9H | NZ0042 | 2024-11-01T12:07:04.538Z | 2024-11-03T14:22:35.707Z |
5436064 | 5436064 | 20241030122518_GtYdl | NZ0042 | 2024-11-01T12:06:42.655Z | 2024-11-03T14:22:35.222Z |
5436052 | 5436052 | 20241030122409_KWktd | NZ0042 | 2024-11-01T12:06:40.121Z | 2024-11-03T14:22:35.186Z |
5435752 | 5435752 | 20241030115422_Vy56k | NZ0042 | 2024-11-01T12:05:51.227Z | 2024-11-03T14:22:34.024Z |
5435736 | 5435736 | 20241030115345_aqYEJ | NZ0042 | 2024-11-01T12:05:50.145Z | 2024-11-03T14:22:33.919Z |
5435646 | 5435646 | 20241030114713_fxoYL | NZ0042 | 2024-11-01T12:05:42.947Z | 2024-11-03T14:22:33.428Z |
5435621 | 5435621 | 20241030114449_YES68 | NZ0042 | 2024-11-01T12:05:40.349Z | 2024-11-03T14:22:33.348Z |
5435586 | 5435586 | 20241030114300_daJCs | NZ0042 | 2024-11-01T12:05:37.147Z | 2024-11-03T14:22:33.254Z |
5435568 | 5435568 | 20241030114229_JcOt3 | NZ0042 | 2024-11-01T12:05:35.585Z | 2024-11-03T14:22:33.217Z |
5435563 | 5435563 | 20241030114207_HLeY8 | NZ0042 | 2024-11-01T12:05:35.168Z | 2024-11-03T14:22:33.215Z |
5435554 | 5435554 | 20241030114121_cflFc | NZ0042 | 2024-11-01T12:05:32.982Z | 2024-11-03T14:22:33.163Z |
5435545 | 5435545 | 20241030114045_mwZMm | NZ0042 | 2024-11-01T12:05:28.543Z | 2024-11-03T14:22:33.137Z |
5435329 | 5435329 | 20241030111832_cZDam | NZ0042 | 2024-11-01T12:04:55.668Z | 2024-11-03T14:22:32.104Z |
5435148 | 5435148 | 20241030105447_Qu1rw | NZ0042 | 2024-11-01T12:04:23.688Z | 2024-11-03T14:22:31.108Z |
5434853 | 5434853 | 20241030102013_PO3ZK | NZ0042 | 2024-11-01T12:03:37.493Z | 2024-11-03T14:22:26.909Z |
5434525 | 5434525 | 20241030093757_AMY8Q | NZ0042 | 2024-11-01T12:02:35.601Z | 2024-11-03T14:22:23.309Z |
5434196 | 5434196 | 20241030083704_tT3uT | NZ0042 | 2024-11-01T12:01:29.872Z | 2024-11-03T14:22:18.010Z |
5433954 | 5433954 | 20241030074931_jBBgb | NZ0042 | 2024-11-01T12:00:38.937Z | 2024-11-03T14:22:14.667Z |
5428063 | 5428063 | 20241028161644_s3fWK | NZ0042 | 2024-10-31T12:14:31.338Z | 2024-11-03T14:24:49.559Z |
5427796 | 5427796 | 20241028154551_9y6lR | NZ0042 | 2024-10-31T12:13:59.157Z | 2024-11-03T14:24:48.833Z |
5427789 | 5427789 | 20241028154535_dp1d7 | NZ0042 | 2024-10-31T12:13:58.819Z | 2024-11-03T14:24:48.703Z |
5427761 | 5427761 | 20241028154158_2oHAn | NZ0042 | 2024-10-31T12:13:55.869Z | 2024-11-03T14:24:48.550Z |
5427715 | 5427715 | 20241028153634_nrJwQ | NZ0042 | 2024-10-31T12:13:52.351Z | 2024-11-03T14:24:48.476Z |
5427644 | 5427644 | 20241028152558_FfrWW | NZ0042 | 2024-10-31T12:13:42.479Z | 2024-11-03T14:24:48.150Z |
5427543 | 5427543 | 20241028151456_1rEcy | NZ0042 | 2024-10-31T12:13:37.159Z | 2024-11-03T14:24:47.993Z |
5427527 | 5427527 | 20241028151343_8f1np | NZ0042 | 2024-10-31T12:13:36.070Z | 2024-11-03T14:24:47.985Z |
5427425 | 5427425 | 20241028150511_4R71o | NZ0042 | 2024-10-31T12:13:31.710Z | 2024-11-03T14:24:47.679Z |
5427265 | 5427265 | 20241028145227_AGdaf | NZ0042 | 2024-10-31T12:13:23.246Z | 2024-11-03T14:24:46.416Z |
5427237 | 5427237 | 20241028144823_TzQP5 | NZ0042 | 2024-10-31T12:13:21.810Z | 2024-11-03T14:24:46.392Z |
5427114 | 5427114 | 20241028143156_U06oP | NZ0042 | 2024-10-31T12:13:09.987Z | 2024-11-03T14:24:45.830Z |
5427095 | 5427095 | 20241028143019_ICCDr | NZ0042 | 2024-10-31T12:13:07.363Z | 2024-11-03T14:24:45.816Z |
5427033 | 5427033 | 20241028142342_oaAzD | NZ0042 | 2024-10-31T12:12:55.875Z | 2024-11-03T14:24:45.687Z |
5427030 | 5427030 | 20241028142339_kQRvx | NZ0042 | 2024-10-31T12:12:55.422Z | 2024-11-03T14:24:45.686Z |
5427013 | 5427013 | 20241028142308_MIdAI | NZ0042 | 2024-10-31T12:12:52.357Z | 2024-11-03T14:24:45.661Z |
5426921 | 5426921 | 20241028141036_mQe24 | NZ0042 | 2024-10-31T12:12:38.573Z | 2024-11-03T14:24:45.449Z |
5425218 | 5425218 | 20241029161051_s4JsG | NZ0042 | 2024-10-31T12:07:17.220Z | 2024-11-03T14:23:41.439Z |
5425217 | 5425217 | 20241029161038_uOk2s | NZ0042 | 2024-10-31T12:07:16.968Z | 2024-11-03T14:23:41.409Z |
5425131 | 5425131 | 20241029155736_oHn3O | NZ0042 | 2024-10-31T12:06:54.937Z | 2024-11-03T14:23:40.929Z |
5424905 | 5424905 | 20241029153108_1Emko | NZ0042 | 2024-10-31T12:06:28.466Z | 2024-11-03T14:23:39.742Z |
5424528 | 5424528 | 20241029144025_s3GsM | NZ0042 | 2024-10-31T12:05:18.615Z | 2024-11-03T14:23:37.999Z |
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);