names

93 rows where place_id = 591075

✎ 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
3603248 1868686 1868686 defendant Hyll John husbandman 591075 591075 Hyll, John, of North Pykenham, husbandman 0
3603250 1868687 1868687 defendant Hylle John husbandman 591075 591075 Hylle, John, of North Pykenham, husbandman 0
3611718 1871326 1871326 defendant Goode Walter engraver 591075 591075 Goode, Walter, of North Pykenham, engraver 1
3631044 1904531 1904531 defendant Fermour John yeoman 591075 591075 Fermour, John, of North Pykenham, yeoman 0
3640007 1907329 1907329 defendant Fermour John yeoman 591075 591075 Fermour, John, of North Pykenham, yeoman 0
3644013 1908556 1908556 defendant Fermour John yeoman 591075 591075 Fermour, John, of North Pykenham, yeoman 0
3644944 1908827 1908827 defendant Fermour John yeoman 591075 591075 Fermour, John, of North Pykenham, yeoman 0
3649420 1910210 1910210 defendant Rowsse William draper 591075 591075 Rowsse, William, of North Pykenham, draper 0
3654148 1911560 1911560 defendant Bynkys John husbandman 591075 591075 Bynkys, John, of North Pykenham, husbandman 0
3654149 1911560 1911560 defendant Ederyche William husbandman 591075 591075 Ederyche, William, of North Pykenham, husbandman 1
3673965 1917896 1917896 defendant Fermour John yeoman 591075 591075 Fermour, John, of North Pykenham, yeoman 0
3699408 1926038 1926038 defendant Wyldyng William husbandman 591075 591075 Wyldyng, William, of North Pykenham, husbandman 0
3702044 1926892 1926892 defendant Fermour John husbandman 591075 591075 Fermour, John, of North Pykenham, husbandman 0
3705808 1928096 1928096 defendant Fermer John yeoman 591075 591075 Fermer, John, of North Pykenham, yeoman 0
3707562 1928660 1928660 defendant Maye William innholder 591075 591075 Maye, William, of North Pykenham, innholder 1
3709606 1929313 1929313 defendant Fermour John yeoman 591075 591075 Fermour, John, of North Pykenham, yeoman 2
3711063 1929771 1929771 defendant Hyanson Thomas clerk 591075 591075 Hyanson, Thomas, of North Pykenham, clerk 2
3724199 1933855 1933855 defendant Fermour John yeoman 591075 591075 Fermour, John, of North Pykenham, yeoman 2
3725343 1934218 1934218 defendant Mayes William innkeeper 591075 591075 Mayes, William, of North Pykenham, innkeeper 1
3728538 1935175 1935175 defendant Fermour John gent 591075 591075 Fermour, John, of North Pykenham, gent 0
3731257 1936000 1936000 defendant Fermor John yeoman 591075 591075 Fermor, John, of North Pykenham, yeoman 0
3741574 1939234 1939234 defendant Duxbery Lawrence innkeeper 591075 591075 Duxbery, Lawrence, of North Pykenham, innkeeper 3
3744296 1940114 1940114 defendant Fermour John yeoman 591075 591075 Fermour, John, of North Pykenham, yeoman 0
3744304 1940117 1940117 defendant Fermour John yeoman 591075 591075 Fermour, John, of North Pykenham, yeoman 0
3745063 1940363 1940363 defendant Duxbere Lawrence yeoman 591075 591075 Duxbere, Lawrence, of North Pykenham, yeoman 3
3745788 1940586 1940586 defendant Fayreman Robert, junior husbandman 591075 591075 Fayreman, Robert, junior, of North Pykenham, husbandman 0
3751270 1942321 1942321 defendant Fayreman Robert, junior husbandman 591075 591075 Fayreman, Robert, junior, of North Pykenham, husbandman 1
3751271 1942321 1942321 defendant Echard Thomas yeoman 591075 591075 Echard, Thomas, of North Pykenham, yeoman 2
3757689 1944385 1944385 defendant Fermor John yeoman 591075 591075 Fermor, John, of North Pykenham, yeoman 0
3757722 1944396 1944396 defendant Duxbere Lawrence yeoman 591075 591075 Duxbere, Lawrence, of North Pykenham, yeoman 3
3761037 1945454 1945454 defendant Tavesham John innholder 591075 591075 Tavesham, John, of North Pykenham, innholder 3
3773835 1949528 1949528 defendant Stede John husbandman 591075 591075 Stede, John, of North Pykenham, husbandman 0
3796346 1956721 1956721 plaintiff Echard Thomas   591075 591075 Echard, Thomas, of North Pykenham 0
3809441 1960835 1960835 defendant Echard Thomas yeoman 591075 591075 Echard, Thomas, of North Pykenham, yeoman 0
3818228 1963616 1963616 defendant Coke Ralph clerk 591075 591075 Coke, Ralph, of North Pykenham, clerk 0
3866146 1978906 1978906 defendant Bagett Roger innholder 591075 591075 Bagett, Roger, of North Pykenham, innholder 0
3874309 1981633 1981633 defendant Fermor John (legal representative) 591075 591075 Fermor, John, of North Pykenham, gent, executor of 0
3939468 2003506 2003506 defendant Abbott John tailor 591075 591075 Abbott, John, of North Pykenham, tailor 1
4052553 2043334 2043334 defendant Coley Roger clerk 591075 591075 Coley, Roger, of North Pykenham, clerk 1
4472385 2192033 2192033 defendant Caudeler Richard   591075 591075 Caudeler, Richard, of North Pykenham 0
4472389 2192035 2192035 defendant Caudeler Richard   591075 591075 Caudeler, Richard, of North Pykenham 0
4502962 2201497 2201497 defendant Drayton William   591075 591075 Drayton, William, of North Pykenham, parson 0
4516655 2205622 2205622 defendant Caudeler Richard   591075 591075 Caudeler, Richard, of North Pykenham 0
4526250 2208499 2208499 defendant Creyk James (legal representative) 591075 591075 Creyk, James, of North Pykenham, executors of 0
4548991 2215618 2215618 defendant Caudeler Richard   591075 591075 Caudeler, Richard, of North Pykenham 0
4636313 2242191 2242191 defendant Heylot John   591075 591075 Heylot, John, of North Pykenham, parson 4
4639940 2243189 2243189 defendant Heylot John   591075 591075 Heylot, John, of North Pykenham, parson 4
4644418 2244458 2244458 defendant Heylot John   591075 591075 Heylot, John, of North Pykenham, parson 0
4703842 2266580 2266580 defendant Clerk Richard husbandman 591075 591075 Clerk, Richard, of North Pykenham, husbandman 0
4760476 2283628 2283628 defendant Heylot John   591075 591075 Heylot, John, of North Pykenham, parson 0
4762518 2284260 2284260 defendant Oxeburgh Richard yeoman 591075 591075 Oxeburgh, Richard, of North Pykenham, yeoman 0
4762519 2284260 2284260 defendant Lante John husbandman 591075 591075 Lante, John, of North Pykenham, husbandman 1
4774665 2288065 2288065 defendant Warde John yeoman 591075 591075 Warde, John, of North Pykenham, yeoman 0
4774666 2288065 2288065 defendant Warde Thomas laborer 591075 591075 Warde, Thomas, of North Pykenham, laborer 1
4955480 2343601 2343601 defendant Warde John (legal representative) 591075 591075 Warde, John, of North Pykenham, executors of 3
4955482 2343601 2343601 defendant Sponere Henry yeoman 591075 591075 Sponere, Henry, of North Pykenham, yeoman 5
5008636 2359423 2359423 defendant Brunton Nicholas yeoman 591075 591075 Brunton, Nicholas, of North Pykenham, yeoman 0
5008668 2359427 2359427 defendant Brunton Nicholas yeoman 591075 591075 together with Brunton, Nicholas, of North Pykenham, yeoman 1
5066807 2376599 2376599 defendant Flappe Walter husbandman 591075 591075 Flappe, Walter, of North Pykenham, husbandman 0
5116087 2391133 2391133 defendant Gentill alias Trubbek John husbandman 591075 591075 Gentill alias Trubbek, John, of North Pykenham, husbandman 2
5116088 2391133 2391133 defendant Fowne Richard miller 591075 591075 Fowne, Richard, of North Pykenham, miller 3
5130857 2395505 2395505 defendant Pyttes Richard carpenter 591075 591075 Pyttes, Richard, of North Pykenham, carpenter 0
5133970 2396431 2396431 defendant Fowne Richard miller 591075 591075 Fowne, Richard, of North Pykenham, miller 1
5164034 2405217 2405217 defendant Flappe Walter husbandman 591075 591075 Flappe, Walter, of North Pykenham, husbandman 0
5171155 2407283 2407283 defendant Fowne Richard miller 591075 591075 Fowne, Richard, of North Pykenham, miller 0
5196658 2414776 2414776 plaintiff Roberdys John   591075 591075 Roberdys, John, of North Pykenham 1
5227629 2423701 2423701 defendant Fovyne Richard miller 591075 591075 Fovyne, Richard, of North Pykenham, miller 0
5230431 2424516 2424516 defendant Fowene Richard husbandman 591075 591075 Fowene, Richard, of North Pykenham, husbandman 0
5241728 2427787 2427787 defendant Sterlyng Philip chaplain 591075 591075 Sterlyng, Philip, of North Pykenham, chaplain 0
5241729 2427787 2427787 defendant Roberdys John yeoman 591075 591075 Roberdys, John, of North Pykenham, yeoman 1
5246925 2429264 2429264 defendant Fowene Richard miller 591075 591075 Fowene, Richard, of North Pykenham, miller 3
5253041 2431057 2431057 defendant Bateman William yeoman 591075 591075 Bateman, William, of North Pykenham, yeoman 0
5302886 2445849 2445849 defendant Flappe Walter husbandman 591075 591075 Flappe, Walter, of North Pykenham, husbandman 0
5312458 2448759 2448759 defendant Flappe Walter yeoman 591075 591075 Flappe, Walter, of North Pykenham, yeoman 0
5312461 2448760 2448760 defendant Flappe Walter yeoman 591075 591075 Flappe, Walter, of North Pykenham, yeoman 0
5312464 2448761 2448761 defendant Flappe Walter yeoman 591075 591075 Flappe, Walter, of North Pykenham, yeoman 0
5328374 2453559 2453559 defendant Flappe Walter husbandman 591075 591075 Flappe, Walter, of North Pykenham, husbandman 0
5328445 2453583 2453583 defendant Hyll John husbandman 591075 591075 Hyll, John, of North Pykenham, husbandman 0
5359309 2462948 2462948 defendant Kerre William yeoman 591075 591075 Kerre, William, of North Pykenham, yeoman 0
5359313 2462949 2462949 defendant Kerre William yeoman 591075 591075 Kerre, William, of North Pykenham, yeoman 0
5422455 2481663 2481663 defendant Evan John carpenter 591075 591075 Evan, John, of North Pykenham, carpenter 3
5442113 2487557 2487557 defendant Evan Thomas carpenter 591075 591075 Evan, Thomas, of North Pykenham, carpenter 1
5442118 2487559 2487559 defendant Evan John carpenter 591075 591075 Evan, John, of North Pykenham, carpenter 1
5494573 2503263 2503263 defendant Legge John yeoman 591075 591075 Legge, John, of North Pykenham, yeoman 0
5494575 2503263 2503263 defendant Hill John butcher 591075 591075 Hill, John, of North Pykenham, butcher 2
5494576 2503263 2503263 defendant Cheney William laborer 591075 591075 Cheney, William, of North Pykenham, laborer 3
5516518 2509995 2509995 defendant Fairman Richard yeoman 591075 591075 Fairman, Richard, of North Pykenham, yeoman 0
5551264 2520402 2520402 defendant Faireman Richard husbandman 591075 591075 Faireman, Richard, of North Pykenham, husbandman 1
5552485 2520782 2520782 defendant Cristhed Henry husbandman 591075 591075 Cristhed, Henry, of North Pykenham, husbandman 0
5558952 2522569 2522569 defendant Kysted Henry husbandman 591075 591075 Kysted, Henry, of North Pykenham, husbandman 0
5577236 2527932 2527932 defendant Cryspe Nicholas husbandman 591075 591075 Cryspe, Nicholas, of North Pykenham, husbandman 1
5588830 2531520 2531520 defendant Fermour John husbandman 591075 591075 Fermour, John, of North Pykenham, husbandman 0
5607088 2537105 2537105 defendant Fysshe Peter husbandman 591075 591075 Fysshe, Peter, of North Pykenham, husbandman 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);