names

46 rows where place_id = 612454

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3693348 1924133 1924133 defendant Sewyn William husbandman 612454 612454 Sewyn, William, of Wynfarthyng, husbandman 2
3702456 1927030 1927030 plaintiff Clark Robert mercer 612454 612454 Clark, Robert, of Wynfarthyng, mercer 0
3702458 1927030 1927030 defendant Rose Robert husbandman 612454 612454 Rose, Robert, of Wynfarthyng, husbandman 1
3705645 1928047 1928047 defendant Halett John husbandman 612454 612454 Halett, John, of Wynfarthyng, husbandman 0
3712324 1930171 1930171 defendant Alleyate John husbandman 612454 612454 Alleyate, John, of Wynfarthyng, husbandman 1
3739828 1938674 1938674 defendant Goos William   612454 612454 Goos, William, of Wynfarthyng, wheelwright 0
3840233 1970513 1970513 plaintiff Alden John gent 612454 612454 Alden, John, of Wynfarthyng, gent 0
3842832 1971292 1971292 defendant Hobard John butcher 612454 612454 Hobard, John, of Wynfarthyng, butcher 1
3843507 1971506 1971506 plaintiff Clerke Robert   612454 612454 Clerke, Robert, of Wynfarthyng 1
3847150 1972662 1972662 plaintiff Halyat alias Elyat alias Clerke John (legal representative) 612454 612454 Halyat alias Elyat alias Clerke, John, of Wynfarthyng, administrator of 0
3856991 1975821 1975821 plaintiff Alden John   612454 612454 Alden, John, of Wynfarthyng 0
3856996 1975822 1975822 plaintiff Alden Robert cooper 612454 612454 Alden, Robert, of Wynfarthyng, cooper 0
3856999 1975822 1975822 defendant Broun John   612454 612454 Broun, John, of Wynfarthyng, wheelwright 2
3857007 1975825 1975825 plaintiff Alden Thomas   612454 612454 Alden, Thomas, of Wynfarthyng 0
3857848 1976094 1976094 plaintiff Baron Robert   612454 612454 Baron, Robert, of Wynfarthyng 0
3857849 1976094 1976094 plaintiff Alden John   612454 612454 Alden, John, of Wynfarthyng 1
3869581 1980066 1980066 plaintiff Warner Robert   612454 612454 Warner, Robert, of Wynfarthyng 0
3871934 1980847 1980847 plaintiff Baron Robert   612454 612454 Baron, Robert, of Wynfarthyng, knight 0
3871935 1980847 1980847 plaintiff Alden John   612454 612454 Alden, John, of Wynfarthyng, knight 1
3873820 1981465 1981465 plaintiff Clerke Robert   612454 612454 Clerke, Robert, of Wynfarthyng 1
3873825 1981466 1981466 plaintiff Clerke Robert   612454 612454 Clerke, Robert, of Wynfarthyng 1
3878150 1982941 1982941 defendant Clerke Robert husbandman 612454 612454 Clerke, Robert, of Wynfarthyng, husbandman 2
3878700 1983124 1983124 defendant Goose William   612454 612454 Goose, William, of Wynfarthyng, wheelwright 0
3883048 1984597 1984597 defendant Goos William   612454 612454 Goos, William, of Wynfarthyng, wheelwright 1
3886244 1985652 1985652 plaintiff Broun Robert carpenter 612454 612454 Broun, Robert, of Wynfarthyng, carpenter 0
3901107 1990597 1990597 plaintiff Clerke Robert   612454 612454 Clerke, Robert, of Wynfarthyng 0
3901113 1990598 1990598 plaintiff Clerke Robert   612454 612454 Clerke, Robert, of Wynfarthyng 0
3914825 1995306 1995306 plaintiff Clerk Robert   612454 612454 Clerk, Robert, of Wynfarthyng 0
3929939 2000356 2000356 plaintiff Clarke Robert mercer 612454 612454 Clarke, Robert, of Wynfarthyng, mercer 0
3968630 2013667 2013667 plaintiff Clerke Robert (legal representative) 612454 612454 Clerke, Robert, of Wynfarthyng, mercer, administrator of 0
3993989 2022602 2022602 plaintiff Clarke Robert (legal representative) 612454 612454 Clarke, Robert, of Wynfarthyng, mercer, administrator of 0
3994158 2022662 2022662 plaintiff Clerke Robert (legal representative) 612454 612454 Clerke, Robert, of Wynfarthyng, mercer, administrator of 0
3994161 2022663 2022663 plaintiff Clerke Robert   612454 612454 Clerke, Robert, of Wynfarthyng 0
4055693 2044425 2044425 defendant Havers Thomas gent 612454 612454 Havers, Thomas, of Wynfarthyng, gent 0
4055694 2044425 2044425 defendant Hallatt Mathew gent 612454 612454 Hallatt, Mathew, of Wynfarthyng, gent 1
4055695 2044425 2044425 defendant Alden Thomas gent 612454 612454 Alden, Thomas, of Wynfarthyng, gent 2
4055696 2044425 2044425 defendant Alden John gent 612454 612454 Alden, John, of Wynfarthyng, gent 3
4062874 2047022 2047022 defendant Spencer Humphrey   612454 612454 Spencer, Humphrey, of Wynfarthyng, pale maker 1
4072399 2050432 2050432 defendant Vardyn Richard husbandman 612454 612454 Vardyn, Richard, of Wynfarthyng, husbandman 0
4072779 2050564 2050564 defendant Verdyn Edward husbandman 612454 612454 Verdyn, Edward, of Wynfarthyng, husbandman 2
4081179 2053578 2053578 defendant Crane George   612454 612454 Crane, George, of Wynfarthyng, horse courser 2
4084044 2054569 2054569 defendant Coo James   612454 612454 Coo, James, of Wynfarthyng, pale maker 0
4093710 2058075 2058075 defendant Havers Thomas gent 612454 612454 Havers, Thomas, of Wynfarthyng, gent 0
4314805 2135289 2135289 defendant Johnson Thomas husbandman 612454 612454 Johnson, Thomas, of Wynfarthyng, husbandman 3
4348771 2146830 2146830 defendant Puddinge Michael yeoman 612454 612454 Puddinge, Michael, of Wynfarthyng, yeoman 1
4382547 2158870 2158870 defendant James John, junior   612454 612454 James, John, junior, of Wynfarthyng, pale maker 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);