participating_station
Data license: CC BY 4.0 license · Data source: Global Meteor Network
1,479 rows where station_code = "NZ0028" 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 |
---|---|---|---|---|---|
5098403 | 5098403 | 20240913165644_5kLby | NZ0028 | 2024-09-17T12:00:28.320Z | 2024-09-19T12:19:36.839Z |
5037500 | 5037500 | 20240905160125_uhbbm | NZ0028 | 2024-09-12T12:14:07.559Z | 2024-09-14T12:22:54.232Z |
5037058 | 5037058 | 20240905150000_9y7OL | NZ0028 | 2024-09-12T12:13:59.979Z | 2024-09-14T12:22:53.657Z |
5037036 | 5037036 | 20240905145649_SsheX | NZ0028 | 2024-09-12T12:13:59.447Z | 2024-09-14T12:22:53.642Z |
5036869 | 5036869 | 20240905143738_Np2g6 | NZ0028 | 2024-09-12T12:13:56.394Z | 2024-09-14T12:22:53.310Z |
5023375 | 5023375 | 20240905160125_i1w7K | NZ0028 | 2024-09-10T12:16:43.993Z | 2024-09-11T12:16:31.637Z |
5015343 | 5015343 | 20240905150000_QLb0a | NZ0028 | 2024-09-10T12:05:06.174Z | 2024-09-11T12:16:31.461Z |
5015323 | 5015323 | 20240905145649_M0LEb | NZ0028 | 2024-09-10T12:04:58.093Z | 2024-09-11T12:16:31.453Z |
5015162 | 5015162 | 20240905143738_Ch8GE | NZ0028 | 2024-09-10T12:04:36.606Z | 2024-09-11T12:16:31.408Z |
5006531 | 5006531 | 20240903174733_6cKrM | NZ0028 | 2024-09-09T12:04:44.273Z | 2024-09-12T12:19:08.549Z |
5006460 | 5006460 | 20240903173651_6SZ6S | NZ0028 | 2024-09-09T12:04:40.275Z | 2024-09-12T12:19:08.286Z |
5006197 | 5006197 | 20240903170404_PudJ2 | NZ0028 | 2024-09-09T12:04:24.314Z | 2024-09-12T12:19:07.845Z |
5005783 | 5005783 | 20240903161036_EXkIU | NZ0028 | 2024-09-09T12:04:04.222Z | 2024-09-12T12:19:06.649Z |
5005775 | 5005775 | 20240903160951_4zWHR | NZ0028 | 2024-09-09T12:04:03.774Z | 2024-09-12T12:19:06.634Z |
5005622 | 5005622 | 20240903154744_DE8i8 | NZ0028 | 2024-09-09T12:03:51.926Z | 2024-09-12T12:19:06.307Z |
5005299 | 5005299 | 20240903144922_ut3JK | NZ0028 | 2024-09-09T12:03:34.793Z | 2024-09-12T12:19:05.656Z |
5005205 | 5005205 | 20240903143107_HfpPE | NZ0028 | 2024-09-09T12:03:26.643Z | 2024-09-12T12:19:05.459Z |
5005195 | 5005195 | 20240903142723_eOKpZ | NZ0028 | 2024-09-09T12:03:26.063Z | 2024-09-12T12:19:05.436Z |
5003876 | 5003876 | 20240903100844_D6Npe | NZ0028 | 2024-09-09T12:02:10.183Z | 2024-09-12T12:19:00.032Z |
5003802 | 5003802 | 20240903095601_04l5W | NZ0028 | 2024-09-09T12:02:05.317Z | 2024-09-12T12:18:59.183Z |
5003462 | 5003462 | 20240903085403_2Pem0 | NZ0028 | 2024-09-09T12:01:45.281Z | 2024-09-12T12:18:56.838Z |
4913847 | 4913847 | 20240809104109_mjw1e | NZ0028 | 2024-08-29T12:17:09.927Z | 2024-08-30T12:23:10.933Z |
4909855 | 4909855 | 20240809172550_h8mR2 | NZ0028 | 2024-08-29T12:05:34.560Z | 2024-09-02T12:20:24.983Z |
4909625 | 4909625 | 20240809171057_xvudx | NZ0028 | 2024-08-29T12:05:20.353Z | 2024-09-02T12:20:06.754Z |
4909134 | 4909134 | 20240809163311_KTxa3 | NZ0028 | 2024-08-29T12:04:48.491Z | 2024-09-02T12:19:46.524Z |
4909007 | 4909007 | 20240809162446_Yej3x | NZ0028 | 2024-08-29T12:04:40.889Z | 2024-09-02T12:19:37.874Z |
4908910 | 4908910 | 20240809161616_GRrli | NZ0028 | 2024-08-29T12:04:33.945Z | 2024-09-02T12:19:30.985Z |
4908809 | 4908809 | 20240809160655_Oa6dC | NZ0028 | 2024-08-29T12:04:28.092Z | 2024-09-02T12:19:27.458Z |
4908663 | 4908663 | 20240809155353_lh2FD | NZ0028 | 2024-08-29T12:04:19.409Z | 2024-09-02T12:19:20.111Z |
4907641 | 4907641 | 20240809143834_3Wtue | NZ0028 | 2024-08-29T12:03:14.982Z | 2024-09-02T12:18:36.687Z |
4907148 | 4907148 | 20240809135029_eTbHI | NZ0028 | 2024-08-29T12:02:42.677Z | 2024-09-02T12:18:09.799Z |
4906680 | 4906680 | 20240809130553_p2m3N | NZ0028 | 2024-08-29T12:02:07.625Z | 2024-09-02T12:17:48.644Z |
4906651 | 4906651 | 20240809130122_WmBBj | NZ0028 | 2024-08-29T12:02:05.352Z | 2024-09-02T12:17:46.139Z |
4906529 | 4906529 | 20240809124726_FYcTi | NZ0028 | 2024-08-29T12:01:58.556Z | 2024-09-02T12:17:41.148Z |
4906527 | 4906527 | 20240809124713_3E4G1 | NZ0028 | 2024-08-29T12:01:58.314Z | 2024-09-02T12:17:41.054Z |
4906509 | 4906509 | 20240809124555_fJccG | NZ0028 | 2024-08-29T12:01:56.716Z | 2024-09-02T12:17:40.443Z |
4906396 | 4906396 | 20240809123613_CwusE | NZ0028 | 2024-08-29T12:01:50.061Z | 2024-09-02T12:17:35.729Z |
4906174 | 4906174 | 20240809121112_OugON | NZ0028 | 2024-08-29T12:01:33.145Z | 2024-09-02T12:17:28.778Z |
4906160 | 4906160 | 20240809120812_r4TM3 | NZ0028 | 2024-08-29T12:01:31.113Z | 2024-09-02T12:17:28.032Z |
4906001 | 4906001 | 20240809114753_8FNH9 | NZ0028 | 2024-08-29T12:01:19.171Z | 2024-09-02T12:17:23.303Z |
4894895 | 4894895 | 20240807105237_BWBCz | NZ0028 | 2024-08-28T12:12:48.246Z | 2024-08-28T12:12:48.246Z |
4894562 | 4894562 | 20240807101334_7rRhZ | NZ0028 | 2024-08-28T12:12:34.000Z | 2024-08-28T12:12:34.000Z |
4894119 | 4894119 | 20240807092622_enJzw | NZ0028 | 2024-08-28T12:12:07.968Z | 2024-08-28T12:12:07.968Z |
4893727 | 4893727 | 20240807084318_LYTIU | NZ0028 | 2024-08-28T12:11:42.450Z | 2024-08-28T12:11:42.450Z |
4893341 | 4893341 | 20240809092239_9L91C | NZ0028 | 2024-08-28T12:11:19.430Z | 2024-08-30T12:22:54.605Z |
4893122 | 4893122 | 20240809083654_fpMKi | NZ0028 | 2024-08-28T12:11:02.181Z | 2024-08-30T12:22:47.170Z |
4865680 | 4865680 | 20240806150958_lFO2s | NZ0028 | 2024-08-18T12:07:11.155Z | 2024-08-27T12:06:27.487Z |
4865573 | 4865573 | 20240806150659_9AQN1 | NZ0028 | 2024-08-18T12:07:06.378Z | 2024-08-27T12:06:24.874Z |
4865425 | 4865425 | 20240806145840_K2HIU | NZ0028 | 2024-08-18T12:06:52.511Z | 2024-08-27T12:06:19.216Z |
4865389 | 4865389 | 20240806145702_U8MhC | NZ0028 | 2024-08-18T12:06:49.681Z | 2024-08-27T12:06:18.170Z |
4865250 | 4865250 | 20240806145225_K9OBp | NZ0028 | 2024-08-18T12:06:39.252Z | 2024-08-27T12:06:08.730Z |
4865192 | 4865192 | 20240806145008_IxsME | NZ0028 | 2024-08-18T12:06:34.098Z | 2024-08-27T12:06:05.410Z |
4865093 | 4865093 | 20240806144634_IJEOB | NZ0028 | 2024-08-18T12:06:30.411Z | 2024-08-27T12:06:01.604Z |
4864905 | 4864905 | 20240806143714_JkCrE | NZ0028 | 2024-08-18T12:06:21.525Z | 2024-08-27T12:05:52.712Z |
4864869 | 4864869 | 20240806143607_2BIUB | NZ0028 | 2024-08-18T12:06:20.487Z | 2024-08-27T12:05:51.924Z |
4864341 | 4864341 | 20240806141255_rPDWX | NZ0028 | 2024-08-18T12:06:02.543Z | 2024-08-27T12:05:35.319Z |
4864153 | 4864153 | 20240806140237_yaiz5 | NZ0028 | 2024-08-18T12:05:45.442Z | 2024-08-27T12:05:24.103Z |
4863604 | 4863604 | 20240806133119_QFJCf | NZ0028 | 2024-08-18T12:05:17.977Z | 2024-08-27T12:05:02.294Z |
4863525 | 4863525 | 20240806132737_EOYJX | NZ0028 | 2024-08-18T12:05:15.320Z | 2024-08-27T12:04:57.225Z |
4862701 | 4862701 | 20240806124701_4sGTx | NZ0028 | 2024-08-18T12:04:36.906Z | 2024-08-27T12:04:25.856Z |
4862500 | 4862500 | 20240806123620_4rKhm | NZ0028 | 2024-08-18T12:04:29.066Z | 2024-08-27T12:04:15.938Z |
4862249 | 4862249 | 20240806122222_XwYbH | NZ0028 | 2024-08-18T12:04:21.235Z | 2024-08-27T12:04:07.110Z |
4862032 | 4862032 | 20240806121158_tP0fr | NZ0028 | 2024-08-18T12:04:07.662Z | 2024-08-27T12:03:59.614Z |
4861989 | 4861989 | 20240806120841_HXVzo | NZ0028 | 2024-08-18T12:04:05.752Z | 2024-08-27T12:03:57.557Z |
4861937 | 4861937 | 20240806120438_3XQl6 | NZ0028 | 2024-08-18T12:04:03.622Z | 2024-08-27T12:03:53.683Z |
4861844 | 4861844 | 20240806120122_UDGrr | NZ0028 | 2024-08-18T12:03:58.231Z | 2024-08-27T12:03:51.105Z |
4859977 | 4859977 | 20240806101101_BKlsW | NZ0028 | 2024-08-18T12:02:23.522Z | 2024-08-27T12:02:23.782Z |
4859902 | 4859902 | 20240806100815_4v3Wa | NZ0028 | 2024-08-18T12:02:18.888Z | 2024-08-27T12:02:21.207Z |
4859203 | 4859203 | 20240806092105_KcHNe | NZ0028 | 2024-08-18T12:01:37.104Z | 2024-08-27T12:01:44.260Z |
4858369 | 4858369 | 20240806082009_K3zyT | NZ0028 | 2024-08-18T12:00:47.782Z | 2024-08-27T12:00:55.341Z |
4858030 | 4858030 | 20240806075023_wUVSO | NZ0028 | 2024-08-18T12:00:21.461Z | 2024-08-27T12:00:31.301Z |
4850466 | 4850466 | 20240805185913_dXZYP | NZ0028 | 2024-08-17T12:13:11.364Z | 2024-08-19T12:23:05.436Z |
4850271 | 4850271 | 20240805183628_OcQD0 | NZ0028 | 2024-08-17T12:12:49.775Z | 2024-08-19T12:22:53.942Z |
4850204 | 4850204 | 20240805183027_ZZLNL | NZ0028 | 2024-08-17T12:12:43.974Z | 2024-08-19T12:22:50.483Z |
4848622 | 4848622 | 20240805171425_m5WpX | NZ0028 | 2024-08-17T12:10:47.945Z | 2024-08-19T12:21:32.992Z |
4848617 | 4848617 | 20240805171407_awhoZ | NZ0028 | 2024-08-17T12:10:47.184Z | 2024-08-19T12:21:32.820Z |
4846063 | 4846063 | 20240805160029_T2bMg | NZ0028 | 2024-08-16T12:09:47.089Z | 2024-08-19T12:20:47.474Z |
4845756 | 4845756 | 20240805154650_1A1TB | NZ0028 | 2024-08-16T12:09:31.733Z | 2024-08-19T12:20:32.125Z |
4845535 | 4845535 | 20240805153844_rKG20 | NZ0028 | 2024-08-16T12:09:20.722Z | 2024-08-19T12:20:22.272Z |
4844931 | 4844931 | 20240805151855_2PQRo | NZ0028 | 2024-08-16T12:08:42.888Z | 2024-08-19T12:19:56.589Z |
4844827 | 4844827 | 20240805151440_sa813 | NZ0028 | 2024-08-16T12:08:38.855Z | 2024-08-19T12:19:51.176Z |
4844624 | 4844624 | 20240805150827_qo9fG | NZ0028 | 2024-08-16T12:08:29.922Z | 2024-08-19T12:19:40.944Z |
4844379 | 4844379 | 20240805150002_h1fzU | NZ0028 | 2024-08-16T12:08:13.145Z | 2024-08-19T12:19:29.692Z |
4843990 | 4843990 | 20240805144553_yoBcN | NZ0028 | 2024-08-16T12:07:48.007Z | 2024-08-19T12:19:10.912Z |
4843842 | 4843842 | 20240805144106_8XE8B | NZ0028 | 2024-08-16T12:07:42.550Z | 2024-08-19T12:19:04.947Z |
4843545 | 4843545 | 20240805142722_vhHc2 | NZ0028 | 2024-08-16T12:07:32.014Z | 2024-08-19T12:18:55.178Z |
4842410 | 4842410 | 20240805133302_5gOh7 | NZ0028 | 2024-08-16T12:06:21.987Z | 2024-08-19T12:18:32.691Z |
4842037 | 4842037 | 20240805131443_U5ZJI | NZ0028 | 2024-08-16T12:06:03.900Z | 2024-08-19T12:18:24.040Z |
4841851 | 4841851 | 20240805130422_Gkdiz | NZ0028 | 2024-08-16T12:05:53.479Z | 2024-08-19T12:18:15.098Z |
4841300 | 4841300 | 20240805123008_32YLV | NZ0028 | 2024-08-16T12:05:19.946Z | 2024-08-19T12:17:48.291Z |
4839938 | 4839938 | 20240805105510_SmroU | NZ0028 | 2024-08-16T12:04:05.824Z | 2024-08-19T12:16:55.381Z |
4839932 | 4839932 | 20240805105450_xyXgD | NZ0028 | 2024-08-16T12:04:05.692Z | 2024-08-19T12:16:55.321Z |
4839506 | 4839506 | 20240805102739_4Q7FM | NZ0028 | 2024-08-16T12:03:32.621Z | 2024-08-19T12:16:45.060Z |
4839446 | 4839446 | 20240805102320_y2gYP | NZ0028 | 2024-08-16T12:03:29.690Z | 2024-08-19T12:16:43.583Z |
4829052 | 4829052 | 20240804184457_CyuVZ | NZ0028 | 2024-08-15T12:08:02.567Z | 2024-08-17T12:28:37.635Z |
4828966 | 4828966 | 20240804183256_IAsWO | NZ0028 | 2024-08-15T12:07:46.455Z | 2024-08-17T12:28:31.636Z |
4828875 | 4828875 | 20240804182314_DPhbP | NZ0028 | 2024-08-15T12:07:39.187Z | 2024-08-17T12:28:27.980Z |
4827706 | 4827706 | 20240804165055_bfi7D | NZ0028 | 2024-08-15T12:06:01.648Z | 2024-08-17T12:27:33.855Z |
4827700 | 4827700 | 20240804164954_Nxq11 | NZ0028 | 2024-08-15T12:06:00.813Z | 2024-08-17T12:27:33.541Z |
4820747 | 4820747 | 20240804143347_sOLYA | NZ0028 | 2024-08-14T12:07:02.810Z | 2024-08-17T12:26:38.848Z |
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);