names

92 rows where place_id = 587430

✎ 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
3591400 1864936 1864936 defendant Barowe Robert butcher 587430 587430 Barowe, Robert, of Empyngham, butcher 2
3597629 1866883 1866883 defendant Faux Thomas yeoman 587430 587430 Faux, Thomas, of Empyngham, yeoman 2
3658183 1912814 1912814 defendant Hopkyns Robert husbandman 587430 587430 Hopkyns, Robert, of Empyngham, husbandman 0
3658184 1912814 1912814 defendant Barnes William weaver 587430 587430 Barnes, William, of Empyngham, weaver 1
3658185 1912814 1912814 defendant Bran Robert husbandman 587430 587430 Bran, Robert, of Empyngham, husbandman 2
3663917 1914656 1914656 defendant Mylner William laborer 587430 587430 Mylner, William, of Empyngham, laborer 0
3720077 1932553 1932553 defendant Makworth George esq 587430 587430 Makworth, George, of Empyngham, esq 1
3737822 1938050 1938050 defendant Harryngton Thomas gent 587430 587430 Harryngton, Thomas, of Empyngham, gent 0
3737823 1938050 1938050 defendant Edmund John yeoman 587430 587430 Edmund, John, of Empyngham, yeoman 1
3737824 1938050 1938050 defendant Fowler Richard clerk 587430 587430 Fowler, Richard, of Empyngham, clerk 2
3737825 1938050 1938050 defendant Fowler Nicholas husbandman 587430 587430 Fowler, Nicholas, of Empyngham, husbandman 3
3812703 1961867 1961867 defendant Makworth George esq 587430 587430 Makworth, George, of Empyngham, esq 0
3813495 1962136 1962136 defendant Sherman Henry husbandman 587430 587430 Sherman, Henry, of Empyngham, husbandman 0
3866870 1979158 1979158 defendant Lyon John butcher 587430 587430 Lyon, John, of Empyngham, butcher 0
3898006 1989539 1989539 defendant Lyon John husbandman 587430 587430 Lyon, John, of Empyngham, husbandman 0
3941518 2004173 2004173 defendant Robynson James   587430 587430 Robynson, James, of Empyngham, shepherd 0
3990966 2021531 2021531 defendant Parker Francis miller 587430 587430 Parker, Francis, of Empyngham, miller 0
3990967 2021531 2021531 defendant Kyrby John yeoman 587430 587430 Kyrby, John, of Empyngham, yeoman 1
3990969 2021532 2021532 defendant Parker Francis miller 587430 587430 Parker, Francis, of Empyngham, miller 0
3990970 2021532 2021532 defendant Kyrby John yeoman 587430 587430 Kyrby, John, of Empyngham, yeoman 1
4444833 2183357 2183357 plaintiff Cook John   587430 587430 Cook, John, of Empyngham 0
4452281 2185702 2185702 defendant Brewes John weaver 587430 587430 Brewes, John, of Empyngham, weaver 0
4485555 2196187 2196187 defendant Ramsey John de   587430 587430 Ramsey, John de, of Empyngham 1
4529228 2209421 2209421 defendant Milner John   587430 587430 Milner, John, of Empyngham 0
4559244 2218846 2218846 defendant Thornton Richard   587430 587430 Thornton, Richard, of Empyngham 0
4636557 2242262 2242262 defendant Baker Robert   587430 587430 Baker, Robert, of Empyngham 0
4636558 2242262 2242262 defendant Mantel John   587430 587430 Mantel, John, of Empyngham 1
4636559 2242262 2242262 defendant Lambert John   587430 587430 Lambert, John, of Empyngham 2
4693466 2263457 2263457 defendant Milner Robert   587430 587430 Milner, Robert, of Empyngham, shepherd 0
4697008 2264542 2264542 defendant Mauntell John   587430 587430 Mauntell, John, of Empyngham, bailiff 1
4721917 2272187 2272187 plaintiff Chyposam John   587430 587430 Chyposam, John, of Empyngham 0
4753458 2281459 2281459 defendant Smyth Thomas clerk 587430 587430 Smyth, Thomas, of Empyngham, clerk 0
4755977 2282253 2282253 defendant Andrewe John weaver 587430 587430 Andrewe, John, of Empyngham, weaver 0
4755978 2282253 2282253 defendant May William husbandman 587430 587430 May, William, of Empyngham, husbandman 1
4755980 2282254 2282254 defendant Gaywode Richard husbandman 587430 587430 Gaywode, Richard, of Empyngham, husbandman 0
4760076 2283492 2283492 defendant Andrewe John weaver 587430 587430 Andrewe, John, of Empyngham, weaver 0
4783039 2290713 2290713 defendant Andrewe John weaver 587430 587430 Andrewe, John, of Empyngham, weaver 0
4829595 2305299 2305299 defendant Luffenham Thomas husbandman 587430 587430 Luffenham, Thomas, of Empyngham, husbandman 0
4829596 2305299 2305299 defendant atte Hall John husbandman 587430 587430 atte Hall, John, of Empyngham, husbandman 1
4829597 2305299 2305299 defendant Horne John husbandman 587430 587430 Horne, John, of Empyngham, husbandman 2
4856402 2313379 2313379 defendant Luffenham Thomas husbandman 587430 587430 Luffenham, Thomas, of Empyngham, husbandman 0
4856403 2313379 2313379 defendant Bartram William husbandman 587430 587430 Bartram, William, of Empyngham, husbandman 1
4856404 2313379 2313379 defendant Horne John husbandman 587430 587430 Horne, John, of Empyngham, husbandman 2
4856413 2313382 2313382 defendant Bocher Thomas butcher 587430 587430 Bocher, Thomas, of Empyngham, butcher 0
4856414 2313382 2313382 defendant Tuff John husbandman 587430 587430 Tuff, John, of Empyngham, husbandman 1
4856415 2313382 2313382 defendant Tye Thomas husbandman 587430 587430 Tye, Thomas, of Empyngham, husbandman 2
4903054 2327570 2327570 defendant Tyffe John husbandman 587430 587430 Tyffe, John, of Empyngham, husbandman 1
4904730 2328084 2328084 defendant Bonde John husbandman 587430 587430 Bonde, John, of Empyngham, husbandman 3
4909502 2329508 2329508 defendant Folours Agnes widow & formerly wife of Roger Felours 587430 587430 Folours, Agnes, of Empyngham, widow & formerly wife of Roger Felours 0
4909503 2329508 2329508 defendant Stewekeley Alice widow & formerly wife of John Stewekeley 587430 587430 Stewekeley, Alice, of Empyngham, widow & formerly wife of John Stewekeley 1
4909506 2329509 2329509 defendant Fresby John laborer 587430 587430 Fresby, John, of Empyngham, laborer 0
4911626 2330137 2330137 defendant Anabyll John husbandman 587430 587430 Anabyll, John, of Empyngham, husbandman 4
4917325 2331928 2331928 defendant Milner Richard milner 587430 587430 Milner, Richard, of Empyngham, milner 0
4935026 2337361 2337361 defendant Sharp Richard husbandman 587430 587430 Sharp, Richard, of Empyngham, husbandman 0
4935027 2337361 2337361 defendant Sharp Agnes   587430 587430 Sharp, Agnes, of Empyngham 1
5064028 2375774 2375774 defendant Keleby Richard husbandman 587430 587430 Keleby, Richard, of Empyngham, husbandman 1
5064029 2375774 2375774 defendant Parker Thomas husbandman 587430 587430 Parker, Thomas, of Empyngham, husbandman 2
5097170 2385609 2385609 defendant Man John husbandman 587430 587430 Man, John, of Empyngham, husbandman 0
5097171 2385609 2385609 defendant Hill Richard husbandman 587430 587430 Hill, Richard, of Empyngham, husbandman 1
5097172 2385609 2385609 defendant Wryght John husbandman 587430 587430 Wryght, John, of Empyngham, husbandman 2
5097173 2385609 2385609 defendant Wryght Thomas husbandman 587430 587430 Wryght, Thomas, of Empyngham, husbandman 3
5097174 2385609 2385609 defendant Dodell John husbandman 587430 587430 Dodell, John, of Empyngham, husbandman 4
5097175 2385609 2385609 defendant Rowse William husbandman 587430 587430 Rowse, William, of Empyngham, husbandman 5
5097177 2385609 2385609 defendant Powcher James husbandman 587430 587430 Powcher, James, of Empyngham, husbandman 7
5097178 2385609 2385609 defendant Moraunt John husbandman 587430 587430 Moraunt, John, of Empyngham, husbandman 8
5097179 2385609 2385609 defendant Careby Henry husbandman 587430 587430 Careby, Henry, of Empyngham, husbandman 9
5253581 2431230 2431230 defendant Colle Thomas husbandman 587430 587430 Colle, Thomas, of Empyngham, husbandman 0
5253582 2431230 2431230 defendant Kylby Richard husbandman 587430 587430 Kylby, Richard, of Empyngham, husbandman 1
5253584 2431230 2431230 defendant Morard John husbandman 587430 587430 Morard, John, of Empyngham, husbandman 3
5253585 2431230 2431230 defendant Braunston John husbandman 587430 587430 Braunston, John, of Empyngham, husbandman 4
5283975 2440339 2440339 defendant Edmonde Robert husbandman 587430 587430 Edmonde, Robert, of Empyngham, husbandman 0
5283976 2440339 2440339 defendant Blakke Richard husbandman 587430 587430 Blakke, Richard, of Empyngham, husbandman 1
5319293 2450863 2450863 defendant Anable Richard husbandman 587430 587430 Anable, Richard, of Empyngham, husbandman 0
5319294 2450863 2450863 defendant Hogeson John weaver 587430 587430 Hogeson, John, of Empyngham, weaver 1
5319295 2450863 2450863 defendant Bawedry John husbandman 587430 587430 Bawedry, John, of Empyngham, husbandman 2
5382360 2470013 2470013 defendant Salesbury William yeoman 587430 587430 Salesbury, William, of Empyngham, yeoman 1
5499283 2504727 2504727 defendant Salesbury Thomas yeoman 587430 587430 Salesbury, Thomas, of Empyngham, yeoman 3
5499284 2504727 2504727 defendant Clerk Thomas yeoman 587430 587430 Clerk, Thomas, of Empyngham, yeoman 4
5502400 2505673 2505673 defendant Salesbury Thomas yeoman 587430 587430 Salesbury, Thomas, of Empyngham, yeoman 0
5502401 2505673 2505673 defendant Clerke Thomas yeoman 587430 587430 Clerke, Thomas, of Empyngham, yeoman 1
5502402 2505673 2505673 defendant Clerke Henry husbandman 587430 587430 Clerke, Henry, of Empyngham, husbandman 2
5502403 2505673 2505673 defendant Ferrer John laborer 587430 587430 Ferrer, John, of Empyngham, laborer 3
5502404 2505673 2505673 defendant Thomson Richard laborer 587430 587430 Thomson, Richard, of Empyngham, laborer 4
5510482 2508111 2508111 defendant Couper Robert laborer 587430 587430 Couper, Robert, of Empyngham, laborer 0
5515035 2509546 2509546 defendant Thornton John yeoman 587430 587430 Thornton, John, of Empyngham, yeoman 0
5515036 2509546 2509546 defendant Salesbury Thomas husbandman 587430 587430 Salesbury, Thomas, of Empyngham, husbandman 1
5515037 2509546 2509546 defendant Clerk Thomas yeoman 587430 587430 Clerk, Thomas, of Empyngham, yeoman 2
5522699 2511927 2511927 defendant Thornton John yeoman 587430 587430 Thornton, John, of Empyngham, yeoman 0
5529647 2513772 2513772 defendant Faux Thomas yeoman 587430 587430 Faux, Thomas, of Empyngham, yeoman 1
5529653 2513774 2513774 defendant Faux Thomas yeoman 587430 587430 Faux, Thomas, of Empyngham, yeoman 1
5538089 2516403 2516403 defendant Thornton John yeoman 587430 587430 Thornton, John, of Empyngham, yeoman 0
5544973 2518535 2518535 defendant Thurleby John gent 587430 587430 Thurleby, John, of Empyngham, gent 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);