names

87 rows where place_id = 597727

✎ 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
3629623 1904117 1904117 defendant Willons William husbandman 597727 597727 Willons, William, of Asshedon, husbandman 2
3629627 1904118 1904118 defendant Wyllons William husbandman 597727 597727 Wyllons, William, of Asshedon, husbandman 2
3722917 1933433 1933433 plaintiff Newman Peter clerk 597727 597727 Newman, Peter, of Asshedon, clerk 0
3722919 1933434 1933434 plaintiff Newman Peter clerk 597727 597727 Newman, Peter, of Asshedon, clerk 0
3743136 1939712 1939712 plaintiff Webbe John husbandman 597727 597727 Webbe, John, of Asshedon, husbandman 0
3743138 1939713 1939713 plaintiff Webbe John husbandman 597727 597727 Webbe, John, of Asshedon, husbandman 0
3775264 1950000 1950000 defendant Petyte John yeoman 597727 597727 Petyte, John, of Asshedon, yeoman 0
3783196 1952498 1952498 defendant Parkyn Thomas husbandman 597727 597727 Parkyn, Thomas, of Asshedon, husbandman 0
3794149 1956038 1956038 defendant Cole John yeoman 597727 597727 Cole, John, of Asshedon, yeoman 0
3805144 1959551 1959551 defendant Coll John yeoman 597727 597727 Coll, John, of Asshedon, yeoman 0
3812698 1961864 1961864 defendant Coll John yeoman 597727 597727 Coll, John, of Asshedon, yeoman 0
3843530 1971515 1971515 defendant Cleydon Robert (legal representative) 597727 597727 Cleydon, Robert, of Asshedon, executors of 0
3843532 1971515 1971515 defendant Perkyn Thomas yeoman 597727 597727 Perkyn, Thomas, of Asshedon, yeoman 2
3900354 1990354 1990354 defendant Whithand William husbandman 597727 597727 Whithand, William, of Asshedon, husbandman 0
3911462 1994150 1994150 defendant Seybroke Thomas husbandman 597727 597727 Seybroke, Thomas, of Asshedon, husbandman 0
3950154 2007136 2007136 defendant Bocher William carpenter 597727 597727 Bocher, William, of Asshedon, carpenter 0
4089282 2056451 2056451 defendant Calton John gent 597727 597727 Calton, John, of Asshedon, gent 0
4414150 2169329 2169329 defendant Cartere Robert le   597727 597727 Cartere, Robert le, of Asshedon 4
4453647 2186154 2186154 defendant Kayle John   597727 597727 Kayle, John, of Asshedon 0
4457255 2187279 2187279 defendant Glovere John   597727 597727 Glovere, John, of Asshedon 0
4457257 2187280 2187280 defendant Glovere John   597727 597727 Glovere, John, of Asshedon 0
4569344 2222002 2222002 plaintiff Welewys Geoffrey   597727 597727 Welewys, Geoffrey, of Asshedon 0
4573384 2223208 2223208 defendant Butell John   597727 597727 Butell, John, of Asshedon 0
4602364 2231957 2231957 plaintiff Welewys Geoffrey   597727 597727 Welewys, Geoffrey, of Asshedon 0
4602365 2231957 2231957 defendant Daun Richard   597727 597727 Daun, Richard, of Asshedon, formerly parson 0
4664591 2250405 2250405 defendant Neweman William husbandman 597727 597727 Neweman, William, of Asshedon, husbandman 3
4664592 2250405 2250405 defendant Goldeston John, senior husbandman 597727 597727 Goldeston, John, senior, of Asshedon, husbandman 4
4669182 2256067 2256067 plaintiff Bocher Walter   597727 597727 Bocher, Walter, of Asshedon 0
4669183 2256067 2256067 defendant Shobyndon Thomas smith 597727 597727 Shobyndon, Thomas, of Asshedon, smith 0
4718458 2271114 2271114 defendant Lauselle John husbandman 597727 597727 Lauselle, John, of Asshedon, husbandman 2
4721011 2271907 2271907 defendant Wirkham Thomas butcher 597727 597727 Wirkham, Thomas, of Asshedon, butcher 1
4722450 2272341 2272341 plaintiff Coleston John   597727 597727 Coleston, John, of Asshedon 0
4725890 2273385 2273385 defendant Coo John husbandman 597727 597727 Coo, John, of Asshedon, husbandman 4
4729673 2274492 2274492 defendant Maryot William   597727 597727 Maryot, William, of Asshedon, parson & clerk 0
4766225 2285428 2285428 defendant Pegon John husbandman 597727 597727 Pegon, John, of Asshedon, husbandman 1
4777946 2289089 2289089 defendant Bernard John chaplain 597727 597727 Bernard, John, of Asshedon, chaplain 0
4781440 2290203 2290203 defendant Bernard John chaplain 597727 597727 Bernard, John, of Asshedon, chaplain 0
4802221 2296885 2296885 defendant Warde John husbandman 597727 597727 Warde, John, of Asshedon, husbandman 1
4810524 2299437 2299437 defendant Frebern Robert husbandman 597727 597727 Frebern, Robert, of Asshedon, husbandman 0
4811095 2299579 2299579 defendant Welwes Richard laborer 597727 597727 Welwes, Richard, of Asshedon, laborer 0
4864700 2315928 2315928 defendant Lakere John husbandman 597727 597727 Lakere, John, of Asshedon, husbandman 1
4972817 2348808 2348808 defendant Halyday Robert husbandman 597727 597727 Halyday, Robert, of Asshedon, husbandman 0
5016327 2361668 2361668 defendant Tayllour Thomas husbandman 597727 597727 Tayllour, Thomas, of Asshedon, husbandman 0
5016329 2361669 2361669 defendant Tayllour Thomas husbandman 597727 597727 Tayllour, Thomas, of Asshedon, husbandman 0
5016330 2361669 2361669 defendant Beneyt William husbandman 597727 597727 Beneyt, William, of Asshedon, husbandman 1
5063027 2375475 2375475 defendant Perkyn Thomas laborer 597727 597727 Perkyn, Thomas, of Asshedon, laborer 0
5087632 2382767 2382767 defendant Freman John husbandman 597727 597727 Freman, John, of Asshedon, husbandman 0
5128794 2394906 2394906 defendant Parkyn Thomas weaver 597727 597727 Parkyn, Thomas, of Asshedon, weaver 0
5129816 2395207 2395207 defendant Cranfeld Thomas husbandman 597727 597727 Cranfeld, Thomas, of Asshedon, husbandman 0
5129818 2395208 2395208 defendant Cranfeld Thomas husbandman 597727 597727 Cranfeld, Thomas, of Asshedon, husbandman 0
5129820 2395208 2395208 defendant Crystymas William weaver 597727 597727 Crystymas, William, of Asshedon, weaver 2
5129822 2395209 2395209 defendant Freman Edmund   597727 597727 Freman, Edmund, of Asshedon husbandman 0
5129823 2395209 2395209 defendant Parkyn Thomas weaver 597727 597727 with Parkyn, Thomas, of Asshedon, weaver 1
5129825 2395210 2395210 defendant Parkyn Thomas weaver 597727 597727 Parkyn, Thomas, of Asshedon, weaver 0
5129826 2395210 2395210 defendant Freman Edward husbandman 597727 597727 with Freman, Edward, of Asshedon, husbandman 1
5147992 2400558 2400558 defendant Freman Edmund yeoman 597727 597727 Freman, Edmund, of Asshedon, yeoman 0
5147995 2400559 2400559 defendant Freman Edmund yeoman 597727 597727 together with Freman, Edmund, of Asshedon, yeoman 1
5147996 2400559 2400559 defendant Parkyn Thomas weaver 597727 597727 Parkyn, Thomas, of Asshedon, weaver 2
5148986 2400830 2400830 defendant Bultell Thomas husbandman 597727 597727 Bultell, Thomas, of Asshedon, husbandman 0
5149008 2400838 2400838 defendant Cranefeld Thomas husbandman 597727 597727 Cranefeld, Thomas, of Asshedon, husbandman 0
5149010 2400839 2400839 defendant Cranefeld Thomas husbandman 597727 597727 Cranefeld, Thomas, of Asshedon, husbandman 0
5149012 2400840 2400840 defendant Cranefeld Thomas husbandman 597727 597727 Cranefeld, Thomas, of Asshedon, husbandman 0
5149013 2400840 2400840 defendant Crystynnes William weaver 597727 597727 Crystynnes, William, of Asshedon, weaver 1
5149014 2400840 2400840 defendant Taillour John husbandman 597727 597727 together with Taillour, John, of Asshedon, husbandman 2
5149016 2400841 2400841 defendant Cranefeld Thomas husbandman 597727 597727 Cranefeld, Thomas, of Asshedon, husbandman 0
5149017 2400841 2400841 defendant Tayllour John husbandman 597727 597727 together with Tayllour, John, of Asshedon, husbandman 1
5149018 2400841 2400841 defendant Crystymmes William weaver 597727 597727 Crystymmes, William, of Asshedon, weaver 2
5149022 2400842 2400842 defendant Tayllour John husbandman 597727 597727 Tayllour, John, of Asshedon, husbandman 2
5149027 2400844 2400844 defendant Freman Edmund husbandman 597727 597727 Freman, Edmund, of Asshedon, husbandman 0
5149028 2400844 2400844 defendant Parkyn Thomas weaver 597727 597727 together with Parkyn, Thomas, of Asshedon, weaver 1
5149030 2400845 2400845 defendant Freman Edmund husbandman 597727 597727 Freman, Edmund, of Asshedon, husbandman 0
5149031 2400845 2400845 defendant Parkyn Thomas weaver 597727 597727 together with Parkyn, Thomas, of Asshedon, weaver 1
5173016 2407820 2407820 defendant Freman Edmund husbandman 597727 597727 Freman, Edmund, of Asshedon, husbandman 0
5173021 2407820 2407820 defendant Perkyns Thomas weaver 597727 597727 Perkyns, Thomas, of Asshedon, weaver 5
5183890 2411025 2411025 defendant Bultell Thomas husbandman 597727 597727 Bultell, Thomas, of Asshedon, husbandman 0
5183892 2411026 2411026 defendant Langdale John husbandman 597727 597727 Langdale, John, of Asshedon, husbandman 0
5192755 2413612 2413612 defendant Freman Edmund husbandman 597727 597727 Freman, Edmund, of Asshedon, husbandman 0
5197950 2415144 2415144 defendant Freman Edmund husbandman 597727 597727 Freman, Edmund, of Asshedon, husbandman 0
5204062 2416937 2416937 defendant Bultell Thomas husbandman 597727 597727 Bultell, Thomas, of Asshedon, husbandman 0
5276988 2438350 2438350 defendant Cranefeld John husbandman 597727 597727 Cranefeld, John, of Asshedon, husbandman 0
5288634 2441696 2441696 defendant Cranefeld Thomas husbandman 597727 597727 Cranefeld, Thomas, of Asshedon, husbandman 0
5326802 2453086 2453086 defendant Austyn John husbandman 597727 597727 Austyn, John, of Asshedon, husbandman 0
5468895 2495625 2495625 defendant Freman William husbandman 597727 597727 Freman, William, of Asshedon, husbandman 0
5468896 2495625 2495625 defendant Freman John husbandman 597727 597727 Freman, John, of Asshedon, husbandman 1
5486995 2501004 2501004 defendant Hoord John laborer 597727 597727 Hoord, John, of Asshedon, laborer 4
5501497 2505403 2505403 defendant Herde John, senior sawyer 597727 597727 Herde, John, senior, of Asshedon, sawyer 4
5501503 2505404 2505404 defendant Herde John, senior sawyer 597727 597727 Herde, John, senior, of Asshedon, sawyer 4

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