names

39 rows where place_id = 593049

✎ 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
3610208 1870857 1870857 defendant Neuton John gent 593049 593049 Neuton, John, of North Muskham, gent 0
3807287 1960177 1960177 defendant Spaynyng John yeoman 593049 593049 Spaynyng, John, of North Muskham, yeoman 0
3837926 1969774 1969774 defendant Clerke William husbandman 593049 593049 Clerke, William, of North Muskham, husbandman 0
3938382 2003178 2003178 defendant Haryson Thomas husbandman 593049 593049 Haryson, Thomas, of North Muskham, husbandman 1
4030801 2035681 2035681 defendant Ireland Nicholas yeoman 593049 593049 Ireland, Nicholas, of North Muskham, yeoman 0
4161873 2082223 2082223 defendant Ireland Nicholas husbandman 593049 593049 Ireland, Nicholas, of North Muskham, husbandman 0
4161874 2082223 2082223 defendant Clerk William smith 593049 593049 Clerk, William, of North Muskham, smith 1
4185205 2090333 2090333 defendant Leverton Edward yeoman 593049 593049 Leverton, Edward, of North Muskham, yeoman 0
4185206 2090333 2090333 defendant Barton Francis laborer 593049 593049 Barton, Francis, of North Muskham, laborer 1
4188601 2091493 2091493 defendant Gounthorpe Edward husbandman 593049 593049 Gounthorpe, Edward, of North Muskham, husbandman 0
4211477 2099570 2099570 defendant Merynge Peter gent 593049 593049 Merynge, Peter, of North Muskham, gent 1
4418521 2170669 2170669 plaintiff Wyget Simon   593049 593049 Wyget, Simon, of North Muskham, son of Henry 0
4430212 2174228 2174228 plaintiff Wygot Simon   593049 593049 Wygot, Simon, of North Muskham, son of henry 0
4430213 2174228 2174228 defendant Milner Robert chaplain 593049 593049 Milner, Robert, of North Muskham, chaplain 0
4430214 2174229 2174229 plaintiff Wygot Simon   593049 593049 Wygot, Simon, of North Muskham, son of Henry 0
4437621 2176523 2176523 plaintiff Wygot Simon   593049 593049 Wygot, Simon, of North Muskham, son of Henry 0
4502300 2201311 2201311 plaintiff Lysure John   593049 593049 (Lysure, John, of North Muskham 1
4641646 2243658 2243658 defendant Clerk Robert   593049 593049 Clerk, Robert, of North Muskham 0
4663939 2250205 2250205 defendant Alkeley John husbandman 593049 593049 Alkeley, John, of North Muskham, husbandman 2
4663940 2250205 2250205 defendant del Hill John laborer 593049 593049 del Hill, John, of North Muskham, laborer 3
4673026 2257208 2257208 defendant Homerton Thomas   593049 593049 Homerton, Thomas, of North Muskham, bailiff 0
4673028 2257208 2257208 defendant Hokerton Robert   593049 593049 Hokerton, Robert, of North Muskham, chaplain, formerly parish clerk 2
4678340 2258833 2258833 defendant Hokerton Thomas   593049 593049 Hokerton, Thomas, of North Muskham, bailiff 2
4678341 2258833 2258833 defendant Hokerton John husbandman 593049 593049 Hokerton, John, of North Muskham, husbandman 3
4742742 2278383 2278383 defendant Hokerton William husbandman 593049 593049 Hokerton, William, of North Muskham, husbandman 1
4742743 2278383 2278383 defendant Hokerton John husbandman 593049 593049 Hokerton, John, of North Muskham, husbandman 2
4742744 2278383 2278383 defendant Mapilthorp Thomas husbandman 593049 593049 Mapilthorp, Thomas, of North Muskham, husbandman 3
4766288 2285449 2285449 defendant Appilton Robert (legal representative) 593049 593049 Appilton, Robert, of North Muskham, executor of 0
4810769 2299491 2299491 defendant Homerton William husbandman 593049 593049 Homerton, William, of North Muskham, husbandman 0
4814731 2300724 2300724 defendant Alkelay John weaver 593049 593049 Alkelay, John, of North Muskham, weaver 0
4838936 2308111 2308111 defendant Hokerton William husbandman 593049 593049 Hokerton, William, of North Muskham, husbandman 0
4886500 2322640 2322640 defendant Feryman John yeoman 593049 593049 Feryman, John, of North Muskham, yeoman 0
4886501 2322640 2322640 defendant Alkeley John husbandman 593049 593049 Alkeley, John, of North Muskham, husbandman 1
4950329 2342068 2342068 defendant Barbour John yeoman 593049 593049 Barbour, John, of North Muskham, yeoman 0
4994565 2355237 2355237 defendant Barbour John yeoman 593049 593049 Barbour, John, of North Muskham, yeoman 2
5165719 2405718 2405718 defendant Burges Nicholas husbandman 593049 593049 Burges, Nicholas, of North Muskham, husbandman 0
5361285 2463552 2463552 defendant Taillour Richard yeoman 593049 593049 Taillour, Richard, of North Muskham, yeoman 15
5598909 2534535 2534535 defendant Sowrby William clerk 593049 593049 Sowrby, William, of North Muskham, clerk 3
5625389 2551879 2551879 plaintiff Lysurs John   593049 593049 Lysurs, John, of North Muskham 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);