names

70 rows where place_id = 609621

✎ 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
3679373 1919612 1919612 defendant Wall Thomas chaplain 609621 609621 Wall, Thomas, of Mallyng, chaplain 0
3679377 1919613 1919613 defendant Wall Thomas chaplain 609621 609621 Wall, Thomas, of Mallyng, chaplain 0
3853200 1974622 1974622 defendant Broke John yeoman 609621 609621 Broke, John, of Mallyng, yeoman 1
4034503 2037011 2037011 defendant Lucas John husbandman 609621 609621 Lucas, John, of Mallyng, or of Clyffe next Lewes, husbandman 0
4146873 2077060 2077060 defendant Wykes Stephen smith 609621 609621 Wykes, Stephen, of Mallyng, smith 0
4452921 2185920 2185920 defendant Okeley Thomas   609621 609621 Okeley, Thomas, of Mallyng, formerly deacon 2
4454049 2186280 2186280 defendant Martyn John   609621 609621 Martyn, John, of Mallyng 0
4462349 2188920 2188920 defendant Buntyng Bartholomew   609621 609621 Buntyng, Bartholomew, of Mallyng 2
4462350 2188920 2188920 defendant Tyler Richard   609621 609621 Tyler, Richard, of Mallyng 3
4492759 2198436 2198436 defendant Bertelot Thomas   609621 609621 Bertelot, Thomas, of Mallyng, parchment maker 0
4498795 2200256 2200256 defendant Sprot William   609621 609621 Sprot, William, of Mallyng 0
4524066 2207859 2207859 defendant Perys Thomas   609621 609621 Perys, Thomas, of Mallyng 3
4544885 2214319 2214319 defendant Draper Thomas   609621 609621 Draper, Thomas, of Mallyng 0
4566191 2220987 2220987 defendant Harneys Thomas   609621 609621 Harneys, Thomas, of Mallyng 2
4569853 2222142 2222142 defendant Harveys Thomas   609621 609621 Harveys, Thomas, of Mallyng 0
4576555 2224178 2224178 defendant Goos John   609621 609621 Goos, John, of Mallyng 0
4577951 2224609 2224609 defendant Wilkyn Richard   609621 609621 Wilkyn, Richard, of Mallyng 1
4594819 2229633 2229633 defendant Grygge Robert fuller 609621 609621 Grygge, Robert, of Mallyng, fuller 4
4601905 2231822 2231822 defendant Dene John   609621 609621 Dene, John, of Mallyng 0
4606403 2233118 2233118 defendant Kyng John clerk 609621 609621 Kyng, John, of Mallyng, clerk 0
4627948 2239669 2239669 plaintiff Ruton Isabel   609621 609621 Ruton, Isabel, of Mallyng, abbess 0
4627954 2239670 2239670 plaintiff Ruton Isabel   609621 609621 Ruton, Isabel, of Mallyng, abbess 0
4633153 2241236 2241236 defendant Payn John   609621 609621 Payn, John, of Mallyng 1
4633260 2241273 2241273 defendant Potyn William (legal representative) 609621 609621 Potyn, William, of Mallyng, clerk, executors of 0
4641213 2243521 2243521 defendant Whetale John   609621 609621 Whetale, John, of Mallyng 4
4646048 2244918 2244918 defendant Sprot William   609621 609621 Sprot, William, of Mallyng 0
4652314 2246676 2246676 defendant Kyne Richard chapman 609621 609621 Kyne, Richard, of Mallyng, chapman 2
4652315 2246676 2246676 defendant Sprot Robert fisher 609621 609621 Sprot, Robert, of Mallyng, fisher 3
4653433 2247004 2247004 defendant Dyne Henry husbandman 609621 609621 Dyne, Henry, of Mallyng, husbandman 0
4662027 2249599 2249599 defendant Whetale John husbandman 609621 609621 Whetale, John, of Mallyng, husbandman 0
4684843 2260858 2260858 defendant Eylewyne Marger widow 609621 609621 Eylewyne, Marger, of Mallyng, widow 1
4693202 2263375 2263375 defendant Dyne Robert butcher 609621 609621 Dyne, Robert, of Mallyng, butcher 0
4696646 2264428 2264428 defendant Dyne Henry husbandman 609621 609621 Dyne, Henry, of Mallyng, husbandman 2
4696647 2264428 2264428 defendant Clovyer John   609621 609621 Clovyer, John, of Mallyng, lathe maker 3
4696648 2264428 2264428 defendant Talbot John carpenter 609621 609621 Talbot, John, of Mallyng, carpenter 4
4696770 2264468 2264468 defendant Dyn Henry   609621 609621 Dyn, Henry, of Mallyng, plough man 2
4699755 2265368 2265368 defendant Mayhewe Henry husbandman 609621 609621 Mayhewe, Henry, of Mallyng, husbandman 0
4699756 2265368 2265368 defendant Sextayn William husbandman 609621 609621 Sextayn, William, of Mallyng, husbandman 1
4707213 2267635 2267635 defendant Veysy Richard   609621 609621 Veysy, Richard, of Mallyng, shoe maker 1
4743161 2278524 2278524 defendant Maneware William yeoman 609621 609621 Maneware, William, of Mallyng, yeoman 2
4780957 2290047 2290047 defendant Maneware William husbandman 609621 609621 Maneware, William, of Mallyng, husbandman 0
4809633 2299177 2299177 defendant Large Stephen seller of fish inland 609621 609621 Large, Stephen, of Mallyng, seller of fish inland 0
4817131 2301449 2301449 defendant Dorant Thomas milner 609621 609621 Dorant, Thomas, of Mallyng, milner 0
4842173 2309087 2309087 defendant Chambyrleyn John yeoman 609621 609621 Chambyrleyn, John, of Mallyng, yeoman 1
4873975 2318799 2318799 plaintiff Peke William   609621 609621 Peke, William, of Mallyng 2
4884627 2322103 2322103 defendant Savage Robert clerk 609621 609621 Savage, Robert, of Mallyng, clerk 0
4894448 2324939 2324939 defendant Elham Thomas chapman 609621 609621 Elham, Thomas, of Mallyng, chapman 0
4904530 2328025 2328025 defendant Savage Robert clerk 609621 609621 Savage, Robert, of Mallyng, clerk 0
4963510 2345998 2345998 defendant Peteman Thomas weaver 609621 609621 Peteman, Thomas, of Mallyng, weaver 0
4966716 2346981 2346981 plaintiff Druell John clerk 609621 609621 Druell, John, of Mallyng, clerk 0
5001913 2357459 2357459 defendant Meryman Geoffrey yeoman 609621 609621 Meryman, Geoffrey, of Mallyng, yeoman 1
5020174 2362790 2362790 plaintiff Downe William   609621 609621 Downe, William, of Mallyng 0
5073204 2378474 2378474 defendant Norys Thomas yeoman 609621 609621 Norys, Thomas, of Mallyng, yeoman 0
5081610 2381006 2381006 defendant Stapelegh William husbandman 609621 609621 Stapelegh, William, of Mallyng, husbandman 0
5129155 2395016 2395016 defendant Crowecher John butcher 609621 609621 Crowecher, John, of Mallyng, butcher 0
5148358 2400658 2400658 defendant Crowecher John butcher 609621 609621 Crowecher, John, of Mallyng, butcher 0
5280402 2439343 2439343 defendant Pynne John husbandman 609621 609621 Pynne, John, of Mallyng, husbandman 3
5386946 2471333 2471333 defendant Colt William husbandman 609621 609621 Colt, William, of Mallyng, husbandman 1
5416762 2479928 2479928 plaintiff Move Joan   609621 609621 Move, Joan, of Mallyng, abbess of the monastery of the BM 0
5422057 2481538 2481538 defendant Juddes John gent 609621 609621 Juddes, John, of Mallyng, gent 0
5433468 2484970 2484970 plaintiff Mone John   609621 609621 Mone, John, of Mallyng, abbot of St Mary's monastery 0
5440974 2487209 2487209 defendant Juddes John gent 609621 609621 Juddes, John, of Mallyng, gent 0
5454591 2491288 2491288 defendant Juddes John gent 609621 609621 Juddes, John, of Mallyng, gent 0
5461376 2493352 2493352 plaintiff Mone or Move Joan   609621 609621 Mone or Move, Joan, of Mallyng, abbess of the monastery of the BM 0
5466007 2494761 2494761 plaintiff (illegible) John   609621 609621 _, John, of Mallyng, abbot of the monastery of the BM 0
5466456 2494904 2494904 defendant Juddes John gent 609621 609621 Juddes, John, of Mallyng, gent 0
5510417 2508100 2508100 plaintiff Harrys John   609621 609621 Harrys, John, of Mallyng 0
5526110 2512742 2512742 defendant Boteler John gent 609621 609621 Boteler, John, of Mallyng, gent 0
5528323 2513412 2513412 defendant Boteler John gent 609621 609621 Boteler, John, of Mallyng, gent 0
5633083 2554351 2554351 defendant Wardon John husbandman 609621 609621 Wardon, John, of Mallyng, husbandman 0

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);