names

78 rows where place_id = 606537

✎ 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
3599979 1867648 1867648 defendant Patesson Richard chapman 606537 606537 Patesson, Richard, of Newcastle under Lyn, Staffs, chapman 3
3601531 1868135 1868135 defendant Johnson Thomas chapman 606537 606537 Johnson, Thomas, of Newcastle under Lyne, Staffs, chapman 3
3665548 1915175 1915175 defendant Vernon Thomas dyer 606537 606537 Vernon, Thomas, of Newcastle under Lyme, Staffs, dyer 1
3665552 1915176 1915176 defendant Vernon Thomas dyer 606537 606537 Vernon, Thomas, of Newcastle under Lyme, Staffs, dyer 1
3695253 1924734 1924734 defendant Grevys William dyer 606537 606537 Grevys, William, of Newcastle under Lyme, Staffs, dyer 0
3695255 1924735 1924735 defendant Leighton John tanner 606537 606537 Leighton, John, of Newcastle under Lyme, Staffs, tanner 0
3695259 1924736 1924736 defendant Leyghton John tanner 606537 606537 Leyghton, John, of Newcastle under Lyme, Staffs, tanner 0
3699911 1926201 1926201 defendant Vernon William dyer 606537 606537 Vernon, William, of Newcastle under Lyme, Staffs, dyer 1
3699986 1926229 1926229 defendant Vernon William dyer 606537 606537 Vernon, William, of Newcastle under Lyme, Staffs, dyer 1
3710232 1929516 1929516 defendant Vernon William dyer 606537 606537 Vernon, William, of Newcastle under Lyme, Staffs, dyer 0
3713431 1930515 1930515 defendant Rechardson John chapman 606537 606537 Rechardson, John, of Newcastle under Lyne, Staffs, chapman 1
3741385 1939173 1939173 defendant Rowbynson Richard innholder 606537 606537 Rowbynson, Richard, of Newcastle under Lyme, Staffs, innholder 0
3749783 1941842 1941842 defendant Thyknes Thomas yeoman 606537 606537 Thyknes, Thomas, of Newcastle under Lyme, Staffs, yeoman 0
3753660 1943086 1943086 defendant Bagnall John mercer 606537 606537 Bagnall, John, of Newcastle under Lyme, Staffs, mercer 1
3764899 1946687 1946687 defendant Bagnall John yeoman 606537 606537 Bagnall, John, of Newcastle under Lyme, Staffs, yeoman 0
3774781 1949839 1949839 defendant Patson John yeoman 606537 606537 Patson, John, of Newcastle under Lyme, Staffs, yeoman 3
3791416 1955152 1955152 defendant Tailler Henry gent 606537 606537 Tailler, Henry, of Newcastle under Lyme, Staffs, gent 0
3804801 1959444 1959444 defendant Walker Richard glover 606537 606537 Walker, Richard, of Newcastle under Lyme, Staffs, glover 3
3814008 1962286 1962286 defendant Smyth John yeoman 606537 606537 Smyth, John, of Newcastle under Lyme, Staffs, yeoman 1
3836809 1969413 1969413 defendant Bradshawe Thomas yeoman 606537 606537 Bradshawe, Thomas, of Newcastle under Lyme, Staffs, yeoman 0
3868425 1979677 1979677 defendant Bagnald John yeoman 606537 606537 Bagnald, John, of Newcastle under Lyme, Staffs, yeoman 0
3930291 2000479 2000479 defendant Smyth John yeoman of the Kinges garde in Staffs 606537 606537 Smyth, John, of Newcastle under Lyme, Staffs, yeoman of the Kinges garde in Staffs 0
3937451 2002860 2002860 defendant Bagnall William yeoman 606537 606537 Bagnall, William, of Newcastle under Lyme, Staffs, yeoman 0
3952650 2007996 2007996 defendant Wylson John chapman 606537 606537 Wylson, John, of Newcastle under Lyme, Staffs, chapman 0
3966033 2012741 2012741 defendant Bradshawe Richard chapman 606537 606537 Bradshawe, Richard, of Newcastle under Lime, Staffs, chapman 3
4013363 2029512 2029512 defendant Collyer William yeoman 606537 606537 Collyer, William, of Newcastle under Lyme, Staffs, yeoman 0
4095096 2058575 2058575 defendant Harryson Thomas haberdasher 606537 606537 Harryson, Thomas, of Newcastle under Lyme, Staffs, haberdasher 2
4117799 2066657 2066657 defendant Brett Robert chapman 606537 606537 Brett, Robert, of Newcastle under Lyme, Staffs, chapman 0
4142978 2075714 2075714 defendant Barker Edward tanner 606537 606537 Barker, Edward, of Newcastle under Lyne, Staffs, tanner 0
4151505 2078649 2078649 defendant Turner Roger carrier 606537 606537 Turner, Roger, of Newcastle under Lyne, Staffs, carrier 0
4163108 2082627 2082627 defendant Heathe William yeoman 606537 606537 Heathe, William, of Newcastle under Lyme, Staffs, yeoman 2
4164651 2083145 2083145 defendant Turner Roger yeoman 606537 606537 Turner, Roger, of Newcastle under Lyme, Staffs, yeoman 0
4172297 2085778 2085778 defendant Smyth Ralph yeoman 606537 606537 Smyth, Ralph, of Newcastle under Lyme, Staffs, yeoman 0
4245334 2111417 2111417 defendant Bagnold Edward grocer 606537 606537 Bagnold, Edward, of Newcastle under Lyme, Staffs, grocer 2
4319367 2136881 2136881 defendant Smythe John vintner 606537 606537 Smythe, John, of Newcastle under Lyme, Staffs, vintner 2
4323918 2138409 2138409 defendant Leighe Randolph tailor 606537 606537 Leighe, Randolph, of Newcastle under Lyme, Staffs, tailor 1
4328322 2139788 2139788 defendant Smyth Ralph gent 606537 606537 Smyth, Ralph, of Newcastle under Lyme, Staffs, gent 1
4367747 2153518 2153518 defendant Hunt Richard mercer 606537 606537 Hunt, Richard, of Newcastle, Staffs, mercer 0
4372477 2155224 2155224 defendant Hunte Richard grocer 606537 606537 Hunte, Richard, of Newcastle under Lyme, Staffs, grocer 0
4391455 2161759 2161759 defendant Smythe Ralph gent 606537 606537 Smythe, Ralph, of Newcastle under Lyme, Staffs, gent 0
4393947 2162577 2162577 defendant Hunt Richard grocer 606537 606537 Hunt, Richard, of Newcastle under Lyne, Staffs, grocer 0
4399160 2164303 2164303 defendant Smyth Ralph gent 606537 606537 Smyth, Ralph, of Newcastle under Lyme, Staffs, gent 0
4706662 2267465 2267465 defendant Andrewe John   606537 606537 Andrewe, John, of Newcastle under Lyne, Staffs, iron worker 0
4748140 2279967 2279967 defendant Snede Richard gent 606537 606537 Snede, Richard, of Newcastle under Lyne, Staffs, gent 2
4754309 2281724 2281724 defendant Cleve Thomas yeoman 606537 606537 Cleve, Thomas, of Newcastle under Lyme, Staffs, yeoman 0
4960932 2345233 2345233 defendant Moseley Richard gent 606537 606537 Moseley, Richard, of Newcastle under Lyme, Staffs, gent 0
4971526 2348413 2348413 defendant Mosley Richard gent 606537 606537 Mosley, Richard, of Newcastle under Lyme, Staffs, gent 0
4971535 2348414 2348414 defendant Mosley Richard gent 606537 606537 Mosley, Richard, of Newcastle under Lyme, Staffs, gent 0
4984517 2352302 2352302 defendant Brent Thomas husbandman 606537 606537 Brent, Thomas, of Newcastle under Lyme, Staffs, husbandman 2
4986915 2353028 2353028 defendant Colelegh Thomas gent 606537 606537 Colelegh, Thomas, of Newcastle under Lyme, Staffs, gent 1
4986918 2353029 2353029 defendant Cologh Thomas gent 606537 606537 Cologh, Thomas, of Newcastle under Lyme, Staffs, gent 1
4991736 2354412 2354412 defendant Mosle Richard gent 606537 606537 Mosle, Richard, of Newcastle under Lyme, Staffs, gent 1
4991739 2354413 2354413 defendant Mosele Richard gent 606537 606537 Mosele, Richard, of Newcastle under Lyme, Staffs, gent 0
4991742 2354414 2354414 defendant Mosele Richard gent 606537 606537 Mosele, Richard, of Newcastle under Lyme, Staffs, gent 0
4991754 2354417 2354417 defendant Mosele Richard gent 606537 606537 Mosele, Richard, of Newcastle under Lyme, Staffs, gent 1
5011540 2360242 2360242 defendant Brent Thomas chapman 606537 606537 Brent, Thomas, of Newcastle under Lyme, Staffs, chapman 2
5011597 2360252 2360252 defendant Brent Thomas chapman 606537 606537 Brent, Thomas, of Newcastle under Lyme, Staffs, chapman 2
5040428 2368741 2368741 defendant White Richard mercer 606537 606537 White, Richard, of Newcastle under Lyme, Staffs, mercer 3
5051650 2372111 2372111 defendant Brette Thomas chapman 606537 606537 Brette, Thomas, of Newcastle under Lyme, Staffs, chapman 1
5051657 2372112 2372112 defendant Brette Thomas chapman 606537 606537 Brette, Thomas, of Newcastle under Lyme, Staffs, chapman 1
5103296 2387394 2387394 plaintiff Brenne John   606537 606537 Brenne, John, of Newcastle under Lyme, Staffs, "syvyour" 0
5103299 2387395 2387395 plaintiff Brenner John   606537 606537 Brenner, John, of Newcastle Under Lyme, Staffs, "syvyour" or sieve maker 0
5239277 2427074 2427074 defendant Loker Hugh draper 606537 606537 Loker, Hugh, of Newcastle under Lyme, Staffs, draper 0
5310682 2448231 2448231 defendant Croweket Thomas mercer 606537 606537 Croweket, Thomas, of Newcastle under Lyme, Staffs, mercer 0
5418452 2480444 2480444 defendant Castnayll John butcher 606537 606537 Castnayll, John, of Newcastle, Staffs, butcher 3
5436382 2485816 2485816 defendant Maclesfeld Randolf butcher 606537 606537 Maclesfeld, Randolf, of Newcastle under Lyme, Staffs, butcher 1
5436388 2485817 2485817 defendant Maclesfeld Randolf butcher 606537 606537 Maclesfeld, Randolf, of Newcastle under Lyme, Staffs, butcher 1
5507235 2507165 2507165 defendant Patenson Richard yeoman 606537 606537 Patenson, Richard, of Newcastle under Lyne, Staffs, yeoman 6
5525772 2512649 2512649 defendant Patson Richard mercer 606537 606537 Patson, Richard, of Newcastle under Lyne, Staffs, mercer 1
5528306 2513411 2513411 defendant Bagnall Roger yeoman 606537 606537 Bagnall, Roger, of Newcastle under Lyne, Staffs, yeoman 0
5535966 2515751 2515751 defendant Henley James chapman 606537 606537 Henley, James, of Newcastle under Lyme, Staffs, chapman 0
5535970 2515752 2515752 defendant Henley James chapman 606537 606537 Henley, James, of Newcastle under Lyme, Staffs, chapman 0
5548721 2519670 2519670 defendant Patson Richard chapman 606537 606537 Patson, Richard, of Newcastle under Lyme, Staffs, chapman 1
5551306 2520415 2520415 defendant Pacheson William chapman 606537 606537 Pacheson, William, of Newcastle under Lyme, Staffs, chapman 0
5561563 2523366 2523366 defendant Smyth James chapman 606537 606537 Smyth, James, of Newcastle under Lune, Staffs, chapman 4
5579445 2528650 2528650 defendant Egerton Ralph gent 606537 606537 Egerton, Ralph, of Newcastle under Line, Staffs, gent 0
5602624 2535708 2535708 defendant Norys William yeoman 606537 606537 Norys, William, of Newcastle under Lyme, Staffs, yeoman 17
5605092 2536462 2536462 defendant Lee John yeoman 606537 606537 Lee, John, of Newcastle under Lyme, Staffs, 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);