names

33 rows where place_id = 648290

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3900900 1990530 1990530 defendant Browne John yeoman 648290 648290 Browne, John, of Swayton, yeoman 1
4222679 2103423 2103423 defendant Carrington Richard clerk 648290 648290 Carrington, Richard, of Swayton, clerk 0
4233343 2107175 2107175 defendant Middleton John yeoman 648290 648290 Middleton, John, of Swayton, yeoman 0
4235163 2107858 2107858 defendant Walcott William husbandman 648290 648290 Walcott, William, of Swayton, husbandman 0
4239773 2109542 2109542 defendant Allen Hugh (legal representative) 648290 648290 Allen, Hugh, of Swayton, husbandman, administratrix of 0
4239774 2109542 2109542 defendant Allen Agnes widow 648290 648290 Allen, Agnes, of Swayton, widow 1
4251561 2113505 2113505 defendant Middleton John yeoman 648290 648290 Middleton, John, of Swayton, yeoman 0
4251563 2113506 2113506 defendant Walcott William yeoman 648290 648290 Walcott, William, of Swayton, yeoman 0
4265409 2118070 2118070 defendant Walcott William yeoman 648290 648290 Walcott, William, of Swayton, yeoman 0
4265410 2118070 2118070 defendant Walcott Robert yeoman 648290 648290 Walcott, Robert, of Swayton, yeoman 1
4265411 2118070 2118070 defendant Braunston Thomas husbandman 648290 648290 Braunston, Thomas, of Swayton, husbandman 2
4267144 2118650 2118650 defendant Gee Thomas yeoman 648290 648290 Gee, Thomas, of Swayton, yeoman 0
4267146 2118651 2118651 defendant Walcott William husbandman 648290 648290 Walcott, William, of Swayton, husbandman 0
4275581 2121402 2121402 defendant Myddleton John yeoman 648290 648290 Myddleton, John, of Swayton, yeoman 0
4275848 2121503 2121503 defendant Myddleton William gent 648290 648290 Myddleton, William, of Swayton, gent 0
4275849 2121503 2121503 defendant Myddleton John yeoman 648290 648290 Myddleton, John, of Swayton, yeoman 1
4275850 2121503 2121503 defendant Myddleton Anne widow 648290 648290 Myddleton, Anne, of Swayton, widow 2
4275854 2121505 2121505 defendant Walcott William yeoman 648290 648290 Walcott, William, of Swayton, yeoman 0
4275855 2121505 2121505 defendant Hoggeston Edward blacksmith 648290 648290 Hoggeston, Edward, of Swayton, blacksmith 1
4275856 2121505 2121505 defendant Jackson Anthony husbandman 648290 648290 Jackson, Anthony, of Swayton, husbandman 2
4279829 2122861 2122861 defendant Ulliott John laborer 648290 648290 Ulliott, John, of Swayton, laborer 0
4280108 2122953 2122953 defendant Browne Francis husbandman 648290 648290 Browne, Francis, of Swayton, husbandman 0
4280113 2122954 2122954 defendant Browen Francis husbandman 648290 648290 together with Browen, Francis, of Swayton, husbandman 3
4336538 2142516 2142516 defendant Midleton William gent 648290 648290 Midleton, William, of Swayton, gent 3
4347627 2146419 2146419 defendant Walcott William yeoman 648290 648290 Walcott, William, of Swayton, yeoman 0
4356087 2149351 2149351 defendant Walcott William junior husbandman 648290 648290 Walcott, William junior, of Swayton, husbandman 0
4356088 2149351 2149351 defendant Pyckworth Christopher butcher 648290 648290 Pyckworth, Christopher, of Swayton, butcher 1
4356271 2149418 2149418 defendant Carrington Richard clerk 648290 648290 Carrington, Richard, of Swayton, clerk 0
4356273 2149419 2149419 defendant Carrington Richard clerk 648290 648290 Carrington, Richard, of Swayton, clerk 0
4370973 2154675 2154675 defendant Clarke alias Osborne Thomas laborer 648290 648290 Clarke alias Osborne, Thomas, of Swayton, laborer 0
4372747 2155329 2155329 defendant Ullyett John laborer 648290 648290 Ullyett, John, of Swayton, laborer 0
4380023 2157957 2157957 defendant Midleton William gent 648290 648290 Midleton, William, of Swayton, gent 1
4380288 2158054 2158054 defendant Ullyott John laborer 648290 648290 Ullyott, John, of Swayton, laborer 2

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