names

58 rows where place_id = 640243

✎ 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
3773954 1949570 1949570 defendant Cooke William   640243 640243 Cooke, William, of Bourne, surgeon 0
3854144 1974934 1974934 defendant Kyllets Richard husbandman 640243 640243 Kyllets, Richard, of Bourne, husbandman 1
3866167 1978914 1978914 defendant Wylley Christopher clerk 640243 640243 Wylley, Christopher, of Bourne, clerk 0
3866168 1978914 1978914 defendant Warde John husbandman 640243 640243 Warde, John, of Bourne, husbandman 1
3866169 1978914 1978914 defendant Newman John husbandman 640243 640243 Newman, John, of Bourne, husbandman 2
3866170 1978914 1978914 defendant Gylbert Richard carpenter 640243 640243 Gylbert, Richard, of Bourne, carpenter 3
3876626 1982429 1982429 defendant Hawke Henry husbandman 640243 640243 Hawke, Henry, of Bourne, husbandman 0
3908267 1993062 1993062 defendant Wyllyngton alias Carter William butcher 640243 640243 Wyllyngton alias Carter, William, of Bourne, butcher 0
3908268 1993062 1993062 defendant Stanner alias Stannerd Augustine husbandman 640243 640243 Stanner alias Stannerd, Augustine, of Bourne, husbandman 1
3908269 1993062 1993062 defendant Thomas Robert husbandman 640243 640243 Thomas, Robert, of Bourne, husbandman 2
3932380 2001124 2001124 defendant Lenton Richard husbandman 640243 640243 Lenton, Richard, of Bourne, husbandman 5
3942765 2004584 2004584 defendant Russell John, senior butcher 640243 640243 (Russell, John, senior, of Bourne, butcher 1
3966321 2012847 2012847 defendant Meke John yeoman 640243 640243 Meke, John, of Bourne, yeoman 1
3973718 2015382 2015382 plaintiff Haggar John gent 640243 640243 Haggar, John, of Bourne, gent 0
3984182 2019109 2019109 plaintiff Sudburne Walter merchant 640243 640243 Sudburne, Walter, of Bourne, merchant 0
3990472 2021344 2021344 defendant Braye Robert yeoman 640243 640243 Braye, Robert, of Bourne, or of Eton, Beds, yeoman 0
3990473 2021344 2021344 defendant Cranfeld Robert yeoman 640243 640243 Cranfeld, Robert, of Bourne, yeoman 1
4027980 2034657 2034657 defendant Saundon John yeoman 640243 640243 Saundon, John, of Bourne, yeoman 0
4027981 2034658 2034658 plaintiff Cole Thomas gent 640243 640243 Cole, Thomas, of Bourne, gent 0
4027982 2034658 2034658 defendant Sandon John yeoman 640243 640243 Sandon, John, of Bourne, yeoman 0
4063476 2047227 2047227 defendant Nicholson John clerk 640243 640243 Nicholson, John, of Bourne, clerk 3
4070168 2049621 2049621 defendant Collingham John yeoman 640243 640243 Collingham, John, of Bourne, yeoman 0
4100914 2060642 2060642 defendant Phipps Thomas butcher 640243 640243 Phipps, Thomas, of Bourne, butcher 0
4100915 2060642 2060642 defendant Lowe Andrew carpenter 640243 640243 Lowe, Andrew, of Bourne, carpenter 1
4189516 2091833 2091833 defendant Tampyon Henry tanner 640243 640243 Tampyon, Henry, of Bourne, tanner 0
4189517 2091833 2091833 defendant Cornwell Robert tanner 640243 640243 Cornwell, Robert, of Bourne, tanner 1
4204686 2097185 2097185 defendant Gayler Daniel yeoman 640243 640243 Gayler, Daniel, of Bourne, yeoman 2
4234466 2107597 2107597 defendant Barton Vincent yeoman 640243 640243 Barton, Vincent, of Bourne, yeoman 0
4257441 2115462 2115462 defendant Pecke Thomas yeoman 640243 640243 Pecke, Thomas, of Bourne, yeoman 0
4257442 2115462 2115462 defendant Pecke Andrew husbandman 640243 640243 Pecke, Andrew, of Bourne, husbandman 1
4260792 2116574 2116574 defendant Smythergill Henry yeoman 640243 640243 Smythergill, Henry, of Bourne, yeoman 1
4273374 2120656 2120656 defendant Perke Thomas yeoman 640243 640243 Perke, Thomas, of Bourne, yeoman 3
4290858 2126788 2126788 defendant Warner Thomas yeoman 640243 640243 Warner, Thomas, of Bourne, yeoman 0
4292460 2127369 2127369 defendant Byns Richard laborer 640243 640243 Byns, Richard, of Bourne, laborer 1
4324951 2138728 2138728 defendant Birkett Miles husbandman 640243 640243 Birkett, Miles, of Bourne, husbandman 1
4353135 2148325 2148325 defendant Osborne William butcher 640243 640243 Osborne, William, of Bourne, butcher 0
4353136 2148325 2148325 defendant Awmond or Almond Thomas laborer 640243 640243 Awmond or Almond, Thomas, of Bourne, laborer 1
4353137 2148325 2148325 defendant Awmond or Almond Edward laborer 640243 640243 Awmond or Almond, Edward, of Bourne, laborer 2
4353139 2148326 2148326 defendant Osborne William butcher 640243 640243 Osborne, William, of Bourne, butcher 0
4353140 2148326 2148326 defendant Awmond or Almond Thomas laborer 640243 640243 Awmond or Almond, Thomas, of Bourne, laborer 1
4353141 2148326 2148326 defendant Awmond or Almond Edward laborer 640243 640243 Awmond or Almond, Edward, of Bourne, laborer 2
4397383 2163704 2163704 defendant Sabsforthe Richard carpenter 640243 640243 Sabsforthe, Richard, of Bourne, carpenter 0
4572830 2223040 2223040 defendant Gardener John   640243 640243 Gardener, John, of Bourne 0
4575511 2223847 2223847 defendant Barbour John   640243 640243 Barbour, John, of Bourne 1
4655667 2247656 2247656 defendant Grauncher Simon shipman 640243 640243 Grauncher, Simon, of Bourne, shipman 0
4655668 2247656 2247656 defendant Tutte John husbandman 640243 640243 Tutte, John, of Bourne, husbandman 1
4655669 2247656 2247656 defendant Mewe William husbandman 640243 640243 Mewe, William, of Bourne, husbandman 2
4698373 2264969 2264969 defendant Chapman Simon   640243 640243 Chapman, Simon, of Bourne 1
4702255 2266114 2266114 plaintiff Gudelake John   640243 640243 Gudelake, John, of Bourne 0
4706194 2267314 2267314 defendant Chapman Simon   640243 640243 Chapman, Simon, of Bourne 1
4717732 2270882 2270882 defendant Queyfe John tailor 640243 640243 Queyfe, John, of Bourne, tailor 0
4751155 2280816 2280816 defendant Frankwell William husbandman 640243 640243 Frankwell, William, of Bourne, husbandman 0
4787960 2292302 2292302 defendant Maundevyle Michael husbandman 640243 640243 Maundevyle, Michael, of Bourne, husbandman 0
4842596 2309221 2309221 defendant Melt Walter singleman 640243 640243 Melt, Walter, of Bourne, singleman 0
4881272 2321047 2321047 defendant Profoot Thomas husbandman 640243 640243 Profoot, Thomas, of Bourne, husbandman 0
4894459 2324941 2324941 defendant Rolf Richard shipman 640243 640243 Rolf, Richard, of Bourne, shipman 2
5295351 2443634 2443634 defendant Hereman John butcher 640243 640243 Hereman, John, of Bourne, butcher 0
5624052 2551469 2551469 defendant Hardyng John husbandman 640243 640243 Hardyng, John, of Bourne, 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);