names

70 rows where place_id = 594733

✎ 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
3617318 1873042 1873042 defendant Rande Richard butcher 594733 594733 Rande, Richard, of Sydyngbourne, butcher 0
3777198 1950621 1950621 plaintiff Cheynye John (legal representative) 594733 594733 Cheynye, John, of Sydyngbourne, esq, executors of 0
3777203 1950622 1950622 plaintiff Cheynye John (legal representative) 594733 594733 Cheynye, John, of Sydyngbourne, esq, executors of 0
3777211 1950623 1950623 plaintiff Cheynye John (legal representative) 594733 594733 Cheynye, John, of Sydyngbourne, esq, executors of 0
4459091 2187887 2187887 defendant Smyth William   594733 594733 Smyth, William, of Sydyngbourne 0
4459092 2187887 2187887 defendant atte Gore Robert   594733 594733 atte Gore, Robert, of Sydyngbourne 1
4475107 2192884 2192884 defendant Towe John   594733 594733 Towe, John, of Sydyngbourne 0
4489582 2197459 2197459 defendant Wych John   594733 594733 Wych, John, of Sydyngbourne, vicar 4
4505375 2202213 2202213 defendant Tewe John   594733 594733 Tewe, John, of Sydyngbourne 0
4577132 2224358 2224358 plaintiff Byrton Henry de   594733 594733 Byrton, Henry de, of Sydyngbourne 0
4664042 2250242 2250242 defendant Soudere or Sondere William laborer 594733 594733 Soudere or Sondere, William, of Sydyngbourne, laborer 1
4665183 2250594 2250594 defendant Andrewe John husbandman 594733 594733 Andrewe, John, of Sydyngbourne, husbandman 0
4665416 2250659 2250659 defendant Roke John   594733 594733 Roke, John, of Sydyngbourne 0
4674985 2257787 2257787 defendant Rook John yeoman 594733 594733 Rook, John, of Sydyngbourne, yeoman 0
4680175 2259408 2259408 defendant Dawe John skinner 594733 594733 Dawe, John, of Sydyngbourne, skinner 1
4719430 2271421 2271421 defendant Choune John husbandman 594733 594733 Choune, John, of Sydyngbourne, husbandman 4
4742370 2278261 2278261 defendant Simkyn John yeoman 594733 594733 Simkyn, John, of Sydyngbourne, yeoman 0
4742374 2278263 2278263 defendant Dawe John   594733 594733 Dawe, John, of Sydyngbourne, bailiff 0
4742375 2278263 2278263 defendant Trite John shoemaker 594733 594733 Trite, John, of Sydyngbourne, shoemaker 1
4779095 2289438 2289438 defendant Kiryell John husbandman 594733 594733 Kiryell, John, of Sydyngbourne, husbandman 0
4779343 2289522 2289522 defendant Wyngold John husbandman 594733 594733 Wyngold, John, of Sydyngbourne, husbandman 3
4796733 2295133 2295133 defendant Bonebrok Nicholas husbandman 594733 594733 Bonebrok, Nicholas, of Sydyngbourne, husbandman 0
4796734 2295133 2295133 defendant Tryte John shoemaker 594733 594733 Tryte, John, of Sydyngbourne, shoemaker 1
4797189 2295293 2295293 defendant Wyngold John ostler 594733 594733 Wyngold, John, of Sydyngbourne, ostler 0
4840331 2308522 2308522 defendant Latter Henry carpenter 594733 594733 Latter, Henry, of Sydyngbourne, carpenter 3
4855298 2313009 2313009 defendant atte Court William (legal representative) 594733 594733 atte Court, William, of Sydyngbourne, executor of 0
4855299 2313009 2313009 defendant Sumkyn John yeoman 594733 594733 Sumkyn, John, of Sydyngbourne, yeoman 1
4868904 2317250 2317250 defendant Gylis William laborer 594733 594733 Gylis, William, of Sydyngbourne, laborer 2
4876125 2319493 2319493 defendant Meryweder Reginald laborer 594733 594733 Meryweder, Reginald, of Sydyngbourne, laborer 1
4876671 2319675 2319675 defendant Coke William   594733 594733 Coke, William, of Sydyngbourne, "wolle" 0
4876926 2319751 2319751 defendant Latter Henry carpenter 594733 594733 Latter, Henry, of Sydyngbourne, carpenter 0
4887457 2322917 2322917 defendant Faunt Thomas baker 594733 594733 Faunt, Thomas, of Sydyngbourne, baker 1
4894106 2324853 2324853 defendant Barkere John   594733 594733 Barkere, John, of Sydyngbourne, bailiff 1
4907265 2328836 2328836 defendant Trewe Thomas smith 594733 594733 Trewe, Thomas, of Sydyngbourne, smith 0
4950019 2341974 2341974 defendant Lovelle Lawrence stainer 594733 594733 Lovelle, Lawrence, of Sydyngbourne, stainer 0
4950455 2342109 2342109 defendant Stonestrete Lawrence wooder 594733 594733 Stonestrete, Lawrence, of Sydyngbourne, wooder 1
4956892 2344021 2344021 defendant Munde William yeoman 594733 594733 Munde, William, of Sydyngbourne, yeoman 0
4978386 2350483 2350483 defendant Springet William yeoman 594733 594733 Springet, William, of Sydyngbourne, yeoman 0
4990465 2354060 2354060 defendant Cayme William yeoman 594733 594733 Cayme, William, of Sydyngbourne, yeoman 0
5003933 2358040 2358040 defendant Wade Warin husbandman 594733 594733 Wade, Warin, of Sydyngbourne, husbandman 0
5003934 2358040 2358040 defendant Latter Henry carpenter 594733 594733 Latter, Henry, of Sydyngbourne, carpenter 1
5014424 2361083 2361083 defendant Gylot Robert laborer 594733 594733 Gylot, Robert, of Sydyngbourne, laborer 1
5031781 2366167 2366167 defendant Stonstrete Lawrence ostler 594733 594733 (Stonstrete, Lawrence, of Sydyngbourne, ostler 1
5032504 2366388 2366388 defendant Faunte Thomas baker 594733 594733 Faunte, Thomas, of Sydyngbourne, baker 0
5033652 2366723 2366723 defendant Stonstrete Lawrence yeoman 594733 594733 (Stonstrete, Lawrence, of Sydyngbourne, yeoman 1
5080833 2380757 2380757 defendant Loksmyth John husbandman 594733 594733 Loksmyth, John, of Sydyngbourne, husbandman 4
5080930 2380791 2380791 defendant Burbroke Roger yeoman 594733 594733 Burbroke, Roger, of Sydyngbourne, yeoman 0
5083304 2381507 2381507 defendant Lovell Lawrence ostler 594733 594733 Lovell, Lawrence, of Sydyngbourne, ostler 2
5083727 2381636 2381636 defendant Barker John yeoman 594733 594733 Barker, John, of Sydyngbourne, yeoman 2
5083769 2381648 2381648 defendant Bryan Juliana   594733 594733 Bryan, Juliana, of Sydyngbourne, servant 1
5092243 2384113 2384113 defendant Faunte Thomas, senior baker 594733 594733 Faunte, Thomas, senior, of Sydyngbourne, baker 0
5092244 2384113 2384113 defendant Faunte Thomas, junior baker 594733 594733 Faunte, Thomas, junior, of Sydyngbourne, baker 1
5092771 2384264 2384264 defendant Domner John (legal representative) 594733 594733 Domner, John, of Sydyngbourne, yeoman, administratrix of 0
5092772 2384264 2384264 defendant Domner Margaret widow 594733 594733 Domner, Margaret, of Sydyngbourne, widow 1
5100991 2386700 2386700 plaintiff Andrewe Richard   594733 594733 Andrewe, Richard, of Sydyngbourne 0
5116634 2391297 2391297 defendant Burbroke Nicholas   594733 594733 Burbroke, Nicholas, of Sydyngbourne 0
5145717 2399890 2399890 defendant Husee John esq 594733 594733 Husee, John, of Sydyngbourne, esq 0
5214860 2420065 2420065 defendant Faunt Thomas laborer 594733 594733 Faunt, Thomas, of Sydyngbourne, laborer 1
5216105 2420441 2420441 defendant Barker William yeoman 594733 594733 Barker, William, of Sydyngbourne, yeoman 1
5216106 2420441 2420441 defendant Mayhewe John   594733 594733 Mayhewe, John, of Sydyngbourne, cook 2
5216110 2420442 2420442 defendant Umfrey John   594733 594733 Umfrey, John, of Sydyngbourne, franklin 1
5216111 2420442 2420442 defendant Mayhewe Thomas husbandman 594733 594733 Mayhewe, Thomas, of Sydyngbourne, husbandman 2
5234202 2425593 2425593 defendant Umfrey John husbandman 594733 594733 Umfrey, John, of Sydyngbourne, husbandman 0
5234740 2425748 2425748 defendant Umfrey John   594733 594733 Umfrey, John, of Sydyngbourne, franklin 1
5234741 2425748 2425748 defendant Mayhewe Thomas husbandman 594733 594733 Mayhewe, Thomas, of Sydyngbourne, husbandman 2
5255034 2431691 2431691 defendant Milys John chapman 594733 594733 Milys, John, of Sydyngbourne, chapman 0
5337258 2456215 2456215 defendant Vyncent Thomas scrivener 594733 594733 Vyncent, Thomas, of Sydyngbourne, scrivener 0
5337259 2456215 2456215 defendant Claxton Christopher tailor 594733 594733 Claxton, Christopher, of Sydyngbourne, tailor 1
5627424 2552547 2552547 defendant Mellere Thomas smith 594733 594733 Mellere, Thomas, of Sydyngbourne, smith 0
5633400 2554442 2554442 plaintiff Teghe John   594733 594733 Teghe, John, of Sydyngbourne 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);