names

30 rows where place_id = 590494

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3601392 1868097 1868097 defendant Folwod James husbandman 590494 590494 Folwod, James, of Ripley, husbandman 5
3617495 1873092 1873092 defendant Laurens John innholder 590494 590494 Laurens, John, of Ripley, innholder 1
3661922 1914018 1914018 defendant Slifeld Edward gent 590494 590494 Slifeld, Edward, of Ripley, gent 6
3661923 1914018 1914018 defendant Alderton Richard yeoman 590494 590494 Alderton, Richard, of Ripley, yeoman 7
3689286 1922812 1922812 defendant Johnson Margaret widow 590494 590494 Johnson, Margaret, of Ripley, widow 1
3694279 1924414 1924414 defendant Maxwell William yeoman 590494 590494 Maxwell, William, of Ripley, yeoman 2
3700350 1926348 1926348 defendant Maxwell William yeoman 590494 590494 Maxwell, William, of Ripley, yeoman 2
3714374 1930793 1930793 defendant Braithwait George yeoman 590494 590494 Braithwait, George, of Ripley, yeoman 0
3714375 1930793 1930793 defendant Braithwait Christopher yeoman 590494 590494 Braithwait, Christopher, of Ripley, yeoman 1
3802600 1958706 1958706 defendant Heldon Robert yeoman 590494 590494 Heldon, Robert, of Ripley, yeoman 3
4036752 2037832 2037832 plaintiff Ingleby William   590494 590494 Ingleby, William, of Ripley, knight 0
4036756 2037834 2037834 plaintiff Inglebye William   590494 590494 Inglebye, William, of Ripley, knight 0
4166634 2083827 2083827 defendant Wylley Ralph (legal representative) 590494 590494 Wylley, Ralph, of Ripley, yeoman, executrix of 0
4183456 2089692 2089692 defendant Hall William yeoman 590494 590494 Hall, William, of Ripley, yeoman 1
4318338 2136521 2136521 defendant Lewes Geoffrey laborer 590494 590494 Lewes, Geoffrey, of Ripley, laborer 0
4318339 2136521 2136521 defendant Bell Jenetta spinster 590494 590494 Bell, Jenetta, of Ripley, spinster 1
4322041 2137790 2137790 defendant Swore Francis yeoman 590494 590494 Swore Francis, of Ripley, yeoman 0
4930960 2336079 2336079 defendant Randhurst Thomas yeoman 590494 590494 Randhurst, Thomas, of Ripley, yeoman 1
5062298 2375285 2375285 defendant Award Richard chaplain 590494 590494 Award, Richard, of Ripley, chaplain 0
5143050 2399093 2399093 defendant Belford Thomas gent 590494 590494 Belford, Thomas, of Ripley, gent 0
5145558 2399845 2399845 defendant Anteknep William weaver 590494 590494 Anteknep, William, of Ripley, weaver 4
5165944 2405784 2405784 defendant Auteknep William weaver 590494 590494 Auteknep, William, of Ripley, weaver 4
5180603 2410069 2410069 defendant Auteknep William weaver 590494 590494 Auteknep, William, of Ripley, weaver 4
5180609 2410070 2410070 defendant Auteknep William weaver 590494 590494 Auteknep, William, of Ripley, weaver 4
5346367 2459008 2459008 defendant Wryght Thomas laborer 590494 590494 Wryght, Thomas, of Ripley, laborer 2
5528338 2513414 2513414 defendant Ingilby William   590494 590494 Ingilby, William, of Ripley, knight 4
5532787 2514806 2514806 defendant Fulwodde James husbandman 590494 590494 Fulwodde, James, of Ripley, husbandman 4
5588165 2531305 2531305 defendant Stapulton Henry clerk 590494 590494 Stapulton, Henry, of Ripley, clerk 0
5603385 2535945 2535945 defendant Stapilton Henry clerk 590494 590494 Stapilton, Henry, of Ripley, clerk 0
5603387 2535946 2535946 defendant Maxwell John yeoman 590494 590494 Maxwell, John, of Ripley, yeoman 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);