names

80 rows where place_id = 589720

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598498 1867158 1867158 defendant Hynes Thomas cooper 589720 589720 Hynes, Thomas, of Stanes, Middx, cooper 3
3598503 1867159 1867159 defendant Hynes Thomas cooper 589720 589720 Hynes, Thomas, of Stanes, Middx, cooper 3
3618012 1873253 1873253 defendant Gough John beer brewer 589720 589720 Gough, John, of Stanes, Middx, beer brewer 1
3618469 1873402 1873402 defendant Layseter William yeoman 589720 589720 Layseter, William, of Stanes, Middx, yeoman 0
3635802 1905998 1905998 defendant Chamber William innholder 589720 589720 Chamber, William, of Stanes, Middx, innholder 1
3864442 1978305 1978305 defendant Monne Nicholas innholder 589720 589720 Monne, Nicholas, of Stanes, Middx, innholder 1
3864445 1978306 1978306 defendant Monne Nicholas innholder 589720 589720 Monne, Nicholas, of Stanes, Middx, innholder 1
3914161 1995080 1995080 defendant Sonford Thomas yeoman 589720 589720 Sonford, Thomas, of Stanes, Middx, yeoman 1
3919035 1996692 1996692 plaintiff Jones Geoffrey (legal representative) 589720 589720 Jones, Geoffrey, of Stanes, Middx, executrix of 0
3996157 2023379 2023379 defendant Holmes William yteoman 589720 589720 Holmes, William, of Stanes, Middx, yteoman 2
3998189 2024099 2024099 defendant Warde Thomas miller 589720 589720 Warde, Thomas, of Stanes, Middx, miller 0
3998193 2024100 2024100 defendant Warde Thomas miller 589720 589720 Warde, Thomas, of Stanes, Middx, miller 0
4004025 2026213 2026213 defendant Dove Thomas yeoman 589720 589720 Dove, Thomas, of Stanes, Middx, yeoman 0
4004041 2026219 2026219 plaintiff Hyde Thomas (legal representative) 589720 589720 Hyde, Thomas, of Stanes, Middx, innholder, executrix of 0
4079515 2052972 2052972 defendant Hawkyns Ralph yeoman 589720 589720 Hawkyns, Ralph, of Stanes, Middx, yeoman 2
4088162 2056057 2056057 defendant Penlen John clerk 589720 589720 Penlen, John, of Stanes, Middx, clerk 0
4092062 2057457 2057457 defendant Slape James grocer 589720 589720 Slape, James, of Stanes, Middx, innholder, or of London, grocer 0
4093194 2057882 2057882 defendant Penton John clerk 589720 589720 Penton, John, of Stanes, Middx, clerk 2
4101670 2060904 2060904 defendant Baker Thomas yeoman 589720 589720 Baker, Thomas, of Stanes, Middx, yeoman 3
4111159 2064244 2064244 defendant Penven John clerk 589720 589720 Penven, John, of Stanes, Middx, or of Chichester, clerk 0
4129067 2070698 2070698 defendant Penven John clerk 589720 589720 Penven, John, of Stanes, Middx, clerk 0
4140314 2074780 2074780 defendant Slape James innholder 589720 589720 Slape, James, of Stanes, Middx, innholder 0
4161360 2082054 2082054 defendant Slape James yeoman 589720 589720 Slape, James, of Stanes, Middx, yeoman 1
4168233 2084377 2084377 defendant Slape James innholder 589720 589720 Slape, James, of Stanes, Middx, innholder 0
4188767 2091550 2091550 defendant Slape James innholder 589720 589720 Slape, James, of Stanes, Middx, innholder 0
4200029 2095561 2095561 defendant Everall John farmer of Hamonds in Middx 589720 589720 Everall, John, of Stanes, Middx, yeoman, farmer of Hamonds in Middx 0
4204723 2097197 2097197 defendant Baker Thomas chapman 589720 589720 Baker, Thomas, of Stanes, Middx, chapman 0
4209208 2098773 2098773 defendant Farroll Taddy (legal representative) 589720 589720 Farroll, Taddy, of Stanes, Middx, innholder, executor of 0
4209211 2098774 2098774 defendant Farroll Taddy (legal representative) 589720 589720 Farroll, Taddy, of Stanes, Middx, innholder, executor of 0
4234142 2107471 2107471 defendant Mericke Robert clerk 589720 589720 Mericke, Robert, of Stanes, Middx, clerk 1
4255650 2114863 2114863 defendant Love Thomas (legal representative) 589720 589720 Love, Thomas, of Stanes, Middx, gent, executors of 0
4283319 2124071 2124071 defendant Raven Nicholas innholder 589720 589720 Raven, Nicholas, of Stanes, Middx, innholder 1
4309118 2133344 2133344 defendant Heywood Thomas butcher 589720 589720 Heywood, Thomas, of Stanes, Middx, butcher 0
4328812 2139949 2139949 defendant Lone or Love Thomas (legal representative) 589720 589720 Lone or Love, Thomas, of Stanes, Middx, gent, executrix of 0
4344732 2145438 2145438 defendant Slape James innholder 589720 589720 Slape, James, of Stanes, Middx, innholder 0
4407583 2167102 2167102 defendant Swytzer Mathew gent 589720 589720 Swytzer, Mathew, of Stanes, Middx, gent 0
4608435 2233748 2233748 defendant Morton Thomas   589720 589720 Morton, Thomas, of Stanes, Middx 0
4717907 2270941 2270941 defendant Gray Robert yeoman 589720 589720 Gray, Robert, of Stanes, Middx, yeoman 2
4758094 2282904 2282904 defendant Baker Ralph ostler 589720 589720 Baker, Ralph, of Stanes, Middx, ostler 0
4764094 2284758 2284758 defendant Botele John clerk 589720 589720 Botele, John, of Stanes, Middx, clerk 0
4782292 2290465 2290465 defendant Beamound William butcher 589720 589720 Beamound, William, of Stanes, Middx, butcher 0
4835196 2307008 2307008 defendant Boston John yeoman 589720 589720 Boston, John, of Stanes, Middx, yeoman 1
4860906 2314769 2314769 defendant Beaumont William butcher 589720 589720 Beaumont, William, of Stanes, Middx, butcher 0
4912380 2330373 2330373 defendant Hore Adma husbandman 589720 589720 Hore, Adma, of Stanes, Middx, husbandman 2
4922431 2333423 2333423 defendant Baker John husbandman 589720 589720 Baker, John, of Stanes, Middx, husbandman 0
4972700 2348769 2348769 defendant Elkyn Robert hosteler 589720 589720 Elkyn, Robert, of Stanes, Middx, hosteler 0
4972702 2348770 2348770 defendant Elkyn Robert hosteler 589720 589720 Elkyn, Robert, of Stanes, Middx, hosteler 0
4999206 2356634 2356634 defendant Broun John barber 589720 589720 Broun, John, of Stanes, Middx, barber 0
5011583 2360250 2360250 defendant (illegible) Robert ostler 589720 589720 _, Robert, of Stanes, Middx, ostler 2
5078838 2380158 2380158 defendant Smyth Henry hosteler 589720 589720 Smyth, Henry, of Stanes, Middx, hosteler 1
5110818 2389563 2389563 defendant Spycer John yeoman 589720 589720 Spycer, John, of Stanes, Middx, yeoman 1
5134573 2396602 2396602 defendant Elkyns (illegible) widow 589720 589720 Elkyns, ---, of Stanes, Middx, widow 2
5234345 2425633 2425633 defendant More John osteler 589720 589720 More, John, of Stanes, Middx, osteler 2
5234347 2425634 2425634 defendant More John osteler 589720 589720 More, John, of Stanes, Middx, osteler 0
5261312 2433647 2433647 defendant Berkesdale Richard tanner 589720 589720 Berkesdale, Richard, of Stanes, Middx, tanner 0
5276806 2438297 2438297 defendant Osteler alias Farleton Helen widow 589720 589720 Osteler alias Farleton, Helen, of Stanes, Middx, widow 1
5347922 2459494 2459494 defendant Lee Thomas butcher 589720 589720 Lee, Thomas, of Stanes, Middx, butcher 0
5361199 2463528 2463528 defendant Wardebroke Henry butcher 589720 589720 Wardebroke, Henry, of Stanes, Middx, butcher 1
5385211 2470846 2470846 defendant Watbroke Lawrence butcher 589720 589720 Watbroke, Lawrence, of Stanes, Middx, butcher 2
5397307 2474312 2474312 defendant Watbroke Henry butcher 589720 589720 Watbroke, Henry, of Stanes, Middx, butcher 2
5410503 2478086 2478086 defendant Watbroke Lawrence butcher 589720 589720 Watbroke, Lawrence, of Stanes, Middx, butcher 2
5410507 2478087 2478087 defendant Watbroke Henry butcher 589720 589720 Watbroke, Henry, of Stanes, Middx, butcher 2
5420006 2480901 2480901 defendant Colyns Thomas tailor 589720 589720 Colyns, Thomas, of Stanes, Middx, tailor 1
5425475 2482593 2482593 defendant Goldesue Thomas innkeeper 589720 589720 Goldesue, Thomas, of Stanes, Middx, innkeeper 2
5437222 2486072 2486072 defendant Wadbroke Henry innholder 589720 589720 Wadbroke, Henry, of Stanes, Middx, innholder 0
5441285 2487307 2487307 defendant Colyns Thomas yeoman 589720 589720 Colyns, Thomas, of Stanes, Middx, yeoman 1
5441293 2487310 2487310 defendant Wadylbroke Henry ostler 589720 589720 Wadylbroke, Henry, of Stanes, Middx, ostler 1
5445048 2488407 2488407 defendant Warbroke William ostler 589720 589720 Warbroke, William, of Stanes, Middx, ostler 0
5449990 2489886 2489886 defendant Wadylbroke Henry ostler 589720 589720 Wadylbroke, Henry, of Stanes, Middx, ostler 1
5463723 2494066 2494066 defendant Wadbroke Henry innholder 589720 589720 Wadbroke, Henry, of Stanes, Middx, innholder 0
5491969 2502507 2502507 defendant Barrey William shoemaker 589720 589720 Barrey, William, of Stanes, Middx, shoemaker 0
5496323 2503803 2503803 defendant Goldysney Thomas innholder 589720 589720 Goldysney, Thomas, of Stanes, Middx, innholder 1
5502648 2505745 2505745 defendant Goldysnye Thomas innholder 589720 589720 Goldysnye, Thomas, of Stanes, Middx, innholder 0
5506775 2507041 2507041 defendant Barre William shoemaker 589720 589720 Barre, William, of Stanes, Middx, shoemaker 0
5506780 2507042 2507042 defendant Barre William shoemaker 589720 589720 Barre, William, of Stanes, Middx, shoemaker 0
5515981 2509843 2509843 defendant Colyn John yeoman 589720 589720 Colyn, John, of Stanes, Middx, yeoman 2
5543354 2518040 2518040 defendant Bysshop John smith 589720 589720 Bysshop, John, of Stanes, Middx, smith 1
5581559 2529306 2529306 defendant Goldesnaye Thomas yeoman 589720 589720 Goldesnaye, Thomas, of Stanes, Middx, yeoman 3
5581572 2529311 2529311 defendant Gouldesnaye Thomas yeoman 589720 589720 Gouldesnaye, Thomas, of Stanes, Middx, yeoman 2
5581578 2529313 2529313 defendant Gouldsnaye Thomas yeoman 589720 589720 Gouldsnaye, Thomas, of Stanes, Middx, yeoman 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);