names

33 rows where place_id = 602994

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3652620 1911155 1911155 defendant Coton Thomas esq 602994 602994 Coton, Thomas, of Conyngton, esq 0
3782753 1952351 1952351 defendant Toweslond William husbandman 602994 602994 Toweslond, William, of Conyngton, husbandman 0
3873083 1981215 1981215 defendant Harrys John husbandman 602994 602994 Harrys, John, of Conyngton, husbandman 0
4331302 2140764 2140764 defendant Watson Simon gent 602994 602994 Watson, Simon, of Conyngton, gent 1
4354285 2148729 2148729 defendant Norton Thomas gent 602994 602994 Norton, Thomas, of Conyngton, gent 0
4450681 2185172 2185172 defendant Froman William   602994 602994 Froman, William, of Conyngton 0
4477559 2193649 2193649 defendant Burwell William   602994 602994 Burwell, William, of Conyngton 3
4493172 2198567 2198567 defendant Warkere Geoffrey   602994 602994 Warkere, Geoffrey, of Conyngton 0
4514060 2204821 2204821 defendant Borewell William   602994 602994 Borewell, William, of Conyngton 3
4550093 2215969 2215969 defendant Bittrusht John   602994 602994 Bittrusht, John, of Conyngton 0
4556730 2218039 2218039 defendant Stevenesson Henry   602994 602994 Stevenesson, Henry, of Conyngton 0
4590505 2228393 2228393 defendant Dowe John   602994 602994 Dowe, John, of Conyngton 0
4637196 2242431 2242431 defendant Thomson William   602994 602994 Thomson, William, of Conyngton 1
4637198 2242431 2242431 defendant Shepherd Robert   602994 602994 Shepherd, Robert, of Conyngton 3
4649633 2245923 2245923 defendant Busshe John   602994 602994 Busshe, John, of conyngton 1
4649639 2245924 2245924 defendant Busshe John   602994 602994 Busshe, John, of Conyngton 1
4669535 2256177 2256177 defendant Bussh John laborer 602994 602994 Bussh, John, of Conyngton, laborer 0
4673595 2257373 2257373 defendant Elyngham Joan gentlewoman 602994 602994 Elyngham, Joan, of Conyngton, gentlewoman 1
4683164 2260350 2260350 defendant Hemingford Thomas husbandman 602994 602994 Hemingford, Thomas, of Conyngton, husbandman 3
4698616 2265044 2265044 defendant Bailly Thomas husbandman 602994 602994 Bailly, Thomas, of Conyngton, husbandman 1
4715837 2270267 2270267 defendant Dauscy William gent 602994 602994 Dauscy, William, of Conyngton, gent 0
4741686 2278061 2278061 defendant Ordemare John husbandman 602994 602994 Ordemare, John, of Conyngton, husbandman 0
4893406 2324640 2324640 defendant Crane John husbandman 602994 602994 Crane, John, of Conyngton, husbandman 1
5021997 2363325 2363325 defendant Boys John yeoman 602994 602994 Boys, John, of Conyngton, or of Pottespury, yeoman 0
5074039 2378724 2378724 defendant Chapman William yeoman 602994 602994 Chapman, William, of Conyngton, yeoman 1
5114779 2390735 2390735 defendant Burgelyn John husbandman 602994 602994 Burgelyn, John, of Conyngton, husbandman 3
5234842 2425775 2425775 defendant Hardewyn Robert husbandman 602994 602994 Hardewyn, Robert, of Conyngton, husbandman 0
5282108 2439840 2439840 defendant Smyth Henry yeoman 602994 602994 Smyth, Henry, of Conyngton, yeoman 3
5282135 2439846 2439846 defendant Smythe Henry yeoman 602994 602994 Smythe, Henry, of Conyngton, yeoman 3
5289150 2441832 2441832 defendant Maryot John smith 602994 602994 Maryot, John, of Conyngton, smith 1
5379238 2469101 2469101 defendant Okynden Nicholas husbandman 602994 602994 Okynden, Nicholas, of Conyngton, husbandman 0
5613107 2547877 2547877 defendant Nichol Walter   602994 602994 Nichol, Walter, of Conyngton 0
5616178 2548852 2548852 defendant Cook John chaplain 602994 602994 Cook, John, of Conyngton, chaplain 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);