names

84 rows where place_id = 587724

✎ 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
3592248 1865190 1865190 defendant Parker Hamon husbandman 587724 587724 Parker, Hamon, of North Mymmes, husbandman 0
3592249 1865190 1865190 defendant Parker Robert husbandman 587724 587724 Parker, Robert, of North Mymmes, husbandman 1
3623241 1874797 1874797 defendant Fortescu Benedict gent 587724 587724 Fortescu, Benedict, of North Mymmes, gent 0
3690790 1923284 1923284 defendant Mombrey Leonard warrener 587724 587724 Mombrey, Leonard, of North Mymmes, warrener 0
3690791 1923284 1923284 defendant Mombrey Robert yeoman 587724 587724 Mombrey, Robert, of North Mymmes, yeoman 1
3690792 1923284 1923284 defendant Mombrey Henry laborer 587724 587724 Mombrey, Henry, of North Mymmes, laborer 2
3722623 1933335 1933335 defendant Mowbrey Leonard yeoman 587724 587724 Mowbrey, Leonard, of North Mymmes, yeoman 0
3761781 1945696 1945696 defendant James Thomas carpenter 587724 587724 James, Thomas, of North Mymmes, carpenter 0
3901583 1990755 1990755 defendant Chapell Roger husbandman 587724 587724 Chapell, Roger, of North Mymmes, husbandman 0
3962088 2011321 2011321 defendant Warlowe Gregory husbandman 587724 587724 Warlowe, Gregory, of North Mymmes, husbandman 1
4375024 2156128 2156128 defendant Russell Edward   587724 587724 Russell, Edward, of North Mymmes, Herts esq 0
4375025 2156128 2156128 defendant Russell James gent 587724 587724 Russell, James, of North Mymmes, gent 1
4415859 2169851 2169851 plaintiff (not given) William de rector of Kestevene 587724 587724 Kestevene, William de, of North Mymmes, rector of the church 0
4416585 2170052 2170052 plaintiff Mymmes John de   587724 587724 Mymmes, John de, of North Mymmes, son of John 0
4471453 2191729 2191729 defendant atte Hasshe John   587724 587724 atte Hasshe, John, of North Mymmes 0
4515688 2205327 2205327 defendant atte Nasshe John   587724 587724 atte Nasshe, John, of North Mymmes 0
4533131 2210626 2210626 defendant Nasshe John   587724 587724 Nasshe, John, of North Mymmes 0
4605799 2232927 2232927 defendant Bakhous Gilbert of the   587724 587724 Bakhous, Gilbert of the, of North Mymmes 1
4721613 2272089 2272089 defendant atte Nasshe Richard husbandman 587724 587724 atte Nasshe, Richard, of North Mymmes, husbandman 3
4737247 2276767 2276767 defendant Wright John husbandman 587724 587724 Wright, John, of North Mymmes, husbandman 3
4767413 2285791 2285791 defendant Dryver John   587724 587724 Dryver, John, of North Mymmes 0
4799896 2296151 2296151 defendant Wryght John husbandman 587724 587724 Wryght, John, of North Mymmes, husbandman 0
4807166 2298443 2298443 defendant Wryght John husbandman 587724 587724 Wryght, John, of North Mymmes, husbandman 0
4813399 2300305 2300305 defendant Benton John husbandman 587724 587724 Benton, John, of North Mymmes, husbandman 0
4928577 2335368 2335368 defendant Reed David tailor 587724 587724 Reed, David, of North Mymmes, tailor 0
4956558 2343919 2343919 defendant Creswell john laborer 587724 587724 Creswell, john, of North Mymmes, laborer 2
4956568 2343920 2343920 defendant Creswell John laborer 587724 587724 Creswell, John, of North Mymmes, laborer 2
4964424 2346272 2346272 plaintiff Clerk Thomas farmer 587724 587724 Clerk, Thomas, of North Mymmes, farmer 0
4973190 2348916 2348916 defendant Clerk William laborer 587724 587724 Clerk, William, of North Mymmes, laborer 0
4975205 2349539 2349539 defendant Lynster Henry gent 587724 587724 Lynster, Henry, of North Mymmes, gent 0
4986328 2352836 2352836 defendant Tavy Walter husbandman 587724 587724 Tavy, Walter, of North Mymmes, husbandman 0
4999674 2356779 2356779 defendant Grubbe Robert laborer 587724 587724 Grubbe, Robert, of North Mymmes, laborer 1
5040834 2368875 2368875 defendant Saunder William maltman 587724 587724 Saunder, William, of North Mymmes, maltman 0
5046898 2370694 2370694 defendant Baylly Guy husbandman 587724 587724 Baylly, Guy, of North Mymmes, husbandman 0
5046899 2370694 2370694 defendant Chylde Philip collier 587724 587724 Chylde, Philip, of North Mymmes, collier 1
5050877 2371877 2371877 defendant Saunder William loader 587724 587724 Saunder, William, of North Mymmes, loader 1
5076608 2379507 2379507 defendant Hamelet John husbandman 587724 587724 Hamelet, John, of North Mymmes, husbandman 1
5076609 2379507 2379507 defendant Deyne John husbandman 587724 587724 Deyne, John, of North Mymmes, husbandman 2
5076612 2379508 2379508 defendant Hamelot John husbandman 587724 587724 Hamelot, John, of North Mymmes, husbandman 1
5076613 2379508 2379508 defendant Deyne John husbandman 587724 587724 Deyne, John, of North Mymmes, husbandman 2
5085479 2382144 2382144 defendant Saunder William husbandman 587724 587724 Saunder, William, of North Mymmes, husbandman 1
5098641 2386034 2386034 defendant Chyld Peter husbandman 587724 587724 Chyld, Peter, of North Mymmes, husbandman 2
5105631 2388097 2388097 defendant Chyld Peter husbandman 587724 587724 Chyld, Peter, of North Mymmes, husbandman 0
5214553 2419985 2419985 defendant Deyns John laborer 587724 587724 Deyns, John, of North Mymmes, laborer 1
5214554 2419985 2419985 defendant Couper Belina widow 587724 587724 Couper, Belina, of North Mymmes, widow 2
5226246 2423340 2423340 defendant Langley John yeoman 587724 587724 Langley, John, of North Mymmes, yeoman 0
5251643 2430616 2430616 defendant Knolles Robert esq 587724 587724 Knolles, Robert, of North Mymmes, esq 0
5268263 2435840 2435840 defendant Knolleton Henry yeoman 587724 587724 Knolleton, Henry, of North Mymmes, yeoman 2
5268264 2435840 2435840 defendant Stapull William yeoman 587724 587724 Stapull, William, of North Mymmes, yeoman 3
5268265 2435840 2435840 defendant Smyth John laborer 587724 587724 Smyth, John, of North Mymmes, laborer 4
5272615 2437065 2437065 defendant Childe Philip yeoman 587724 587724 Childe, Philip, of North Mymmes, yeoman 0
5272619 2437067 2437067 defendant Dalton Walter laborer 587724 587724 Dalton, Walter, of North Mymmes, laborer 0
5274959 2437760 2437760 defendant Childe Philip yeoman 587724 587724 Childe, Philip, of North Mymmes, yeoman 7
5274960 2437760 2437760 defendant Chylde Peter yeoman 587724 587724 Chylde, Peter, of North Mymmes, yeoman 8
5300429 2445087 2445087 plaintiff Chyld Philip yeoman 587724 587724 Chyld, Philip, of North Mymmes, yeoman 0
5300430 2445087 2445087 defendant Staple William yeoman 587724 587724 Staple, William, of North Mymmes, yeoman 0
5300431 2445087 2445087 defendant Sterne John, sen husbandman 587724 587724 Sterne, John, sen, of North Mymmes, husbandman 1
5301650 2445446 2445446 defendant Chylde Peter husbandman 587724 587724 Chylde, Peter, of North Mymmes, husbandman 0
5310602 2448207 2448207 defendant Langley John yeoman 587724 587724 Langley, John, of North Mymmes, yeoman 2
5329001 2453753 2453753 defendant Grubbe Robert husbandman 587724 587724 Grubbe, Robert, of North Mymmes, husbandman 0
5329002 2453753 2453753 defendant Stanbrygge Richard butcher 587724 587724 Stanbrygge, Richard, of North Mymmes, butcher 1
5334777 2455468 2455468 defendant Bayly Guy yeoman 587724 587724 Bayly, Guy, of North Mymmes, yeoman 0
5341893 2457662 2457662 defendant Sterne John husbandman 587724 587724 Sterne, John, of North Mymmes, husbandman 0
5348151 2459565 2459565 defendant Godyng William laborer 587724 587724 Godyng, William, of North Mymmes, laborer 4
5362020 2463785 2463785 defendant Knollys Robert esq 587724 587724 Knollys, Robert, of North Mymmes, esq 0
5364373 2464518 2464518 defendant Elys Thomas tailor 587724 587724 Elys, Thomas, of North Mymmes, tailor 0
5388952 2471898 2471898 defendant Chylde Peter husbandman 587724 587724 Chylde, Peter, of North Mymmes, husbandman 12
5389640 2472099 2472099 defendant Gwynhoo John tiler 587724 587724 Gwynhoo, John, of North Mymmes, tiler 0
5390751 2472418 2472418 defendant Parker Hamon   587724 587724 Parker, Hamon, of North Mymmes 0
5402366 2475751 2475751 defendant Gwynhoo or Ewynhoo John tiler 587724 587724 Gwynhoo or Ewynhoo, John, of North Mymmes, tiler 0
5417879 2480275 2480275 defendant Feld William husbandman 587724 587724 Feld, William, of North Mymmes, husbandman 1
5429571 2483782 2483782 plaintiff Grubbe Robert   587724 587724 Grubbe, Robert, of North Mymmes 0
5429572 2483782 2483782 defendant Avyver James husbandman 587724 587724 Avyver, James, of North Mymmes, husbandman 0
5492622 2502706 2502706 defendant Curteys William smith 587724 587724 Curteys, William, of North Mymmes, smith 0
5498864 2504600 2504600 plaintiff Parker Hamo yeoman 587724 587724 Parker, Hamo, of North Mymmes, yeoman 0
5533256 2514951 2514951 defendant Haddon John husbandman 587724 587724 Haddon, John, of North Mymmes, husbandman 0
5533257 2514951 2514951 defendant Bustard Robert husbandman 587724 587724 Bustard, Robert, of North Mymmes, husbandman 1
5554405 2521325 2521325 defendant Smyth John husbandman 587724 587724 Smyth, John, of North Mymmes, husbandman 1
5556334 2521850 2521850 defendant Foster John yeoman 587724 587724 Foster, John, of North Mymmes, yeoman 1
5566141 2524693 2524693 defendant Yonge William husbandman 587724 587724 Yonge, William, of North Mymmes, husbandman 0
5566142 2524693 2524693 defendant Yonge Richard laborer 587724 587724 Yonge, Richard, of North Mymmes, laborer 1
5586055 2530680 2530680 defendant Haddon William husbandman 587724 587724 Haddon, William, of North Mymmes, husbandman 0
5586056 2530680 2530680 defendant Bocher Thomas butcher 587724 587724 Bocher, Thomas, of North Mymmes, butcher 1
5586057 2530680 2530680 defendant Yong William laborer 587724 587724 Yong, William, of North Mymmes, laborer 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);