names

117 rows where place_id = 587173

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590656 1864720 1864720 defendant Symond Thomas husbandman 587173 587173 Symond, Thomas, of Hendon, husbandman 0
3612437 1871519 1871519 defendant Creweker William yeoman 587173 587173 Creweker, William, of Hendon, yeoman 0
3623953 1875022 1875022 defendant Edward John husbandman 587173 587173 Edward, John, of Hendon, husbandman 0
3623955 1875023 1875023 defendant Edward John husbandman 587173 587173 Edward, John, of Hendon, husbandman 0
3626769 1903219 1903219 defendant Burton Thomas husbandman 587173 587173 Burton, Thomas, of Hendon, husbandman 1
3626770 1903219 1903219 defendant Burton Robert husbandman 587173 587173 Burton, Robert, of Hendon, husbandman 2
3644790 1908778 1908778 plaintiff Forster Roger (legal representative) 587173 587173 Forster, Roger, of Hendon, gent, executors of 0
3649784 1910295 1910295 defendant Baynes Thomas clerk 587173 587173 Baynes, Thomas, of Hendon, clerk 0
3654612 1911705 1911705 defendant Ryse Robert gent 587173 587173 Ryse, Robert, of Hendon, gent 0
3654998 1911826 1911826 defendant Rics Richard gent 587173 587173 Rics, Richard, of Hendon, gent 0
3662951 1914326 1914326 plaintiff Nicoll Richard (legal representative) 587173 587173 Nicoll, Richard, of Hendon, husbandman, executors of 0
3686500 1921929 1921929 defendant Page Bartholomew yeoman 587173 587173 Page, Bartholomew, of Hendon, yeoman 1
3768097 1947657 1947657 defendant Forster Roger gent 587173 587173 Forster, Roger, of Hendon, gent 0
3829038 1966963 1966963 defendant Crowde Robert husbandman 587173 587173 Crowde, Robert, of Hendon, husbandman 1
3829039 1966963 1966963 defendant Gylle Thomas husbandman 587173 587173 Gylle, Thomas, of Hendon, husbandman 2
3829040 1966963 1966963 defendant Budder Roger husbandman 587173 587173 Budder, Roger, of Hendon, husbandman 3
3829041 1966963 1966963 defendant Palmer Richard husbandman 587173 587173 Palmer, Richard, of Hendon, husbandman 4
3880345 1983680 1983680 defendant Menard William innholder 587173 587173 Menard, William, of Hendon, innholder 0
3880346 1983680 1983680 defendant Lekey William husbandman 587173 587173 Lekey, William, of Hendon, husbandman 1
3880348 1983681 1983681 defendant Menard William innholder 587173 587173 Menard, William, of Hendon, innholder 0
3880349 1983681 1983681 defendant Lekey William husbandman 587173 587173 Lekey, William, of Hendon, husbandman 1
3901282 1990654 1990654 defendant Braynt John husbandman 587173 587173 Braynt, John, of Hendon, husbandman 0
3949334 2006838 2006838 defendant Burton Henry (legal representative) 587173 587173 Burton, Henry, of Hendon, yeoman, executors of 0
4004940 2026547 2026547 defendant Burton Henry husbandman 587173 587173 Burton, Henry, of Hendon, husbandman 3
4136357 2073347 2073347 defendant Taylor John yeoman 587173 587173 Taylor, John, of Hendon, yeoman 0
4160671 2081806 2081806 defendant Taylor John yeoman 587173 587173 Taylor, John, of Hendon, yeoman 0
4242835 2110595 2110595 defendant Wise John   587173 587173 Wise, John, of Hendon, yeoman, his son 1
4266310 2118374 2118374 defendant Wise John   587173 587173 Wise, John, of Hendon, yeoman, his son 1
4270427 2119689 2119689 defendant Jackson John tanner 587173 587173 Jackson, John, of Hendon, or of Kentishtowne, Middx, tanner 0
4298363 2129514 2129514 defendant Wise William yeoman 587173 587173 Wise, William, of Hendon, yeoman 0
4415296 2169680 2169680 plaintiff Hale Robert in the   587173 587173 Hale, Robert in the, of Hendon, junior 0
4441812 2182375 2182375 plaintiff Brasyer William   587173 587173 Brasyer, William, of Hendon 0
4557529 2218291 2218291 defendant Norman Walter   587173 587173 Norman, Walter, of Hendon, vicar 4
4701362 2265828 2265828 defendant Norman Walter clerk 587173 587173 Norman, Walter, of Hendon, clerk 1
4771978 2287209 2287209 defendant Redon Robert laborer 587173 587173 Redon, Robert, of Hendon, laborer 0
4805567 2297955 2297955 plaintiff Bryt John   587173 587173 Bryt, John, of Hendon, on his own account 0
4811960 2299853 2299853 defendant Bounde Thomas husbandman 587173 587173 Bounde, Thomas, of Hendon, husbandman 0
4825705 2304082 2304082 defendant Ederythe John husbandman 587173 587173 Ederythe, John, of Hendon, husbandman 1
4825709 2304083 2304083 defendant Ederych Thomas husbandman 587173 587173 Ederych, Thomas, of Hendon, husbandman 1
4841177 2308777 2308777 defendant Brent John   587173 587173 Brent, John, of Hendon 0
4886355 2322592 2322592 defendant Parker William carpenter 587173 587173 Parker, William, of Hendon, carpenter 1
4948160 2341397 2341397 defendant Martyn John husbandman 587173 587173 Martyn, John, of Hendon, husbandman 0
4980010 2350976 2350976 defendant Edrych Lawrence   587173 587173 Edrych, Lawrence, of Hendon husbandman 1
4980012 2350976 2350976 defendant Edward John husbandman 587173 587173 Edward, John, of Hendon, husbandman 3
4993792 2355012 2355012 defendant bukberd John husbandman 587173 587173 bukberd, John, of Hendon, husbandman 2
5032974 2366531 2366531 defendant Kyng Peter husbandman 587173 587173 Kyng, Peter, of Hendon, husbandman 0
5032975 2366531 2366531 defendant Page John husbandman 587173 587173 Page, John, of Hendon, husbandman 1
5063590 2375643 2375643 defendant Brent John yeoman 587173 587173 Brent, John, of Hendon, yeoman 0
5131196 2395613 2395613 defendant Wode John husbandman 587173 587173 Wode, John, of Hendon, husbandman 0
5134180 2396490 2396490 defendant atte Wode John husbandman 587173 587173 atte Wode, John, of Hendon, husbandman 0
5136336 2397149 2397149 defendant Colles Thomas husbandman 587173 587173 Colles, Thomas, of Hendon, husbandman 0
5139080 2397921 2397921 defendant atte Wode John husbandman 587173 587173 atte Wode, John, of Hendon, husbandman 0
5149812 2401081 2401081 defendant Aldenam Roger husbandman 587173 587173 Aldenam, Roger, of Hendon, husbandman 1
5149813 2401081 2401081 defendant Grey John   587173 587173 Grey, John, of Hendon, servant 2
5149814 2401081 2401081 defendant Wyse William husbandman 587173 587173 Wyse, William, of Hendon, husbandman 3
5150716 2401354 2401354 defendant Wode John husbandman 587173 587173 Wode, John, of Hendon, husbandman 0
5156692 2403118 2403118 defendant Collys Thomas husbandman 587173 587173 Collys, Thomas, of Hendon, husbandman 0
5156695 2403119 2403119 defendant Colles Thomas husbandman 587173 587173 Colles, Thomas, of Hendon, husbandman 1
5156698 2403120 2403120 defendant Colles Thomas husbandman 587173 587173 Colles, Thomas, of Hendon, husbandman 1
5168612 2406540 2406540 defendant Aldenam Roger husbandman 587173 587173 Aldenam, Roger, of Hendon, husbandman 1
5168613 2406540 2406540 defendant Grey John   587173 587173 Grey, John, of Hendon, servant 2
5168614 2406540 2406540 defendant Wyse William   587173 587173 Wyse, William, of Hendon 3
5169128 2406706 2406706 defendant Wode John husbandman 587173 587173 Wode, John, of Hendon, husbandman 0
5184622 2411250 2411250 defendant Aldenam Roger husbandman 587173 587173 Aldenam, Roger, of Hendon, husbandman 0
5185598 2411539 2411539 defendant Wode John husbandman 587173 587173 Wode, John, of Hendon, husbandman 0
5187001 2411937 2411937 defendant Pymberd Thomas husbandman 587173 587173 Pymberd, Thomas, of Hendon, husbandman 0
5187007 2411938 2411938 defendant Pymberd Thomas husbandman 587173 587173 Pymberd, Thomas, of Hendon, husbandman 0
5191540 2413267 2413267 defendant Abell William husbandman 587173 587173 Abell, William, of Hendon, husbandman 1
5191962 2413380 2413380 defendant Abell William husbandman 587173 587173 Abell, William, of Hendon, husbandman 1
5191965 2413381 2413381 defendant Abell William husbandman 587173 587173 Abell, William, of Hendon, husbandman 1
5192630 2413581 2413581 defendant Colles Thomas husbandman 587173 587173 Colles, Thomas, of Hendon, husbandman 0
5192633 2413582 2413582 defendant Collys Thomas husbandman 587173 587173 Collys, Thomas, of Hendon, husbandman 0
5192635 2413583 2413583 defendant Collys Thomas husbandman 587173 587173 Collys, Thomas, of Hendon, husbandman 0
5205452 2417347 2417347 defendant Pymberd Thomas husbandman 587173 587173 Pymberd, Thomas, of Hendon, husbandman 0
5244174 2428490 2428490 defendant Kyng Peter husbandman 587173 587173 Kyng, Peter, of Hendon, husbandman 0
5244176 2428491 2428491 defendant Kyng Peter husbandman 587173 587173 Kyng, Peter, of Hendon, husbandman 0
5245691 2428900 2428900 defendant Kyng Peter husbandman 587173 587173 Kyng, Peter, of Hendon, husbandman 0
5245704 2428906 2428906 defendant Kyng Peter husbandman 587173 587173 Kyng, Peter, of Hendon, husbandman 0
5253990 2431368 2431368 plaintiff Browne Stephen   587173 587173 Browne, Stephen, of Hendon 0
5253991 2431368 2431368 plaintiff Shawe John   587173 587173 Shawe, John, of Hendon 1
5253993 2431368 2431368 defendant Sponer William tanner 587173 587173 Sponer, William, of Hendon, tanner 0
5273498 2437321 2437321 defendant Sutton William clerk & parson of St Mary's church 587173 587173 Sutton, William, of Hendon, clerk & parson of St Mary's church 0
5290766 2442301 2442301 plaintiff Page Richard   587173 587173 Page, Richard, of Hendon 0
5290768 2442302 2442302 plaintiff Page Richard   587173 587173 Page, Richard, of Hendon 0
5303030 2445895 2445895 defendant Smyth William laborer 587173 587173 Smyth, William, of Hendon, laborer 3
5310581 2448200 2448200 defendant Clerk Thomas husbandman 587173 587173 Clerk, Thomas, of Hendon, husbandman 0
5323138 2452002 2452002 defendant Redehode John husbandman 587173 587173 Redehode, John, of Hendon, husbandman 0
5337992 2456447 2456447 defendant Reynold Thomas collier 587173 587173 Reynold, Thomas, of Hendon, collier 0
5337993 2456447 2456447 defendant Nycholl Alan collier 587173 587173 Nycholl, Alan, of Hendon, collier 1
5391059 2472513 2472513 plaintiff Nycoll John collier 587173 587173 Nycoll, John, of Hendon, collier 0
5391060 2472513 2472513 defendant atte Wode John husbandman 587173 587173 atte Wode, John, of Hendon, husbandman 0
5394443 2473472 2473472 defendant Burton Bartholomew gent 587173 587173 Burton, Bartholomew, of Hendon, gent 0
5399556 2474953 2474953 defendant Burton Bartholomew gent 587173 587173 Burton, Bartholomew, of Hendon, gent 0
5413197 2478870 2478870 defendant Wode John yeoman 587173 587173 Wode, John, of Hendon, yeoman 0
5420885 2481175 2481175 defendant Burton Bartholomew   587173 587173 Burton, Bartholomew, of Hendon, gent, & of Bykebury, Devon 0
5439965 2486897 2486897 defendant Burton Bartholomew gent 587173 587173 Burton, Bartholomew, of Hendon, gent 0
5439967 2486898 2486898 defendant Burton Bartholomew   587173 587173 Burton, Bartholomew, of Hendon, gent, formerly of Bykebury, Devon 0
5443622 2488012 2488012 defendant More Edward gent 587173 587173 More, Edward, of Hendon, gent 0
5447146 2489037 2489037 defendant More Edward gent 587173 587173 More, Edward, of Hendon, gent 2
5453513 2490944 2490944 defendant Burton Bartholomew gent 587173 587173 Burton, Bartholomew, of Hendon, gent 0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);