participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,864 rows where station_code = "NZ0044" 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 |
---|---|---|---|---|---|
5569181 | 5569181 | 20241121144837_3n6bj | NZ0044 | 2024-11-22T14:10:27.394Z | 2024-11-22T14:10:27.394Z |
5569151 | 5569151 | 20241121144140_hehJx | NZ0044 | 2024-11-22T14:10:24.422Z | 2024-11-22T14:10:24.422Z |
5569095 | 5569095 | 20241121143252_Ijx12 | NZ0044 | 2024-11-22T14:10:20.378Z | 2024-11-22T14:10:20.378Z |
5569051 | 5569051 | 20241121142442_aG4ax | NZ0044 | 2024-11-22T14:10:14.909Z | 2024-11-22T14:10:14.909Z |
5569047 | 5569047 | 20241121142441_5SVFq | NZ0044 | 2024-11-22T14:10:14.643Z | 2024-11-22T14:10:14.643Z |
5568648 | 5568648 | 20241121131739_wFohc | NZ0044 | 2024-11-22T14:09:30.144Z | 2024-11-22T14:09:30.144Z |
5568590 | 5568590 | 20241121130944_DxiA5 | NZ0044 | 2024-11-22T14:09:24.189Z | 2024-11-22T14:09:24.189Z |
5568547 | 5568547 | 20241121125808_cHhRa | NZ0044 | 2024-11-22T14:09:19.141Z | 2024-11-22T14:09:19.141Z |
5568528 | 5568528 | 20241121125504_bDa73 | NZ0044 | 2024-11-22T14:09:16.372Z | 2024-11-22T14:09:16.372Z |
5568509 | 5568509 | 20241121125416_EHS3w | NZ0044 | 2024-11-22T14:09:09.123Z | 2024-11-22T14:09:09.123Z |
5568455 | 5568455 | 20241121124925_IrOl0 | NZ0044 | 2024-11-22T14:08:59.276Z | 2024-11-22T14:08:59.276Z |
5568318 | 5568318 | 20241121122334_LMI62 | NZ0044 | 2024-11-22T14:08:42.258Z | 2024-11-22T14:08:42.258Z |
5568199 | 5568199 | 20241121120438_QWylZ | NZ0044 | 2024-11-22T14:08:24.298Z | 2024-11-22T14:08:24.298Z |
5567978 | 5567978 | 20241121113718_2D53Y | NZ0044 | 2024-11-22T14:07:53.075Z | 2024-11-22T14:07:53.075Z |
5567926 | 5567926 | 20241121113152_TzOHW | NZ0044 | 2024-11-22T14:07:44.368Z | 2024-11-22T14:07:44.368Z |
5567900 | 5567900 | 20241121112700_3VtzZ | NZ0044 | 2024-11-22T14:07:32.122Z | 2024-11-22T14:07:32.122Z |
5567822 | 5567822 | 20241121111549_eZxzN | NZ0044 | 2024-11-22T14:07:19.915Z | 2024-11-22T14:07:19.915Z |
5567493 | 5567493 | 20241121102838_SXGDI | NZ0044 | 2024-11-22T14:06:24.118Z | 2024-11-22T14:06:24.118Z |
5567295 | 5567295 | 20241121095944_7b2q2 | NZ0044 | 2024-11-22T14:05:47.843Z | 2024-11-22T14:05:47.843Z |
5559531 | 5559531 | 20241120103910_5LVu4 | NZ0044 | 2024-11-21T14:06:32.334Z | 2024-11-22T14:19:21.466Z |
5559321 | 5559321 | 20241120100306_90CW1 | NZ0044 | 2024-11-21T14:05:57.868Z | 2024-11-22T14:19:21.416Z |
5555669 | 5555669 | 20241119143229_Tk2T5 | NZ0044 | 2024-11-20T14:06:22.563Z | 2024-11-22T14:20:12.168Z |
5555634 | 5555634 | 20241119141214_FU07w | NZ0044 | 2024-11-20T14:06:11.767Z | 2024-11-22T14:20:11.495Z |
5555584 | 5555584 | 20241119135705_f4TGT | NZ0044 | 2024-11-20T14:06:02.834Z | 2024-11-22T14:20:10.457Z |
5555494 | 5555494 | 20241119133302_B6t3m | NZ0044 | 2024-11-20T14:05:51.573Z | 2024-11-22T14:20:07.510Z |
5555477 | 5555477 | 20241119132536_vXEXX | NZ0044 | 2024-11-20T14:05:43.797Z | 2024-11-22T14:20:07.108Z |
5555442 | 5555442 | 20241119131504_yews8 | NZ0044 | 2024-11-20T14:05:38.445Z | 2024-11-22T14:20:06.510Z |
5555429 | 5555429 | 20241119131057_Zr2Gp | NZ0044 | 2024-11-20T14:05:36.361Z | 2024-11-22T14:20:05.945Z |
5555401 | 5555401 | 20241119130339_3J2nY | NZ0044 | 2024-11-20T14:05:29.928Z | 2024-11-22T14:20:05.372Z |
5555384 | 5555384 | 20241119130124_NBcrF | NZ0044 | 2024-11-20T14:05:24.127Z | 2024-11-22T14:20:05.019Z |
5555342 | 5555342 | 20241119125044_6EPs2 | NZ0044 | 2024-11-20T14:05:14.841Z | 2024-11-22T14:20:04.475Z |
5555297 | 5555297 | 20241119123620_qEZPI | NZ0044 | 2024-11-20T14:05:07.183Z | 2024-11-22T14:20:03.339Z |
5555248 | 5555248 | 20241119122436_FscKK | NZ0044 | 2024-11-20T14:05:00.819Z | 2024-11-22T14:20:02.348Z |
5555171 | 5555171 | 20241119120058_a2Gry | NZ0044 | 2024-11-20T14:04:38.515Z | 2024-11-22T14:20:00.550Z |
5555064 | 5555064 | 20241119113201_lXlFQ | NZ0044 | 2024-11-20T14:04:22.278Z | 2024-11-22T14:19:56.688Z |
5550585 | 5550585 | 20241118105157_sdOQe | NZ0044 | 2024-11-19T14:02:41.548Z | 2024-11-22T14:22:04.120Z |
5550568 | 5550568 | 20241118104855_mx3fG | NZ0044 | 2024-11-19T14:02:37.224Z | 2024-11-22T14:22:03.996Z |
5550396 | 5550396 | 20241118101639_JOO12 | NZ0044 | 2024-11-19T14:02:17.057Z | 2024-11-22T14:22:02.669Z |
5550390 | 5550390 | 20241118101300_uIM3n | NZ0044 | 2024-11-19T14:02:16.501Z | 2024-11-22T14:22:02.644Z |
5546530 | 5546530 | 20241117112539_bVVDc | NZ0044 | 2024-11-18T14:03:21.208Z | 2024-11-22T14:22:32.432Z |
5546490 | 5546490 | 20241117111144_xdEo9 | NZ0044 | 2024-11-18T14:03:13.001Z | 2024-11-22T14:22:32.264Z |
5546438 | 5546438 | 20241117105714_CpUya | NZ0044 | 2024-11-18T14:03:06.627Z | 2024-11-22T14:22:32.006Z |
5546354 | 5546354 | 20241117103120_v2mKm | NZ0044 | 2024-11-18T14:02:54.888Z | 2024-11-22T14:22:31.320Z |
5546109 | 5546109 | 20241117091513_m03sv | NZ0044 | 2024-11-18T14:02:05.767Z | 2024-11-22T14:22:29.105Z |
5520031 | 5520031 | 20241111142538_8uto2 | NZ0044 | 2024-11-12T14:05:29.630Z | 2024-11-20T14:25:02.545Z |
5520015 | 5520015 | 20241111141840_jCSwW | NZ0044 | 2024-11-12T14:05:27.975Z | 2024-11-20T14:25:01.935Z |
5519985 | 5519985 | 20241111141035_l8HiS | NZ0044 | 2024-11-12T14:05:25.019Z | 2024-11-20T14:25:01.373Z |
5519940 | 5519940 | 20241111140013_yG2TE | NZ0044 | 2024-11-12T14:05:21.232Z | 2024-11-20T14:25:00.933Z |
5519876 | 5519876 | 20241111134402_h2Y5U | NZ0044 | 2024-11-12T14:05:14.939Z | 2024-11-20T14:25:00.385Z |
5519780 | 5519780 | 20241111125923_o6E2S | NZ0044 | 2024-11-12T14:04:58.574Z | 2024-11-20T14:24:57.810Z |
5519760 | 5519760 | 20241111125629_BO2wu | NZ0044 | 2024-11-12T14:04:56.293Z | 2024-11-20T14:24:57.379Z |
5519607 | 5519607 | 20241111121433_EZpR8 | NZ0044 | 2024-11-12T14:04:35.912Z | 2024-11-20T14:24:53.526Z |
5514018 | 5514018 | 20241110134020_QMSVh | NZ0044 | 2024-11-11T14:05:48.135Z | 2024-11-19T14:21:41.784Z |
5514007 | 5514007 | 20241110133300_PD3ck | NZ0044 | 2024-11-11T14:05:47.327Z | 2024-11-19T14:21:41.682Z |
5513993 | 5513993 | 20241110132313_GxFJ6 | NZ0044 | 2024-11-11T14:05:46.285Z | 2024-11-19T14:21:41.331Z |
5513985 | 5513985 | 20241110131528_JSxCa | NZ0044 | 2024-11-11T14:05:45.486Z | 2024-11-19T14:21:41.212Z |
5513978 | 5513978 | 20241110131317_C5QEG | NZ0044 | 2024-11-11T14:05:44.902Z | 2024-11-19T14:21:41.124Z |
5513973 | 5513973 | 20241110131306_kzXl2 | NZ0044 | 2024-11-11T14:05:44.656Z | 2024-11-19T14:21:41.105Z |
5513671 | 5513671 | 20241110120223_dBNvL | NZ0044 | 2024-11-11T14:05:09.147Z | 2024-11-19T14:21:36.749Z |
5513283 | 5513283 | 20241110111046_Uk3NQ | NZ0044 | 2024-11-11T14:04:21.397Z | 2024-11-19T14:21:32.725Z |
5511528 | 5511528 | 20241105135804_i0LGp | NZ0044 | 2024-11-10T14:22:46.805Z | 2024-11-14T14:23:04.899Z |
5498717 | 5498717 | 20241108094133_cCNyx | NZ0044 | 2024-11-09T14:02:15.474Z | 2024-11-17T14:22:59.327Z |
5487048 | 5487048 | 20241106143409_IMwep | NZ0044 | 2024-11-07T14:04:52.107Z | 2024-11-15T14:24:36.922Z |
5486995 | 5486995 | 20241106141708_O1Qa4 | NZ0044 | 2024-11-07T14:04:34.310Z | 2024-11-15T14:24:36.475Z |
5486961 | 5486961 | 20241106141107_pbH4e | NZ0044 | 2024-11-07T14:04:30.350Z | 2024-11-15T14:24:36.103Z |
5486938 | 5486938 | 20241106140632_Qqc6H | NZ0044 | 2024-11-07T14:04:25.445Z | 2024-11-15T14:24:35.938Z |
5486900 | 5486900 | 20241106135355_g3Ff3 | NZ0044 | 2024-11-07T14:04:21.228Z | 2024-11-15T14:24:35.752Z |
5486893 | 5486893 | 20241106135308_2Ihs6 | NZ0044 | 2024-11-07T14:04:20.851Z | 2024-11-15T14:24:35.731Z |
5486846 | 5486846 | 20241106134042_uJ4Fu | NZ0044 | 2024-11-07T14:04:15.051Z | 2024-11-15T14:24:35.219Z |
5486753 | 5486753 | 20241106131410_PAeGb | NZ0044 | 2024-11-07T14:03:56.605Z | 2024-11-15T14:24:34.105Z |
5486681 | 5486681 | 20241106125217_wVNoR | NZ0044 | 2024-11-07T14:03:44.822Z | 2024-11-15T14:24:33.019Z |
5486673 | 5486673 | 20241106124900_4R5a1 | NZ0044 | 2024-11-07T14:03:44.302Z | 2024-11-15T14:24:32.980Z |
5486653 | 5486653 | 20241106124259_urOlH | NZ0044 | 2024-11-07T14:03:41.339Z | 2024-11-15T14:24:32.915Z |
5486639 | 5486639 | 20241106124158_NlRau | NZ0044 | 2024-11-07T14:03:40.268Z | 2024-11-15T14:24:32.743Z |
5486572 | 5486572 | 20241106122008_6gNcb | NZ0044 | 2024-11-07T14:03:25.444Z | 2024-11-15T14:24:31.811Z |
5486539 | 5486539 | 20241106120215_wbyig | NZ0044 | 2024-11-07T14:03:19.443Z | 2024-11-15T14:24:31.150Z |
5486459 | 5486459 | 20241106114347_Qr6WB | NZ0044 | 2024-11-07T14:03:01.831Z | 2024-11-15T14:24:30.239Z |
5486373 | 5486373 | 20241106111224_yOhXT | NZ0044 | 2024-11-07T14:02:44.867Z | 2024-11-15T14:24:29.676Z |
5486277 | 5486277 | 20241106102340_rGwSI | NZ0044 | 2024-11-07T14:02:24.353Z | 2024-11-15T14:24:28.128Z |
5486095 | 5486095 | 20241106093144_hibGX | NZ0044 | 2024-11-07T14:01:47.564Z | 2024-11-15T14:24:26.267Z |
5486025 | 5486025 | 20241106091333_vVB67 | NZ0044 | 2024-11-07T14:01:34.773Z | 2024-11-15T14:24:25.308Z |
5480572 | 5480572 | 20241105140033_SDInO | NZ0044 | 2024-11-06T14:05:57.097Z | 2024-11-14T14:23:04.923Z |
5465136 | 5465136 | 20241103104539_mjiGY | NZ0044 | 2024-11-04T14:02:54.935Z | 2024-11-12T14:27:44.768Z |
5464637 | 5464637 | 20241103083948_2sCdH | NZ0044 | 2024-11-04T14:01:11.130Z | 2024-11-12T14:27:42.712Z |
5457445 | 5457445 | 20241102143053_KljEW | NZ0044 | 2024-11-03T14:07:19.955Z | 2024-11-11T14:22:34.833Z |
5457308 | 5457308 | 20241102140749_upzBF | NZ0044 | 2024-11-03T14:07:05.629Z | 2024-11-11T14:22:34.109Z |
5457142 | 5457142 | 20241102133705_pgj14 | NZ0044 | 2024-11-03T14:06:38.303Z | 2024-11-11T14:22:33.149Z |
5457106 | 5457106 | 20241102133201_N9Afq | NZ0044 | 2024-11-03T14:06:34.596Z | 2024-11-11T14:22:32.950Z |
5457046 | 5457046 | 20241102132129_hW9gA | NZ0044 | 2024-11-03T14:06:26.669Z | 2024-11-11T14:22:32.557Z |
5456966 | 5456966 | 20241102130246_U7qz2 | NZ0044 | 2024-11-03T14:06:12.459Z | 2024-11-11T14:22:32.250Z |
5456953 | 5456953 | 20241102125946_00MhU | NZ0044 | 2024-11-03T14:06:08.670Z | 2024-11-11T14:22:32.211Z |
5456943 | 5456943 | 20241102125650_vjDjV | NZ0044 | 2024-11-03T14:06:06.944Z | 2024-11-11T14:22:32.170Z |
5456870 | 5456870 | 20241102124251_uKvOJ | NZ0044 | 2024-11-03T14:05:51.699Z | 2024-11-11T14:22:31.867Z |
5456854 | 5456854 | 20241102124012_Jim5W | NZ0044 | 2024-11-03T14:05:49.785Z | 2024-11-11T14:22:31.837Z |
5456818 | 5456818 | 20241102123142_E3OAP | NZ0044 | 2024-11-03T14:05:44.945Z | 2024-11-11T14:22:31.685Z |
5456749 | 5456749 | 20241102121420_zldT2 | NZ0044 | 2024-11-03T14:05:37.111Z | 2024-11-11T14:22:31.041Z |
5456717 | 5456717 | 20241102120827_Rr9OP | NZ0044 | 2024-11-03T14:05:32.847Z | 2024-11-11T14:22:30.886Z |
5456662 | 5456662 | 20241102115955_XzkfH | NZ0044 | 2024-11-03T14:05:15.878Z | 2024-11-11T14:22:30.326Z |
5456535 | 5456535 | 20241102113951_2CLCV | NZ0044 | 2024-11-03T14:04:56.384Z | 2024-11-11T14:22:29.577Z |
5456366 | 5456366 | 20241102110446_UmZxO | NZ0044 | 2024-11-03T14:04:18.683Z | 2024-11-11T14:22:28.460Z |
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);