names

147 rows where place_id = 587101

✎ 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
3590478 1864669 1864669 defendant Galon Henry husbandman 587101 587101 Galon, Henry, of Snayth, husbandman 0
3599130 1867364 1867364 defendant Jollam William (legal representative) 587101 587101 Jollam, William, of Snayth, parish clerk, executors of 3
3599131 1867364 1867364 defendant Couper William mercer 587101 587101 (Couper, William, of Snayth, mercer 4
3612798 1871653 1871653 defendant Belland John butcher 587101 587101 Belland, John, of Snayth, butcher 5
3613239 1871795 1871795 defendant Holand Robert huasbandman 587101 587101 Holand, Robert, of Snayth, huasbandman 0
3621004 1874127 1874127 defendant Sykes John yeoman 587101 587101 Sykes, John, of Snayth, yeoman 0
3664375 1914808 1914808 defendant Scott William carpenter 587101 587101 Scott, William, of Snayth, carpenter 0
3672045 1917258 1917258 defendant Elys Alvered gent 587101 587101 Elys, Alvered, of Snayth, gent 0
3673506 1917738 1917738 defendant Pulley Robert yeoman 587101 587101 Pulley, Robert, of Snayth, yeoman 2
3678260 1919255 1919255 defendant Johnson Richard butcher 587101 587101 Johnson, Richard, of Snayth, butcher 3
3826286 1966070 1966070 defendant Grice Oswald gent 587101 587101 Grice, Oswald, of Snayth, gent 0
3829619 1967154 1967154 defendant Wyndell William yeoman 587101 587101 Wyndell, William, of Snayth, yeoman 0
3852501 1974391 1974391 plaintiff Richard Robert   587101 587101 Richard, Robert, of Snayth 0
3866902 1979168 1979168 plaintiff Dylcok Robert gent 587101 587101 Dylcok, Robert, of Snayth, gent 2
3873477 1981346 1981346 defendant Clerke Richard glover 587101 587101 Clerke, Richard, of Snayth, glover 0
3899477 1990041 1990041 defendant Bylburgh John butcher 587101 587101 Bylburgh, John, of Snayth, butcher 0
3939343 2003463 2003463 defendant Nelsthrop Thomas husbandman 587101 587101 Nelsthrop, Thomas, of Snayth, husbandman 0
4028366 2034797 2034797 defendant Wyndell William gent 587101 587101 Wyndell, William, of Snayth, gent 0
4031878 2036067 2036067 defendant Ricard Thomas yeoman 587101 587101 Ricard, Thomas, of Snayth, yeoman 0
4089752 2056632 2056632 defendant Radclyff Richard gent 587101 587101 Radclyff, Richard, of Snayth, gent 0
4089756 2056633 2056633 defendant Ratclyffe Richard gent 587101 587101 Ratclyffe, Richard, of Snayth, gent 0
4260123 2116350 2116350 defendant Ratcliff Ralph gent 587101 587101 Ratcliff, Ralph, of Snayth, gent 0
4270557 2119733 2119733 defendant Hewker John shoemaker 587101 587101 Hewker, John, of Snayth, shoemaker 0
4317088 2136091 2136091 defendant Ratcliff Richard yeoman 587101 587101 Ratcliff, Richard, of Snayth, yeoman 0
4319548 2136950 2136950 defendant Ratcliff Richard gent 587101 587101 Ratcliff, Richard, of Snayth, gent 0
4319550 2136951 2136951 defendant Ratclyff Richard gent 587101 587101 Ratclyff, Richard, of Snayth, gent 0
4319552 2136952 2136952 defendant Ratclyffe Richard gent 587101 587101 Ratclyffe, Richard, of Snayth, gent 0
4319554 2136953 2136953 defendant Ratclyffe Richard gent 587101 587101 Ratclyffe, Richard, of Snayth, gent 0
4358120 2150083 2150083 defendant Lambert George yeoman 587101 587101 Lambert, George, of Snayth, yeoman 0
4416604 2170060 2170060 plaintiff Neuton John de   587101 587101 Neuton, John de, of Snayth 0
4426135 2172981 2172981 plaintiff Neuton John de   587101 587101 Neuton, John de, of Snayth 0
4462744 2189048 2189048 defendant Drax Richard de   587101 587101 Drax, Richard de, of Snayth 2
4509847 2203569 2203569 plaintiff Bailly Peter   587101 587101 Bailly, Peter, of Snayth 0
4509853 2203570 2203570 plaintiff Bailly Peter   587101 587101 Bailly, Peter, of Snayth 0
4532944 2210574 2210574 defendant Tot John   587101 587101 Tot, John, of Snayth 0
4577688 2224528 2224528 defendant Taverner Richard merchant 587101 587101 Taverner, Richard, of Snayth, merchant 0
4597014 2230310 2230310 plaintiff Scargyll Margaret   587101 587101 Scargyll, Margaret, of Snayth, formerly wife of John 0
4657769 2248314 2248314 defendant Taverner Richard yeoman 587101 587101 Taverner, Richard, of Snayth, yeoman 2
4726160 2273468 2273468 defendant Thornton Simon butcher 587101 587101 Thornton, Simon, of Snayth, butcher 2
4726707 2273623 2273623 defendant Houlot John smith 587101 587101 Houlot, John, of Snayth, smith 0
4732681 2275402 2275402 defendant Welfed Robert mercer 587101 587101 Welfed, Robert, of Snayth, mercer 1
4733819 2275756 2275756 defendant Longe William husbandman 587101 587101 Longe, William, of Snayth, husbandman 1
4737976 2276983 2276983 defendant Mayheweson William yeoman 587101 587101 Mayheweson, William, of Snayth, yeoman 1
4740564 2277754 2277754 defendant Kyng John yeoman 587101 587101 Kyng, John, of Snayth, yeoman 0
4745804 2279279 2279279 defendant Thornton Simon butcher 587101 587101 Thornton, Simon, of Snayth, butcher 3
4756528 2282405 2282405 defendant Thornton Simon   587101 587101 Thornton, Simon, of Snayth, franklin 0
4762274 2284182 2284182 defendant Broun William husbandman 587101 587101 Broun, William, of Snayth, husbandman 1
4763050 2284427 2284427 defendant Balderston Robert yeoman 587101 587101 Balderston, Robert, of Snayth, yeoman 2
4767648 2285866 2285866 defendant Balne Thomas yeoman 587101 587101 Balne, Thomas, of Snayth, yeoman 2
4767649 2285866 2285866 defendant Barbour William yeoman 587101 587101 Barbour, William, of Snayth, yeoman 3
4767650 2285866 2285866 defendant Sharp Richard tailor 587101 587101 Sharp, Richard, of Snayth, tailor 4
4767654 2285866 2285866 defendant Manyngham Richard yeoman 587101 587101 Manyngham, Richard, of Snayth, yeoman 8
4772586 2287396 2287396 defendant atte Esshe Henry chaplain 587101 587101 atte Esshe, Henry, of Snayth, chaplain 0
4784425 2291132 2291132 defendant Frere Alice   587101 587101 Frere, Alice, of Snayth, widow of Frere, John 0
4792030 2293612 2293612 defendant Balne Thomas yeoman 587101 587101 Balne, Thomas, of Snayth, yeoman 4
4792031 2293612 2293612 defendant Barbour William yeoman 587101 587101 Barbour, William, of Snayth, yeoman 5
4792032 2293612 2293612 defendant Sharp Richard tailor 587101 587101 Sharp, Richard, of Snayth, tailor 6
4792036 2293612 2293612 defendant Manyngham Richard yeoman 587101 587101 Manyngham, Richard, of Snayth, yeoman 10
4797915 2295531 2295531 defendant atte Essh Henry chaplain 587101 587101 atte Essh, Henry, of Snayth, chaplain 0
4797925 2295533 2295533 defendant Broune William yeoman 587101 587101 Broune, William, of Snayth, yeoman 3
4809711 2299201 2299201 plaintiff Dylcok Thomas, senior (legal representative) 587101 587101 Dylcok, Thomas, senior, of Snayth, executors of 0
4814083 2300506 2300506 defendant Elmeshall John yeoman 587101 587101 Elmeshall, John, of Snayth, yeoman 2
4814089 2300506 2300506 defendant Barker Robert husbandman 587101 587101 Barker, Robert, of Snayth, husbandman 8
4815394 2300921 2300921 defendant Dylcok Robert yeoman 587101 587101 Dylcok, Robert, of Snayth, yeoman 0
4830405 2305544 2305544 defendant Monkman William husbandman 587101 587101 Monkman, William, of Snayth, husbandman 0
4831937 2306017 2306017 defendant Dylcok Thomas husbandman 587101 587101 Dylcok, Thomas, of Snayth, husbandman 0
4861913 2315104 2315104 defendant Judson William clerk 587101 587101 Judson, William, of Snayth, clerk 0
4864870 2315989 2315989 defendant Dylcok Thomas yeoman 587101 587101 Dylcok, Thomas, of Snayth, yeoman 0
4871322 2317997 2317997 defendant Dylcok Thomas husbandman 587101 587101 Dylcok, Thomas, of Snayth, husbandman 0
4872623 2318390 2318390 defendant Snayth William husbandman 587101 587101 Snayth, William, of Snayth, husbandman 0
4873075 2318533 2318533 defendant Wortlay John weaver 587101 587101 Wortlay, John, of Snayth, weaver 0
4884018 2321909 2321909 defendant Dilcok Robert gent 587101 587101 Dilcok, Robert, of Snayth, gent 0
4892510 2324395 2324395 defendant Robynson John husbandman 587101 587101 Robynson, John, of Snayth, husbandman 0
4892511 2324395 2324395 defendant Richard Thomas husbandman 587101 587101 Richard, Thomas, of Snayth, husbandman 1
4892512 2324395 2324395 defendant Mangolfe Thomas husbandman 587101 587101 Mangolfe, Thomas, of Snayth, husbandman 2
4948275 2341438 2341438 defendant Fox John (legal representative) 587101 587101 Fox, John, of Snayth, clerk, executors of 0
4948276 2341438 2341438 defendant Gledhowe Simon yeoman 587101 587101 (Gledhowe, Simon, of Snayth, yeoman 1
4958212 2344424 2344424 defendant Dilkoc Robert gent 587101 587101 Dilkoc, Robert, of Snayth, gent 0
4967172 2347112 2347112 defendant Manyngham Richard butcher 587101 587101 Manyngham, Richard, of Snayth, butcher 9
4997080 2355979 2355979 defendant Dounom Robert yeoman 587101 587101 Dounom, Robert, of Snayth, yeoman 0
5011886 2360328 2360328 defendant Wygan John husbandman 587101 587101 Wygan, John, of Snayth, husbandman 0
5011887 2360328 2360328 defendant Wygan William   587101 587101 Wygan, William, of Snayth, bell man 1
5042335 2369313 2369313 defendant Rednes Robert butcher 587101 587101 Rednes, Robert, of Snayth, butcher 0
5055749 2373290 2373290 defendant Balderstone Thomas yeoman 587101 587101 Balderstone, Thomas, of Snayth, yeoman 0
5055750 2373290 2373290 defendant Redenes Robert yeoman 587101 587101 Redenes, Robert, of Snayth, yeoman 1
5055751 2373290 2373290 defendant Frybus William yeoman 587101 587101 Frybus, William, of Snayth, yeoman 2
5055752 2373290 2373290 defendant Wolff Roger yeoman 587101 587101 Wolff, Roger, of Snayth, yeoman 3
5055753 2373290 2373290 defendant Lancastre William yeoman 587101 587101 Lancastre, William, of Snayth, yeoman 4
5057978 2373960 2373960 defendant Dilcok William yeoman 587101 587101 Dilcok, William, of Snayth, yeoman 0
5057979 2373960 2373960 defendant Dilcok Richard yeoman 587101 587101 Dilcok, Richard, of Snayth, yeoman 1
5068600 2377100 2377100 defendant Lancaster William yeoman 587101 587101 Lancaster, William, of Snayth, yeoman 0
5073753 2378638 2378638 defendant Squyer Robert yeoman 587101 587101 Squyer, Robert, of Snayth, yeoman 0
5081247 2380898 2380898 defendant Dylcok William yeoman 587101 587101 Dylcok, William, of Snayth, yeoman 0
5081248 2380898 2380898 defendant Dylcok Richard yeoman 587101 587101 Dylcok, Richard, of Snayth, yeoman 1
5085903 2382267 2382267 defendant Smythbarn William cordwainer 587101 587101 Smythbarn, William, of Snayth, cordwainer 1
5119168 2392035 2392035 defendant Dilcok William yeoman 587101 587101 Dilcok, William, of Snayth, yeoman 1
5127232 2394442 2394442 defendant Radclyff Thomas   587101 587101 Radclyff, Thomas, of Snayth 0
5127261 2394449 2394449 defendant Hopton William yeoman 587101 587101 Hopton, William, of Snayth, yeoman 0
5129081 2394989 2394989 defendant Dilcok William yeoman 587101 587101 Dilcok, William, of Snayth, yeoman 0
5131793 2395782 2395782 defendant Lancastre William yeoman 587101 587101 Lancastre, William, of Snayth, yeoman 0

Next page

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);