participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
3,803 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 |
---|---|---|---|---|---|
5498717 | 5498717 | 20241108094133_cCNyx | NZ0044 | 2024-11-09T14:02:15.474Z | 2024-11-09T14:02:15.474Z |
5487048 | 5487048 | 20241106143409_IMwep | NZ0044 | 2024-11-07T14:04:52.107Z | 2024-11-09T14:17:06.289Z |
5486995 | 5486995 | 20241106141708_O1Qa4 | NZ0044 | 2024-11-07T14:04:34.310Z | 2024-11-09T14:17:04.228Z |
5486961 | 5486961 | 20241106141107_pbH4e | NZ0044 | 2024-11-07T14:04:30.350Z | 2024-11-09T14:17:03.070Z |
5486938 | 5486938 | 20241106140632_Qqc6H | NZ0044 | 2024-11-07T14:04:25.445Z | 2024-11-09T14:17:02.516Z |
5486900 | 5486900 | 20241106135355_g3Ff3 | NZ0044 | 2024-11-07T14:04:21.228Z | 2024-11-09T14:17:01.100Z |
5486893 | 5486893 | 20241106135308_2Ihs6 | NZ0044 | 2024-11-07T14:04:20.851Z | 2024-11-09T14:17:01.016Z |
5486846 | 5486846 | 20241106134042_uJ4Fu | NZ0044 | 2024-11-07T14:04:15.051Z | 2024-11-09T14:16:59.918Z |
5486753 | 5486753 | 20241106131410_PAeGb | NZ0044 | 2024-11-07T14:03:56.605Z | 2024-11-09T14:16:56.557Z |
5486681 | 5486681 | 20241106125217_wVNoR | NZ0044 | 2024-11-07T14:03:44.822Z | 2024-11-09T14:16:53.993Z |
5486673 | 5486673 | 20241106124900_4R5a1 | NZ0044 | 2024-11-07T14:03:44.302Z | 2024-11-09T14:16:53.703Z |
5486653 | 5486653 | 20241106124259_urOlH | NZ0044 | 2024-11-07T14:03:41.339Z | 2024-11-09T14:16:53.339Z |
5486639 | 5486639 | 20241106124158_NlRau | NZ0044 | 2024-11-07T14:03:40.268Z | 2024-11-09T14:16:53.118Z |
5486572 | 5486572 | 20241106122008_6gNcb | NZ0044 | 2024-11-07T14:03:25.444Z | 2024-11-09T14:16:51.943Z |
5486539 | 5486539 | 20241106120215_wbyig | NZ0044 | 2024-11-07T14:03:19.443Z | 2024-11-09T14:16:50.753Z |
5486459 | 5486459 | 20241106114347_Qr6WB | NZ0044 | 2024-11-07T14:03:01.831Z | 2024-11-09T14:16:46.856Z |
5486373 | 5486373 | 20241106111224_yOhXT | NZ0044 | 2024-11-07T14:02:44.867Z | 2024-11-09T14:16:43.921Z |
5486277 | 5486277 | 20241106102340_rGwSI | NZ0044 | 2024-11-07T14:02:24.353Z | 2024-11-09T14:16:40.628Z |
5486095 | 5486095 | 20241106093144_hibGX | NZ0044 | 2024-11-07T14:01:47.564Z | 2024-11-09T14:16:37.751Z |
5486025 | 5486025 | 20241106091333_vVB67 | NZ0044 | 2024-11-07T14:01:34.773Z | 2024-11-09T14:16:36.247Z |
5480572 | 5480572 | 20241105140033_SDInO | NZ0044 | 2024-11-06T14:05:57.097Z | 2024-11-09T14:19:25.951Z |
5465136 | 5465136 | 20241103104539_mjiGY | NZ0044 | 2024-11-04T14:02:54.935Z | 2024-11-09T14:21:31.021Z |
5464637 | 5464637 | 20241103083948_2sCdH | NZ0044 | 2024-11-04T14:01:11.130Z | 2024-11-09T14:21:27.371Z |
5457445 | 5457445 | 20241102143053_KljEW | NZ0044 | 2024-11-03T14:07:19.955Z | 2024-11-09T14:22:47.815Z |
5457308 | 5457308 | 20241102140749_upzBF | NZ0044 | 2024-11-03T14:07:05.629Z | 2024-11-09T14:22:47.383Z |
5457142 | 5457142 | 20241102133705_pgj14 | NZ0044 | 2024-11-03T14:06:38.303Z | 2024-11-09T14:22:46.829Z |
5457106 | 5457106 | 20241102133201_N9Afq | NZ0044 | 2024-11-03T14:06:34.596Z | 2024-11-09T14:22:46.728Z |
5457046 | 5457046 | 20241102132129_hW9gA | NZ0044 | 2024-11-03T14:06:26.669Z | 2024-11-09T14:22:46.475Z |
5456966 | 5456966 | 20241102130246_U7qz2 | NZ0044 | 2024-11-03T14:06:12.459Z | 2024-11-09T14:22:46.312Z |
5456953 | 5456953 | 20241102125946_00MhU | NZ0044 | 2024-11-03T14:06:08.670Z | 2024-11-09T14:22:46.297Z |
5456943 | 5456943 | 20241102125650_vjDjV | NZ0044 | 2024-11-03T14:06:06.944Z | 2024-11-09T14:22:46.217Z |
5456870 | 5456870 | 20241102124251_uKvOJ | NZ0044 | 2024-11-03T14:05:51.699Z | 2024-11-09T14:22:45.904Z |
5456854 | 5456854 | 20241102124012_Jim5W | NZ0044 | 2024-11-03T14:05:49.785Z | 2024-11-09T14:22:45.872Z |
5456818 | 5456818 | 20241102123142_E3OAP | NZ0044 | 2024-11-03T14:05:44.945Z | 2024-11-09T14:22:45.759Z |
5456749 | 5456749 | 20241102121420_zldT2 | NZ0044 | 2024-11-03T14:05:37.111Z | 2024-11-09T14:22:45.363Z |
5456717 | 5456717 | 20241102120827_Rr9OP | NZ0044 | 2024-11-03T14:05:32.847Z | 2024-11-09T14:22:45.254Z |
5456662 | 5456662 | 20241102115955_XzkfH | NZ0044 | 2024-11-03T14:05:15.878Z | 2024-11-09T14:22:44.901Z |
5456535 | 5456535 | 20241102113951_2CLCV | NZ0044 | 2024-11-03T14:04:56.384Z | 2024-11-09T14:22:44.351Z |
5456366 | 5456366 | 20241102110446_UmZxO | NZ0044 | 2024-11-03T14:04:18.683Z | 2024-11-09T14:22:43.198Z |
5456249 | 5456249 | 20241102104844_mnlUL | NZ0044 | 2024-11-03T14:03:54.195Z | 2024-11-09T14:22:42.563Z |
5456135 | 5456135 | 20241102102812_hofcZ | NZ0044 | 2024-11-03T14:03:27.287Z | 2024-11-09T14:22:42.095Z |
5455868 | 5455868 | 20241102093537_tCvPL | NZ0044 | 2024-11-03T14:02:31.433Z | 2024-11-09T14:22:40.376Z |
5455629 | 5455629 | 20241102084559_BK5yJ | NZ0044 | 2024-11-03T14:01:44.114Z | 2024-11-09T14:22:37.516Z |
5448957 | 5448957 | 20241031143622_Ovmz0 | NZ0044 | 2024-11-02T12:11:52.528Z | 2024-11-09T14:24:08.514Z |
5448858 | 5448858 | 20241031142436_z52PU | NZ0044 | 2024-11-02T12:11:34.954Z | 2024-11-09T14:24:07.999Z |
5448695 | 5448695 | 20241031140720_4FV03 | NZ0044 | 2024-11-02T12:11:19.953Z | 2024-11-09T14:24:07.022Z |
5448692 | 5448692 | 20241031140641_j5AlR | NZ0044 | 2024-11-02T12:11:19.704Z | 2024-11-09T14:24:07.020Z |
5448611 | 5448611 | 20241031135411_MCJdr | NZ0044 | 2024-11-02T12:11:10.883Z | 2024-11-09T14:24:06.655Z |
5446499 | 5446499 | 20241031100521_aDFrB | NZ0044 | 2024-11-02T12:05:28.992Z | 2024-11-09T14:23:54.961Z |
5446447 | 5446447 | 20241031095948_DRc6c | NZ0044 | 2024-11-02T12:05:20.132Z | 2024-11-09T14:23:54.638Z |
5446163 | 5446163 | 20241031093250_3VaHa | NZ0044 | 2024-11-02T12:04:24.897Z | 2024-11-09T14:23:53.202Z |
5437140 | 5437140 | 20241030143200_5It3R | NZ0044 | 2024-11-01T12:09:08.443Z | 2024-11-08T14:22:56.700Z |
5437122 | 5437122 | 20241030143018_6hVRb | NZ0044 | 2024-11-01T12:08:58.997Z | 2024-11-08T14:22:56.668Z |
5437065 | 5437065 | 20241030142429_D8gEw | NZ0044 | 2024-11-01T12:08:49.207Z | 2024-11-08T14:22:56.608Z |
5436491 | 5436491 | 20241030131248_pDQPs | NZ0044 | 2024-11-01T12:07:45.701Z | 2024-11-08T14:22:54.137Z |
5427124 | 5427124 | 20241028143203_JRYu6 | NZ0044 | 2024-10-31T12:13:10.449Z | 2024-11-06T14:27:11.394Z |
5427062 | 5427062 | 20241028142717_HQ134 | NZ0044 | 2024-10-31T12:13:02.469Z | 2024-11-06T14:27:11.345Z |
5427021 | 5427021 | 20241028142318_ee3fX | NZ0044 | 2024-10-31T12:12:53.366Z | 2024-11-06T14:27:11.289Z |
5426949 | 5426949 | 20241028141438_shewT | NZ0044 | 2024-10-31T12:12:42.310Z | 2024-11-06T14:27:10.977Z |
5426891 | 5426891 | 20241028140735_xX8SK | NZ0044 | 2024-10-31T12:12:35.919Z | 2024-11-06T14:27:10.721Z |
5426819 | 5426819 | 20241028140110_oJfVp | NZ0044 | 2024-10-31T12:12:30.113Z | 2024-11-06T14:27:10.662Z |
5426813 | 5426813 | 20241028140020_2kegb | NZ0044 | 2024-10-31T12:12:29.860Z | 2024-11-06T14:27:10.659Z |
5426785 | 5426785 | 20241028135630_qoGlE | NZ0044 | 2024-10-31T12:12:28.142Z | 2024-11-06T14:27:10.620Z |
5426779 | 5426779 | 20241028135611_Th7UM | NZ0044 | 2024-10-31T12:12:27.943Z | 2024-11-06T14:27:10.617Z |
5426757 | 5426757 | 20241028135353_mFRiT | NZ0044 | 2024-10-31T12:12:26.980Z | 2024-11-06T14:27:10.608Z |
5426741 | 5426741 | 20241028135201_2O6ge | NZ0044 | 2024-10-31T12:12:25.639Z | 2024-11-06T14:27:10.592Z |
5426729 | 5426729 | 20241028134926_l2YKy | NZ0044 | 2024-10-31T12:12:24.491Z | 2024-11-06T14:27:10.573Z |
5426667 | 5426667 | 20241028134030_GFo2b | NZ0044 | 2024-10-31T12:12:20.146Z | 2024-11-06T14:27:10.508Z |
5426635 | 5426635 | 20241028133729_M0AXF | NZ0044 | 2024-10-31T12:12:17.936Z | 2024-11-06T14:27:10.484Z |
5426586 | 5426586 | 20241028133002_8WlYF | NZ0044 | 2024-10-31T12:12:14.823Z | 2024-11-06T14:27:10.415Z |
5422593 | 5422593 | 20241028132022_rHDQP | NZ0044 | 2024-10-30T12:20:28.314Z | 2024-11-06T14:27:10.339Z |
5422519 | 5422519 | 20241028130943_DZdx2 | NZ0044 | 2024-10-30T12:20:27.400Z | 2024-11-06T14:27:10.273Z |
5422489 | 5422489 | 20241028130757_jldP7 | NZ0044 | 2024-10-30T12:20:27.158Z | 2024-11-06T14:27:10.237Z |
5422445 | 5422445 | 20241028130405_CRr94 | NZ0044 | 2024-10-30T12:20:26.782Z | 2024-11-06T14:27:10.178Z |
5422403 | 5422403 | 20241028125940_1PoFK | NZ0044 | 2024-10-30T12:20:26.367Z | 2024-11-06T14:27:10.136Z |
5422378 | 5422378 | 20241028125629_njDsQ | NZ0044 | 2024-10-30T12:20:26.046Z | 2024-11-06T14:27:10.123Z |
5422365 | 5422365 | 20241028125556_uggNN | NZ0044 | 2024-10-30T12:20:25.940Z | 2024-11-06T14:27:10.120Z |
5422348 | 5422348 | 20241028125210_q222Z | NZ0044 | 2024-10-30T12:20:25.692Z | 2024-11-06T14:27:10.065Z |
5422302 | 5422302 | 20241028124526_O5WzY | NZ0044 | 2024-10-30T12:20:25.223Z | 2024-11-06T14:27:09.944Z |
5422191 | 5422191 | 20241028122707_Mx3rj | NZ0044 | 2024-10-30T12:20:23.603Z | 2024-11-06T14:27:09.540Z |
5415706 | 5415706 | 20241027142703_Xl92c | NZ0044 | 2024-10-30T12:10:23.312Z | 2024-11-05T14:27:03.910Z |
5415614 | 5415614 | 20241027141504_nGvrB | NZ0044 | 2024-10-30T12:10:04.922Z | 2024-11-05T14:27:03.779Z |
5415455 | 5415455 | 20241027135651_bn22g | NZ0044 | 2024-10-30T12:09:46.022Z | 2024-11-05T14:27:03.670Z |
5415426 | 5415426 | 20241027135154_wixQn | NZ0044 | 2024-10-30T12:09:43.031Z | 2024-11-05T14:27:03.619Z |
5415422 | 5415422 | 20241027135059_Zt0hT | NZ0044 | 2024-10-30T12:09:42.504Z | 2024-11-05T14:27:03.617Z |
5413657 | 5413657 | 20241028103603_YyFPu | NZ0044 | 2024-10-30T12:03:51.968Z | 2024-11-06T14:27:07.302Z |
5413627 | 5413627 | 20241028103351_FLP0K | NZ0044 | 2024-10-30T12:03:41.675Z | 2024-11-06T14:27:07.239Z |
5413583 | 5413583 | 20241028102414_GVgU2 | NZ0044 | 2024-10-30T12:03:32.910Z | 2024-11-06T14:27:06.671Z |
5413466 | 5413466 | 20241028100405_BrJbO | NZ0044 | 2024-10-30T12:03:12.291Z | 2024-11-06T14:27:06.067Z |
5371601 | 5371601 | 20241024150601_dJPl9 | NZ0044 | 2024-10-26T12:12:13.591Z | 2024-11-02T12:28:22.412Z |
5371592 | 5371592 | 20241024150525_bo9d2 | NZ0044 | 2024-10-26T12:12:12.983Z | 2024-11-02T12:28:22.408Z |
5371572 | 5371572 | 20241024150420_Aagze | NZ0044 | 2024-10-26T12:12:11.925Z | 2024-11-02T12:28:22.392Z |
5371515 | 5371515 | 20241024145836_RXMbx | NZ0044 | 2024-10-26T12:12:04.914Z | 2024-11-02T12:28:22.339Z |
5371407 | 5371407 | 20241024145131_df6h8 | NZ0044 | 2024-10-26T12:11:55.828Z | 2024-11-02T12:28:22.166Z |
5371315 | 5371315 | 20241024144211_9PoK1 | NZ0044 | 2024-10-26T12:11:35.820Z | 2024-11-02T12:28:21.944Z |
5371210 | 5371210 | 20241024143114_ySt9j | NZ0044 | 2024-10-26T12:11:21.935Z | 2024-11-02T12:28:21.864Z |
5371196 | 5371196 | 20241024143036_gjdLf | NZ0044 | 2024-10-26T12:11:20.743Z | 2024-11-02T12:28:21.860Z |
5371173 | 5371173 | 20241024142829_nYpcW | NZ0044 | 2024-10-26T12:11:18.496Z | 2024-11-02T12:28:21.845Z |
5371093 | 5371093 | 20241024142357_zCf9u | NZ0044 | 2024-10-26T12:11:10.427Z | 2024-11-02T12:28:21.802Z |
5370907 | 5370907 | 20241024140441_WMCqo | NZ0044 | 2024-10-26T12:10:38.360Z | 2024-11-02T12:28:21.573Z |
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);