participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
6,411 rows where station_code = "NZ0023" 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 |
---|---|---|---|---|---|
5600013 | 5600013 | 20241121153650_W6dhy | NZ0023 | 2024-11-25T14:20:06.358Z | 2024-11-26T14:24:34.692Z |
5600008 | 5600008 | 20241121150101_j24gq | NZ0023 | 2024-11-25T14:20:05.647Z | 2024-11-26T14:24:33.483Z |
5600004 | 5600004 | 20241121132220_LH3td | NZ0023 | 2024-11-25T14:20:03.385Z | 2024-11-26T14:24:30.722Z |
5597533 | 5597533 | 20241124153522_3cP8R | NZ0023 | 2024-11-25T14:11:35.710Z | 2024-11-26T14:18:44.615Z |
5597495 | 5597495 | 20241124153112_WX5h3 | NZ0023 | 2024-11-25T14:11:33.788Z | 2024-11-26T14:18:44.610Z |
5597028 | 5597028 | 20241124145656_zjV1W | NZ0023 | 2024-11-25T14:10:59.489Z | 2024-11-26T14:18:44.537Z |
5596820 | 5596820 | 20241124143045_7h1Rj | NZ0023 | 2024-11-25T14:10:37.511Z | 2024-11-26T14:18:44.485Z |
5595385 | 5595385 | 20241124121304_jIWFO | NZ0023 | 2024-11-25T14:08:06.330Z | 2024-11-26T14:18:44.261Z |
5595294 | 5595294 | 20241124120314_Uykib | NZ0023 | 2024-11-25T14:07:54.943Z | 2024-11-26T14:18:44.244Z |
5594024 | 5594024 | 20241124092926_Ete3C | NZ0023 | 2024-11-25T14:04:31.212Z | 2024-11-26T14:18:44.002Z |
5593913 | 5593913 | 20241124091242_KXw2p | NZ0023 | 2024-11-25T14:04:09.518Z | 2024-11-26T14:18:43.977Z |
5593889 | 5593889 | 20241124090803_O3EFq | NZ0023 | 2024-11-25T14:04:01.371Z | 2024-11-26T14:18:43.970Z |
5593882 | 5593882 | 20241124090525_al8pt | NZ0023 | 2024-11-25T14:04:00.124Z | 2024-11-26T14:18:43.968Z |
5584021 | 5584021 | 20241117133828_40d3O | NZ0023 | 2024-11-23T14:25:20.220Z | 2024-11-26T14:28:34.804Z |
5583689 | 5583689 | 20241118090821_6SOrD | NZ0023 | 2024-11-23T14:24:52.514Z | 2024-11-26T14:28:00.205Z |
5577126 | 5577126 | 20241121095738_DPsdb | NZ0023 | 2024-11-23T14:12:55.452Z | 2024-11-26T14:24:14.711Z |
5576914 | 5576914 | 20241122143442_QgMou | NZ0023 | 2024-11-23T14:10:54.891Z | 2024-11-23T14:10:54.891Z |
5576905 | 5576905 | 20241122143053_BihqT | NZ0023 | 2024-11-23T14:10:53.494Z | 2024-11-26T14:22:53.999Z |
5576799 | 5576799 | 20241122132836_80ll7 | NZ0023 | 2024-11-23T14:10:28.258Z | 2024-11-26T14:22:52.552Z |
5576751 | 5576751 | 20241122130822_8HNOl | NZ0023 | 2024-11-23T14:10:18.523Z | 2024-11-26T14:22:52.121Z |
5576743 | 5576743 | 20241122130450_jlMiB | NZ0023 | 2024-11-23T14:10:17.782Z | 2024-11-26T14:22:52.040Z |
5576730 | 5576730 | 20241122130330_lIoFC | NZ0023 | 2024-11-23T14:10:16.620Z | 2024-11-26T14:22:51.955Z |
5576682 | 5576682 | 20241122125235_B06gU | NZ0023 | 2024-11-23T14:10:10.784Z | 2024-11-26T14:22:51.636Z |
5576673 | 5576673 | 20241122125005_xZhPu | NZ0023 | 2024-11-23T14:10:06.970Z | 2024-11-26T14:22:51.593Z |
5576526 | 5576526 | 20241122122356_lqg4B | NZ0023 | 2024-11-23T14:09:45.438Z | 2024-11-26T14:22:50.140Z |
5576464 | 5576464 | 20241122121619_Uu3LA | NZ0023 | 2024-11-23T14:09:32.426Z | 2024-11-26T14:22:49.604Z |
5576424 | 5576424 | 20241122120659_v52Da | NZ0023 | 2024-11-23T14:09:25.828Z | 2024-11-26T14:22:49.064Z |
5576395 | 5576395 | 20241122115820_dmyXv | NZ0023 | 2024-11-23T14:09:21.874Z | 2024-11-26T14:22:48.792Z |
5576225 | 5576225 | 20241122113309_Ea9rE | NZ0023 | 2024-11-23T14:08:50.946Z | 2024-11-26T14:22:47.343Z |
5569516 | 5569516 | 20241121154813_bbmTj | NZ0023 | 2024-11-22T14:11:00.868Z | 2024-11-26T14:24:34.901Z |
5569075 | 5569075 | 20241121142724_sgQH2 | NZ0023 | 2024-11-22T14:10:17.306Z | 2024-11-26T14:24:32.075Z |
5568959 | 5568959 | 20241121141102_PpPV5 | NZ0023 | 2024-11-22T14:10:07.131Z | 2024-11-26T14:24:31.835Z |
5568956 | 5568956 | 20241121140953_IdksL | NZ0023 | 2024-11-22T14:10:06.890Z | 2024-11-26T14:24:31.807Z |
5568911 | 5568911 | 20241121140250_cet6x | NZ0023 | 2024-11-22T14:10:03.549Z | 2024-11-26T14:24:31.445Z |
5568853 | 5568853 | 20241121135139_uZRK4 | NZ0023 | 2024-11-22T14:10:00.050Z | 2024-11-26T14:24:31.126Z |
5568826 | 5568826 | 20241121134403_j8YDP | NZ0023 | 2024-11-22T14:09:53.647Z | 2024-11-26T14:24:31.052Z |
5568766 | 5568766 | 20241121133131_vcyKK | NZ0023 | 2024-11-22T14:09:40.909Z | 2024-11-26T14:24:30.842Z |
5568733 | 5568733 | 20241121132915_dVNbP | NZ0023 | 2024-11-22T14:09:38.482Z | 2024-11-26T14:24:30.797Z |
5568641 | 5568641 | 20241121131717_AhyB9 | NZ0023 | 2024-11-22T14:09:29.256Z | 2024-11-26T14:24:30.531Z |
5568352 | 5568352 | 20241121123013_mwauS | NZ0023 | 2024-11-22T14:08:47.162Z | 2024-11-26T14:24:27.366Z |
5568320 | 5568320 | 20241121122340_OZE7z | NZ0023 | 2024-11-22T14:08:42.674Z | 2024-11-26T14:24:27.062Z |
5567670 | 5567670 | 20241121105103_4FJtH | NZ0023 | 2024-11-22T14:06:49.227Z | 2024-11-26T14:24:20.267Z |
5567219 | 5567219 | 20241121094357_XEeQo | NZ0023 | 2024-11-22T14:05:36.499Z | 2024-11-26T14:24:14.073Z |
5555338 | 5555338 | 20241119125023_v1Lw0 | NZ0023 | 2024-11-20T14:05:13.694Z | 2024-11-26T14:27:20.283Z |
5555328 | 5555328 | 20241119124554_dOG7H | NZ0023 | 2024-11-20T14:05:12.086Z | 2024-11-26T14:27:19.189Z |
5551911 | 5551911 | 20241118154004_wojYG | NZ0023 | 2024-11-19T14:05:47.642Z | 2024-11-26T14:28:08.994Z |
5550093 | 5550093 | 20241118092953_jyICJ | NZ0023 | 2024-11-19T14:01:34.256Z | 2024-11-26T14:28:00.837Z |
5549950 | 5549950 | 20241118085535_WdKvc | NZ0023 | 2024-11-19T14:01:20.920Z | 2024-11-26T14:27:59.436Z |
5547220 | 5547220 | 20241117150851_YhECW | NZ0023 | 2024-11-18T14:05:18.235Z | 2024-11-26T14:28:37.756Z |
5547166 | 5547166 | 20241117150304_Pemgo | NZ0023 | 2024-11-18T14:05:12.942Z | 2024-11-26T14:28:37.473Z |
5546654 | 5546654 | 20241117120637_2lZpT | NZ0023 | 2024-11-18T14:03:44.542Z | 2024-11-26T14:28:32.048Z |
5546581 | 5546581 | 20241117114655_HPsai | NZ0023 | 2024-11-18T14:03:34.108Z | 2024-11-26T14:28:31.102Z |
5546387 | 5546387 | 20241117103914_VqY6C | NZ0023 | 2024-11-18T14:02:59.216Z | 2024-11-26T14:28:28.334Z |
5546002 | 5546002 | 20241117083925_sMQ0X | NZ0023 | 2024-11-18T14:01:41.536Z | 2024-11-26T14:28:24.640Z |
5542850 | 5542850 | 20241115143421_PdJdV | NZ0023 | 2024-11-16T14:02:46.177Z | 2024-11-24T14:25:40.853Z |
5542838 | 5542838 | 20241115134258_FTZ7z | NZ0023 | 2024-11-16T14:02:43.964Z | 2024-11-24T14:25:40.747Z |
5542781 | 5542781 | 20241115122911_Xed2i | NZ0023 | 2024-11-16T14:02:33.002Z | 2024-11-24T14:25:40.532Z |
5542653 | 5542653 | 20241115113557_ye3mY | NZ0023 | 2024-11-16T14:02:07.587Z | 2024-11-24T14:25:40.101Z |
5542558 | 5542558 | 20241115105557_BhC1m | NZ0023 | 2024-11-16T14:01:47.366Z | 2024-11-24T14:25:39.843Z |
5542527 | 5542527 | 20241115104157_Yi4f8 | NZ0023 | 2024-11-16T14:01:36.927Z | 2024-11-24T14:25:39.718Z |
5542489 | 5542489 | 20241115101148_E8uyF | NZ0023 | 2024-11-16T14:01:29.872Z | 2024-11-24T14:25:39.625Z |
5519785 | 5519785 | 20241111130049_X532m | NZ0023 | 2024-11-12T14:04:59.182Z | 2024-11-20T14:24:57.862Z |
5508627 | 5508627 | 20241108152824_EKYf1 | NZ0023 | 2024-11-10T14:10:39.780Z | 2024-11-17T14:23:22.141Z |
5508625 | 5508625 | 20241108152450_p2Rgx | NZ0023 | 2024-11-10T14:10:37.899Z | 2024-11-17T14:23:21.888Z |
5508623 | 5508623 | 20241108143830_XL6co | NZ0023 | 2024-11-10T14:10:29.051Z | 2024-11-17T14:23:18.537Z |
5508610 | 5508610 | 20241108114920_SHJwa | NZ0023 | 2024-11-10T14:09:41.570Z | 2024-11-17T14:23:08.574Z |
5508601 | 5508601 | 20241108095924_QwtdK | NZ0023 | 2024-11-10T14:09:16.108Z | 2024-11-17T14:22:59.887Z |
5508599 | 5508599 | 20241108095838_rKHP5 | NZ0023 | 2024-11-10T14:09:13.649Z | 2024-11-17T14:22:59.817Z |
5508597 | 5508597 | 20241108085502_UmkaS | NZ0023 | 2024-11-10T14:09:02.128Z | 2024-11-17T14:22:56.704Z |
5494017 | 5494017 | 20241107151306_36aIz | NZ0023 | 2024-11-08T14:05:16.024Z | 2024-11-16T14:27:45.291Z |
5474058 | 5474058 | 20241103154447_lh3Xl | NZ0023 | 2024-11-05T14:10:03.765Z | 2024-11-12T14:27:50.493Z |
5474047 | 5474047 | 20241103154328_Iaj58 | NZ0023 | 2024-11-05T14:10:02.706Z | 2024-11-12T14:27:50.487Z |
5473913 | 5473913 | 20241103152034_Vjt3g | NZ0023 | 2024-11-05T14:09:53.224Z | 2024-11-12T14:27:50.205Z |
5473694 | 5473694 | 20241103145030_QUdTL | NZ0023 | 2024-11-05T14:09:27.013Z | 2024-11-12T14:27:49.915Z |
5473551 | 5473551 | 20241103143202_weoMc | NZ0023 | 2024-11-05T14:09:05.987Z | 2024-11-12T14:27:49.708Z |
5473449 | 5473449 | 20241103141926_sVpkt | NZ0023 | 2024-11-05T14:08:56.936Z | 2024-11-12T14:27:49.536Z |
5473164 | 5473164 | 20241103133622_zt2tW | NZ0023 | 2024-11-05T14:08:27.141Z | 2024-11-12T14:27:48.128Z |
5472814 | 5472814 | 20241103124732_N6fc3 | NZ0023 | 2024-11-05T14:07:44.832Z | 2024-11-12T14:27:46.763Z |
5472788 | 5472788 | 20241103124123_QqgZa | NZ0023 | 2024-11-05T14:07:42.736Z | 2024-11-12T14:27:46.732Z |
5472775 | 5472775 | 20241103123600_OpG4t | NZ0023 | 2024-11-05T14:07:41.404Z | 2024-11-12T14:27:46.595Z |
5472704 | 5472704 | 20241103122505_0oVdi | NZ0023 | 2024-11-05T14:07:33.706Z | 2024-11-12T14:27:46.349Z |
5472580 | 5472580 | 20241104154826_rfLkM | NZ0023 | 2024-11-05T14:06:17.516Z | 2024-11-13T14:27:26.492Z |
5472461 | 5472461 | 20241104151201_r5Rk1 | NZ0023 | 2024-11-05T14:05:51.496Z | 2024-11-13T14:27:26.305Z |
5472394 | 5472394 | 20241104145804_g2aI1 | NZ0023 | 2024-11-05T14:05:44.868Z | 2024-11-13T14:27:26.239Z |
5472373 | 5472373 | 20241104145118_MgxEG | NZ0023 | 2024-11-05T14:05:43.057Z | 2024-11-13T14:27:26.209Z |
5472133 | 5472133 | 20241104135011_ovzNa | NZ0023 | 2024-11-05T14:05:13.906Z | 2024-11-13T14:27:25.723Z |
5472000 | 5472000 | 20241104132043_kGpJL | NZ0023 | 2024-11-05T14:04:56.628Z | 2024-11-13T14:27:25.564Z |
5471953 | 5471953 | 20241104130804_MVyzj | NZ0023 | 2024-11-05T14:04:52.702Z | 2024-11-13T14:27:25.517Z |
5471930 | 5471930 | 20241104130352_eBRzP | NZ0023 | 2024-11-05T14:04:49.445Z | 2024-11-13T14:27:25.477Z |
5471599 | 5471599 | 20241104120751_I24EK | NZ0023 | 2024-11-05T14:04:01.405Z | 2024-11-13T14:27:24.782Z |
5471399 | 5471399 | 20241104113909_23xx7 | NZ0023 | 2024-11-05T14:03:40.902Z | 2024-11-13T14:27:24.203Z |
5470808 | 5470808 | 20241104095116_FBDF3 | NZ0023 | 2024-11-05T14:01:54.821Z | 2024-11-13T14:27:22.944Z |
5470726 | 5470726 | 20241104093300_f3YXG | NZ0023 | 2024-11-05T14:01:40.739Z | 2024-11-13T14:27:22.766Z |
5470716 | 5470716 | 20241104093022_krGbJ | NZ0023 | 2024-11-05T14:01:38.472Z | 2024-11-13T14:27:22.741Z |
5470624 | 5470624 | 20241104090754_jjAmq | NZ0023 | 2024-11-05T14:01:19.769Z | 2024-11-13T14:27:22.508Z |
5465112 | 5465112 | 20241103104051_MxkcZ | NZ0023 | 2024-11-04T14:02:49.183Z | 2024-11-12T14:27:44.575Z |
5465053 | 5465053 | 20241103103015_uUzv0 | NZ0023 | 2024-11-04T14:02:36.148Z | 2024-11-12T14:27:44.348Z |
5464895 | 5464895 | 20241103094911_65Qjg | NZ0023 | 2024-11-04T14:02:07.233Z | 2024-11-12T14:27:43.842Z |
5464650 | 5464650 | 20241103084314_oo9Na | NZ0023 | 2024-11-04T14:01:13.306Z | 2024-11-12T14:27:42.760Z |
5458593 | 5458593 | 20241101084754_KWVyj | NZ0023 | 2024-11-03T14:10:03.491Z | 2024-11-10T14:26:14.411Z |
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);