names

39 rows where place_id = 589319

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597216 1866753 1866753 defendant Prynchet Thomas weaver 589319 589319 Prynchet, Thomas, of Chellysworth, weaver 3
3630225 1904302 1904302 defendant Newport William fuller 589319 589319 Newport, William, of Chellysworth, fuller 2
3630226 1904302 1904302 defendant Bonde Richard husbandman 589319 589319 Bonde, Richard, of Chellysworth, husbandman 3
3632516 1904988 1904988 defendant Wythe John husbandman 589319 589319 Wythe, John, of Chellysworth, husbandman 3
3632521 1904989 1904989 defendant Wythe John husbandman 589319 589319 Wythe, John, of Chellysworth, husbandman 3
3648947 1910059 1910059 defendant Mowese William husbandman 589319 589319 Mowese, William, of Chellysworth, husbandman 2
3710039 1929451 1929451 defendant Clark John fuller 589319 589319 Clark, John, of Chellysworth, fuller 0
3724617 1933982 1933982 defendant Bonde Richard husbandman 589319 589319 Bonde, Richard, of Chellysworth, husbandman 0
3728796 1935253 1935253 defendant Pollyng John weaver 589319 589319 Pollyng, John, of Chellysworth, weaver 0
3740535 1938898 1938898 defendant Bonde Richard laborer 589319 589319 Bonde, Richard, of Chellysworth, laborer 3
3743717 1939917 1939917 defendant Smyth Robert smith 589319 589319 Smyth, Robert, of Chellysworth, smith 0
3805138 1959550 1959550 defendant Pollynge William weaver 589319 589319 Pollynge, William, of Chellysworth, weaver 0
3805139 1959550 1959550 defendant Marchaunt John husbandman 589319 589319 Marchaunt, John, of Chellysworth, husbandman 1
3805140 1959550 1959550 defendant Wythe John husbandman 589319 589319 Wythe, John, of Chellysworth, husbandman 2
3836402 1969294 1969294 defendant Smyth John husbandman 589319 589319 Smyth, John, of Chellysworth, husbandman 1
3852483 1974383 1974383 defendant Smyth John husbandman 589319 589319 Smyth, John, of Chellysworth, husbandman 1
3866696 1979095 1979095 defendant Welle Henry laborer 589319 589319 Welle, Henry, of Chellysworth, laborer 1
3882105 1984273 1984273 defendant Pavys alias Dey Robert clerk 589319 589319 Pavys alias Dey, Robert, of Chellysworth, clerk 0
4672273 2256976 2256976 plaintiff Porter John   589319 589319 Porter, John, of Chellysworth 2
4934936 2337330 2337330 defendant Wynter William husbandman 589319 589319 Wynter, William, of Chellysworth, husbandman 3
4969967 2347967 2347967 defendant Prynchett Robert fuller 589319 589319 Prynchett, Robert, of Chellysworth, fuller 2
5033723 2366741 2366741 defendant Conyver William miller 589319 589319 Conyver, William, of Chellysworth, miller 1
5059235 2374328 2374328 defendant Gerard Robert laborer 589319 589319 Gerard, Robert, of Chellysworth, laborer 0
5059236 2374328 2374328 defendant Heyward Edward laborer 589319 589319 Heyward, Edward, of Chellysworth, laborer 1
5059238 2374328 2374328 defendant Prynchet Robert husbandman 589319 589319 Prynchet, Robert, of Chellysworth, husbandman 3
5064078 2375790 2375790 defendant Porter John dyer 589319 589319 Porter, John, of Chellysworth, dyer 2
5066903 2376626 2376626 defendant Porter John dyer 589319 589319 Porter, John, of Chellysworth, dyer 2
5072975 2378405 2378405 defendant Porter John dyer 589319 589319 Porter, John, of Chellysworth, dyer 0
5072976 2378405 2378405 defendant Kendale Simon weaver 589319 589319 Kendale, Simon, of Chellysworth, weaver 1
5233040 2425244 2425244 defendant Mouse Thomas husbandman 589319 589319 Mouse, Thomas, of Chellysworth, husbandman 0
5334690 2455439 2455439 defendant Vyne Thomas weaver 589319 589319 Vyne, Thomas, of Chellysworth, weaver 0
5346106 2458920 2458920 defendant Prynchet John husbandman 589319 589319 Prynchet, John, of Chellysworth, husbandman 0
5346107 2458920 2458920 defendant Chemyngton Walter weaver 589319 589319 Chemyngton, Walter, of Chellysworth, weaver 1
5346108 2458920 2458920 defendant Fyn William weaver 589319 589319 Fyn, William, of Chellysworth, weaver 2
5355510 2461796 2461796 defendant Prynchet John weaver 589319 589319 Prynchet, John, of Chellysworth, weaver 1
5355511 2461796 2461796 defendant Taleour Thomas yeoman 589319 589319 Taleour, Thomas, of Chellysworth, yeoman 2
5355512 2461796 2461796 defendant Heyward John yeoman 589319 589319 Heyward, John, of Chellysworth, yeoman 3
5596751 2533901 2533901 defendant Alden John baker 589319 589319 Alden, John, of Chellysworth, baker 1
5609395 2537840 2537840 defendant Hawelet John dyer 589319 589319 Hawelet, John, of Chellysworth, dyer 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);