names

67 rows where place_id = 617730

✎ 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
3720982 1932859 1932859 defendant Hardyng William smith 617730 617730 Hardyng, William, of Swavesey, smith 0
3941739 2004251 2004251 defendant Smythe Richard clerk 617730 617730 Smythe, Richard, of Swavesey, clerk 3
3941740 2004251 2004251 defendant Stower Henry husbandman 617730 617730 Stower, Henry, of Swavesey, husbandman 4
4252240 2113740 2113740 defendant Chapman Thomas yeoman 617730 617730 Chapman, Thomas, of Swavesey, yeoman 2
4252244 2113741 2113741 defendant Chapman Thomas yeoman 617730 617730 Chapman, Thomas, of Swavesey, yeoman 2
4296062 2128689 2128689 defendant Chapman Edmund gent 617730 617730 Chapman, Edmund, of Swavesey, gent 0
4296063 2128689 2128689 defendant Chapman Francis yeoman 617730 617730 Chapman, Francis, of Swavesey, yeoman 1
4297790 2129317 2129317 defendant Pecke John yeoman 617730 617730 Pecke, John, of Swavesey, or of Waterbeache, yeoman 1
4303588 2131381 2131381 defendant Radecliffe Owen gent 617730 617730 Radecliffe, Owen, of Swavesey, gent 0
4327972 2139677 2139677 defendant Chapman Thomas yeoman 617730 617730 Chapman, Thomas, of Swavesey, yeoman 0
4327973 2139677 2139677 defendant Boston George yeoman 617730 617730 Boston, George, of Swavesey, yeoman 1
4328035 2139695 2139695 defendant Page Henry butcher 617730 617730 Page, Henry, of Swavesey, yeoman, butcher 1
4336084 2142356 2142356 defendant Radclyffe Owen gent 617730 617730 Radclyffe, Owen, of Swavesey, or of Gamlyngay, Cams, gent 0
4342994 2144823 2144823 defendant Heigham Robert gent 617730 617730 Heigham, Robert, of Swavesey, gent 2
4343266 2144919 2144919 defendant Holmes Richard, senior yeoman 617730 617730 Holmes, Richard, senior, of Swavesey, or of Swaffham Prior, yeoman 1
4345861 2145815 2145815 defendant Chapman Thomas gent 617730 617730 Chapman, Thomas, of Swavesey, gent 1
4465676 2189941 2189941 defendant Russel Lawrence   617730 617730 Russel, Lawrence, of Swavesey 0
4578074 2224646 2224646 defendant Halton John   617730 617730 Halton, John, of Swavesey 0
4609653 2234114 2234114 defendant Milnere Thomas   617730 617730 Milnere, Thomas, of Swavesey 3
4616437 2236133 2236133 defendant Andrewe Richard   617730 617730 Andrewe, Richard, of Swavesey 0
4616439 2236134 2236134 defendant Andrewe Richard   617730 617730 Andrewe, Richard, of Swavesey 0
4616441 2236135 2236135 defendant Andrewe Richard   617730 617730 Andrewe, Richard, of Swavesey 0
4638000 2242647 2242647 defendant Milnere Thomas   617730 617730 Milnere, Thomas, of Swavesey 2
4649618 2245920 2245920 defendant Halton John   617730 617730 Halton, John, of Swavesey 0
4649622 2245921 2245921 defendant Halton John   617730 617730 Halton, John, of Swavesey 0
4676614 2258304 2258304 defendant Vesty John   617730 617730 Vesty, John, of Swavesey 0
4681366 2259795 2259795 plaintiff Mason William (legal representative) 617730 617730 Mason, William, of Swavesey, executors of 0
4693882 2263590 2263590 defendant Bukden John laborer 617730 617730 Bukden, John, of Swavesey, laborer 0
4695720 2264142 2264142 plaintiff Bugle Lawrence   617730 617730 Bugle, Lawrence, of Swavesey 0
4697750 2264790 2264790 defendant Skilfull William yeoman 617730 617730 Skilfull, William, of Swavesey, yeoman 0
4715164 2270072 2270072 plaintiff Vescy John   617730 617730 Vescy, John, of Swavesey 0
4720513 2271754 2271754 plaintiff Brudenham William   617730 617730 Brudenham, William, of Swavesey 0
4741685 2278061 2278061 plaintiff Bradenham William   617730 617730 Bradenham, William, of Swavesey, on his own account 0
4757646 2282768 2282768 defendant More Robert mercer 617730 617730 More, Robert, of Swavesey, mercer 0
4769137 2286323 2286323 defendant Smyth Richard husbandman 617730 617730 Smyth, Richard, of Swavesey, husbandman 0
4799950 2296166 2296166 defendant Gardyner Simon butcher 617730 617730 Gardyner, Simon, of Swavesey, butcher 3
4799951 2296166 2296166 defendant Baker William fisher 617730 617730 Baker, William, of Swavesey, fisher 4
4828237 2304874 2304874 defendant Hoke john husbandman 617730 617730 Hoke, john, of Swavesey, husbandman 0
4830600 2305593 2305593 defendant Castre Thomas yeoman 617730 617730 Castre, Thomas, of Swavesey, yeoman 0
4837812 2307760 2307760 defendant Hardy William husbandman 617730 617730 Hardy, William, of Swavesey, husbandman 0
4837813 2307760 2307760 defendant Rous Richard yeoman 617730 617730 Rous, Richard, of Swavesey, yeoman 1
4851683 2311959 2311959 plaintiff Vesey John   617730 617730 Vesey, John, of Swavesey 0
4859862 2314455 2314455 defendant Motte John husbandman 617730 617730 Motte, John, of Swavesey, husbandman 1
4879690 2320568 2320568 plaintiff Vescy John   617730 617730 Vescy, John, of Swavesey 0
4879691 2320568 2320568 defendant Gardiner Simon butcher 617730 617730 Gardiner, Simon, of Swavesey, butcher 0
4897133 2325759 2325759 defendant Cok John carpenter 617730 617730 Cok, John, of Swavesey, carpenter 1
4911936 2330239 2330239 plaintiff Braunte Richard   617730 617730 Braunte, Richard, of Swavesey, franklin 3
4913087 2330590 2330590 defendant Graunt Richard   617730 617730 Graunt, Richard, of Swavesey, franklin 3
4913093 2330591 2330591 defendant Graunt Richard   617730 617730 Graunt, Richard, of Swavesey, franklin 3
4996251 2355734 2355734 defendant Castre Thomas husbandman 617730 617730 Castre, Thomas, of Swavesey, husbandman 2
5072826 2378354 2378354 plaintiff Joterell John   617730 617730 Joterell, John, of Swavesey 2
5297535 2444287 2444287 plaintiff Alden Robert husbandman 617730 617730 Alden, Robert, of Swavesey, husbandman 0
5297536 2444287 2444287 defendant Feyrfax also Fayrfox William husbandman 617730 617730 Feyrfax also Fayrfox, William, of Swavesey, husbandman 0
5325475 2452701 2452701 defendant Payntour John yeoman 617730 617730 Payntour, John, of Swavesey, yeoman 3
5384345 2470610 2470610 defendant Barlyman Thomas husbandman 617730 617730 Barlyman, Thomas, of Swavesey, husbandman 2
5386425 2471188 2471188 defendant Bolles William yeoman 617730 617730 Bolles, William, of Swavesey, yeoman 0
5386431 2471191 2471191 defendant Bolles William yeoman 617730 617730 Bolles, William, of Swavesey, yeoman 0
5434415 2485233 2485233 defendant Barlyman Thomas husbandman 617730 617730 Barlyman, Thomas, of Swavesey, husbandman 0
5434416 2485233 2485233 defendant Barlyman John husbandman 617730 617730 Barlyman, John, of Swavesey, husbandman 1
5449820 2489834 2489834 defendant Barlyman John husbandman 617730 617730 Barlyman, John, of Swavesey, husbandman 1
5461992 2493526 2493526 defendant Barlyman John husbandman 617730 617730 Barlyman, John, of Swavesey, husbandman 1
5515976 2509842 2509842 defendant Couper John husbandman 617730 617730 Couper, John, of Swavesey, husbandman 1
5515977 2509842 2509842 defendant Biry John husbandman 617730 617730 Biry, John, of Swavesey, husbandman 2
5634571 2554810 2554810 defendant Derynall or Deryvall William husbandman 617730 617730 Derynall or Deryvall, William, of Swavesey, husbandman 0
5634573 2554810 2554810 defendant Barbour John husbandman 617730 617730 Barbour, John, of Swavesey, husbandman 2
5634576 2554811 2554811 defendant Derynall or Deryvall William husbandman 617730 617730 Derynall or Deryvall, William, of Swavesey, husbandman 0
5634578 2554811 2554811 defendant Barbour John husbandman 617730 617730 Barbour, John, of Swavesey, husbandman 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);