names

46 rows where place_id = 597418

✎ 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
3628488 1903779 1903779 defendant Rokis John yeoman 597418 597418 Rokis, John, of Calverton, yeoman 2
3644661 1908737 1908737 defendant Warener William   597418 597418 Warener, William, of Calverton, "larper" 0
3667285 1915705 1915705 defendant Page William gent 597418 597418 Page, William, of Calverton, gent 1
3675369 1918334 1918334 defendant Cowper Robert glover 597418 597418 Cowper, Robert, of Calverton, glover 0
3682475 1920620 1920620 defendant Page William gent 597418 597418 Page, William, of Calverton, gent 0
3741799 1939299 1939299 defendant Bek Thomas husbandman 597418 597418 Bek, Thomas, of Calverton, husbandman 0
3774658 1949803 1949803 defendant Waren William harper 597418 597418 Waren, William, of Calverton, harper 0
3774660 1949804 1949804 defendant Waren William harper 597418 597418 Waren, William, of Calverton, harper 0
3864242 1978233 1978233 defendant Strelley James gent 597418 597418 Strelley, James, of Calverton, gent 0
4216664 2101322 2101322 defendant Godfrey John husbandman 597418 597418 Godfrey, John, of Calverton, husbandman 0
4414975 2169576 2169576 defendant Geffrey Robert   597418 597418 Geffrey, Robert, of Calverton 0
4423712 2172259 2172259 defendant Gunthorp John de   597418 597418 Gunthorp, John de, of Calverton 0
4423713 2172259 2172259 defendant Wyther William   597418 597418 Wyther, William, of Calverton 1
4438192 2181243 2181243 defendant Gebbe Roger   597418 597418 Gebbe, Roger, of Calverton 4
4438200 2181245 2181245 defendant Wattenowe Sampsone   597418 597418 Wattenowe, Sampsone, of Calverton 2
4439218 2181543 2181543 defendant Gebbe Roger   597418 597418 Gebbe, Roger, of Calverton 4
4439226 2181545 2181545 defendant Watenowe John de   597418 597418 Watenowe, John de, of Calverton 2
4462547 2188982 2188982 defendant Broun William   597418 597418 Broun, William, of Calverton, parson 0
4558290 2218535 2218535 defendant Broun William   597418 597418 together with Broun, William, of Calverton 1
4558291 2218535 2218535 defendant Clerk Thomas   597418 597418 Clerk, Thomas, of Calverton, holy water clerk 2
4592557 2229025 2229025 defendant Broun William   597418 597418 Broun, William, of Calverton, parson 0
4704161 2266679 2266679 defendant Thorp Henry de yeoman 597418 597418 Thorp, Henry de, of Calverton, yeoman 2
4774622 2288051 2288051 defendant Thorp Henry husbandman 597418 597418 Thorp, Henry, of Calverton, husbandman 0
4815199 2300865 2300865 defendant Godfrey Henry husbandman 597418 597418 Godfrey, Henry, of Calverton, husbandman 0
4815200 2300865 2300865 defendant Godgrey John husbandman 597418 597418 Godgrey, John, of Calverton, husbandman 1
4868158 2317017 2317017 defendant Adamson John, senior husbandman 597418 597418 Adamson, John, senior, of Calverton, husbandman 0
4868159 2317017 2317017 defendant Adamson John, junior husbandman 597418 597418 Adamson, John, junior, of Calverton, husbandman 1
4868160 2317017 2317017 defendant Launley John husbandman 597418 597418 Launley, John, of Calverton, husbandman 2
4868161 2317017 2317017 defendant Scotte Richard husbandman 597418 597418 Scotte, Richard, of Calverton, husbandman 3
4892412 2324367 2324367 defendant Davy John husbandman 597418 597418 Davy, John, of Calverton, husbandman 1
4937077 2337967 2337967 defendant Davy John husbandman 597418 597418 Davy, John, of Calverton, husbandman 0
4949008 2341677 2341677 defendant Browenyng William husbandman 597418 597418 Browenyng, William, of Calverton, husbandman 3
5011690 2360268 2360268 defendant Chambre William husbandman 597418 597418 Chambre, William, of Calverton, husbandman 2
5092659 2384233 2384233 defendant Horneclyff Robert husbandman 597418 597418 Horneclyff, Robert, of Calverton, husbandman 0
5092663 2384233 2384233 defendant Leek Robert   597418 597418 Leek, Robert, of Calverton, wright 4
5092665 2384234 2384234 defendant Morehouse Robert husbandman 597418 597418 Morehouse, Robert, of Calverton, husbandman 0
5092666 2384234 2384234 defendant Gebbe William husbandman 597418 597418 Gebbe, William, of Calverton, husbandman 1
5092667 2384234 2384234 defendant Fox John husbandman 597418 597418 Fox, John, of Calverton, husbandman 2
5228376 2423907 2423907 defendant Morehouse alias Fleccher Robert yeoman or fletcher 597418 597418 Morehouse alias Fleccher, Robert, of Calverton, yeoman or fletcher 10
5228377 2423907 2423907 defendant Gebbe Thomas husbandman 597418 597418 Gebbe, Thomas, of Calverton, husbandman 11
5246489 2429134 2429134 defendant Lamley John husbandman 597418 597418 Lamley, John, of Calverton, husbandman 10
5272639 2437072 2437072 defendant Stabull Thomas yeoman 597418 597418 Stabull, Thomas, of Calverton, yeoman 1
5284744 2440553 2440553 defendant Warner Reginald yeoman 597418 597418 Warner, Reginald, of Calverton, yeoman 0
5335869 2455796 2455796 defendant Haward Thomas husbandman 597418 597418 Haward, Thomas, of Calverton, husbandman 3
5393011 2473073 2473073 plaintiff Somervyle John (legal representative) 597418 597418 Somervyle, John, of Calverton, Master, executors of 0
5622369 2550918 2550918 defendant Chestrefeld Roger de   597418 597418 Chestrefeld, Roger de, of Calverton, parson 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);